The identity function will assign a unique number for each table as Chris said. However I would suggest you search for articles or threads that deal with primary keys and...

You must pass the function an input param. If you pass a null value then the default value will be used.

HTH

Mike

Check BOL for Handling Errors and Messages in ADO . Index key word error object. The example uses a list object to store the error values but it should be...

Hector I am a little confused do you want to have the sp print the variable in vb or in query analyzer? Your offer of a cold beer reminded me that...

The difference function uses soundex under the hood. It just gives you the degree of match be a value between 0 and 4 where 4 is a perfect macth (both...

How true once upon a time I could speak enough French to order a glass of wine and ask a girl to dance and Gernan to order beer (they do...

set your variable before your select statement. Declare t int

Execute sp_somesp t --the variable t will contain an int from the sp

or Execute T=sp_somesp --t will contain the value...

Frank People who can communicate in more than one language truly amaze me. English is my native language (and only language much to my regret) and I often trip/fall...

"Unfortunately it fails, when you require a certain order."

Requiring a certain order just requires careful coding. A where statement will...

From BOL

The dbo is a user that has implied permissions to perform all activities in the database. Any member of the sysadmin fixed server role who uses a database is...

"Looks like you have the same object with different owners."

After rebooting the system my problem went away. Or at least is hidding until I am sleep typing one day when he (or...

checking for duplicates I found: Any help here would be good. I thought that the ID had to be unique within each db.

Mike

SELECT [id],[name],[colid] FROM dbo.syscolumns

GROUP BY [id],[name],[colid]

HAVING COUNT(*) >...

Thanks I will try that. I agree that I should not be getting this error.

Mike

Well ?? after running the code I get an error.

Server: Msg 2627, Level 14, State 2, Line 2

Violation of UNIQUE KEY constraint 'PK_Test'. Cannot insert duplicate key in object 'Test'.

The...