"Again, using the 70-229 as an example, why would one even pursue a certification if their job does not involve using most of the features tested for on the exam?...

Troy - you dismay me - I too am going through the SQL books for 229 and trying to muster up the courage to take at least one exam -...

Books online has a fairly comprehensive explanation on "locking" various database objects and resources including databases themselves...

I used to swear by wrox press books but I believe they've been bought over..at any rate, there's a book called "Professional - sql server 2000 programming" by Robert Vieira...

Sql server 2000 supports a max of 249 nonclustered indexes

I'm pressed for time so sending you what logic/concept I could think of off the top of my head - maybe you can use it to "play around" or see...

Yashar,

Here's some things you can try:

1) In Query Analyzer do a select user_name() to ensure that logging in via both PCs shows identical user names.

2) Ditto with "Log" in Enterprise...

I'm not sure if I understood the problem correctly but the simplest solution I can think of is to add another audit table - with the PK of table1 as...

Try using this:

Select * from Tablea,Tableb Where TableA.Fname + TableA.Lname = select replace(Tableb.Fullname, ' ', '')

I'm confused about a couple of things...

Are you using Northwind only as an example or are you actually trying to generate a script for "Categories" ?!

You say that all other...

1) What kind of a script are you trying to generate ?!

2) Have you compared "roles" and "users" between the successful server and the one in which your "create" fails...

Don't know anything about this but I did find some helpful information on one website....maybe it'll help you identify the source of your problem!

*********************************

You need to be aware of a...

Try using "IF Cursor_Status('variable', '@my_cursor') = -1"

If your cursortype is 0 (forwardonly) change your locktype to 1 and test....

See your name everyday...with either solutions, responses or comments...looks like it paid off..remember reading Remi's comments from a few days ago saying "at this rate you'll hit 5000 soon"...

Congratulations! Congratulations!