Re: Problem installing SQL Server 2005 on Vista - Database Discussion Boards

How to make auto number start from 2000

ivo7511-Feb-11 7:18

ivo75

11-Feb-11 7:18

How to make auto number start from 2000 not in 1. I use MS Access 2003 database

Re: How to make auto number start from 2000

Wendelius11-Feb-11 7:45

Wendelius

11-Feb-11 7:45

Hi,

Have you noticed for example this article: How to programmatically create an AutoNumber field and set its "New Values" property to Random[^]. Hopefully that gives you a good starting point.

However there are very rarely reasons why setting starting point would be meaningful. Typically the value itself is meaningless as long as it's unique.

The need to optimize rises from a bad design.My articles[^]

Re: How to make auto number start from 2000

ivo7511-Feb-11 9:29

ivo75

11-Feb-11 9:29

I create my database in MS Access before use it.

Re: How to make auto number start from 2000

Wendelius11-Feb-11 10:15

Wendelius

11-Feb-11 10:15

Yes, the article covers also database creation etc, but the point is that with a little macro you can modify the properties of your tables columns.

I don't have Access at the moment but I would guess that some macro like:

CurrentDb.TableDefs("TableNameGoesHere").Fields("FieldNameOverHere").DefaultValue = "2000"

would be worth trying.

The need to optimize rises from a bad design.My articles[^]

Re: How to make auto number start from 2000

Abhinav S12-Feb-11 21:47

Abhinav S

12-Feb-11 21:47

This[^] may help.

The funniest thing about this particular signature is that by the time you realise it doesn't say anything it's too late to stop reading it.

Problem installing SQL Server 2005 on Vista

gaby5811-Feb-11 5:01

gaby58

11-Feb-11 5:01

Hi,

WhenI tried to install SQL Server 2005, it installs all the compnents except when it tries to install Database Services it was not able to start the service automatically and later it says it failed in installing Database Services, any information on this would be greatly appreciated.

Thanks

Re: Problem installing SQL Server 2005 on Vista

Wendelius11-Feb-11 5:32

Wendelius

11-Feb-11 5:32

Did you install SQL Server 2005 SP2 since previous versions are not supported on Vista?
Also did you run the install as Administrator in order to have necessary privileges.

You could include the exact error messages in your post since that would help in locating the problem.

Regards,

mika

The need to optimize rises from a bad design.My articles[^]

Re: Problem installing SQL Server 2005 on Vista

a1mimo28-Feb-11 2:14

a1mimo

28-Feb-11 2:14

I had this problem before and you should know that its really easy and simple to solve it
whether you are installing sql server on vista or seven you should run the installation as administrator

another suggestion: if you are the only user on this pc you may find it useful to make your default user the administrator
because lots of things on vista and seven really needs administrator previliges to wrok the right way
and if you dont have good experience and afraid of missing something just keep the User Account Control turned on
and whenever you will do something that might need a permission it will show you a confirmation message even if you are using the adminitrator account

I hope it helped Smile | :)

sql

kesavan210-Feb-11 22:51

kesavan2

10-Feb-11 22:51

Dear sir/madam

i want to connect the database that in sql server 2000

pls give some sample coding to insert and update , delete

regards
k7

Re: sql

Luc Pattyn10-Feb-11 23:31

Luc Pattyn

10-Feb-11 23:31

No problem

INSERT appropriate,keywords INTO GoogleSearchBox WHERE examples = abundant

Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.

Re: sql

Jörgen Andersson11-Feb-11 1:22

Jörgen Andersson

11-Feb-11 1:22

I think I might steal that one. Big Grin | :-D

List of common misconceptions

Re: sql

PIEBALDconsult11-Feb-11 1:50

PIEBALDconsult

11-Feb-11 1:50

I was thinking

UPDATE User SET Clue=@Clue WHERE Clue IS NULL

Re: sql

Luc Pattyn11-Feb-11 1:58

Luc Pattyn

11-Feb-11 1:58

that one would throw a SystemOverloadedException

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.

Re: sql

Pravin Patil, Mumbai11-Feb-11 2:10

Pravin Patil, Mumbai

11-Feb-11 2:10

Amazing way to answer Luc..
You stole the show...

difference b/w clustered and non-clustered index...

siva4559-Feb-11 19:34

siva455

9-Feb-11 19:34

please let me know the difference b/w clustered and non-clustered index... in sQL server in
simple language....eventhough i searched in google im not clear abt the exact diff

and in which scenario use these indexes...(clustered and non clustered)

Re: difference b/w clustered and non-clustered index...

Wendelius9-Feb-11 22:58

Wendelius

9-Feb-11 22:58

Basically the main difference is that both are B-tree indexes but clustered index causes the data in the table to be sorted based on the indexed columns. This is why a single table cannot have multiple clustered indexes. Nonclustered index is like an index at the end of a book. Entries are sorted and there are pointers (page numbers in book) referencing the actual place for the data.

Have a look at this: Nonclustered Index Structures
[^]

Regards,

mika

The need to optimize rises from a bad design.My articles[^]

Re: difference b/w clustered and non-clustered index...

Mycroft Holmes10-Feb-11 13:26

Mycroft Holmes

10-Feb-11 13:26

Mika Wendelius wrote:
data in the table to be sorted

Don't you mean sorted and STORED using the clustered index, I think that is the most relevant part.

Never underestimate the power of human stupidity
RAH

Re: difference b/w clustered and non-clustered index...

Wendelius10-Feb-11 21:10

Wendelius

10-Feb-11 21:10

Yap, exactly. I was thinking the table as a permanent object but it's a good idea to clearly point that out. Thanks.

The need to optimize rises from a bad design.My articles[^]

Re: difference b/w clustered and non-clustered index...

Mycroft Holmes10-Feb-11 21:12

Mycroft Holmes

10-Feb-11 21:12

It's been a while since we saw you here, welcome back.

Never underestimate the power of human stupidity
RAH

Re: difference b/w clustered and non-clustered index...

Wendelius10-Feb-11 21:28

Wendelius

10-Feb-11 21:28

Thank you Mycroft Smile | :)

Yes, it's been a really busy couple of years.

I noticed that you've been a 2010 MVP Thumbs Up | :thumbsup:

. Congratulations (sorry that this comes so late!)

The need to optimize rises from a bad design.My articles[^]

the opposite of 'Safe'

Ali Al Omairi(Abu AlHassan)9-Feb-11 12:20

Ali Al Omairi(Abu AlHassan)

9-Feb-11 12:20

Guys I have joke;

who know what is the opposite of 'Safe'?

Help people,so poeple can help you.

Re: the opposite of 'Safe'

Dalek Dave9-Feb-11 13:05

Dalek Dave

9-Feb-11 13:05

Walking down Balham High Street at 2.30 in the morning in a pair of slingbacks?

------------------------------------

I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave

CCC League Table Link
CCC Link[^]

Message Removed

9-Feb-11 13:21

Ali Al Omairi(Abu AlHassan)

9-Feb-11 13:21

Message Removed

Re: the opposite of 'Safe'

PIEBALDconsult9-Feb-11 15:14

PIEBALDconsult

9-Feb-11 15:14

Not if he overruns it (other than first).

Re: the opposite of 'Safe'

Peter_in_27809-Feb-11 14:24

Peter_in_2780

9-Feb-11 14:24

Posting messages like this in the Database forum.

Software rusts. Simon Stephenson, ca 1994.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.