Thanks Steve for the reply but I have these users already in a role with the basic: Create Proc,View,Table etc. Permissions.

My biggest concern was these are Application Developers that...

Lowell,

The proc produces a record set of 5-6 rows on average. What I am doing is comparing data from the cursor (The Car_ID) and finding out which row it is...

Jeff,

Thanks for the post. I wasn't aware of the Truncate option. I'll try that too although my DROP TABLE worked as well. As far as the cursor I would love...

Okay I fixed it... I needed to issue a DROP TABLE command before I called another FETCH NEXT statment from the Cursor.

Nice List! 

I found an easier way to check if a column is being updated than using the Bitmask COLUMN_UPDATED() syntax:

UPDATE (Column Name)

Thanks for the reply Ninja's_RGR'us!!!!!

To answer your question "Why would I like to add a column in a specific space in a...

bledu,

Thanks for the response.

It is only this query. I can reproduce it everytime. Actually I found out it wasn't the UNION but a WHERE clause in the UNION. Weird thing is...

Thanks much for the reply.  I am planning a migration to 2005 so it does help a lot. Thanks again.

Thanks for the links!  Plenty of reading material now!

Thank you all for your suggestions.

I ran a few traces with profiler with both options. The second one did outperform the first one. We'll be focusing on that option...

Actually I had another question. 

Does this apply to parameters as well? I'm assuming yes.. that it applies to any text that contains "password".

Thanks again.

Ah Ha!

Thanks David.

Mike,

Thanks for the reply.

I knew that a blank wasn't a null but I never knew until today that SQL casts a blank value as a zero. I validate the input...

Well I fixed it but not the optimal way. I found the ID that was missing. Renamed the table, disabled ID seed. Inserted the value in the ID column, Renabled...

Thanks much PW. It worked great.