I would definitely change your data model. It's a lot easier and quicker to concatenate values into a string than it is to unconcatenate (is that a word?) them.

Plus what...

If you really must have separate queries updateing the a single record in the table simultaneuosly, for the status field, instead of giving it a status of say 1 for...

Probably not relevant in this instance, but worth mentioning:  If the SQL Server is in a different domain than your Windows account, there must be a trust between the SQL Server's...

I'd be surprised if someone hasn't already written and posted that script somewhere. I would check Google first.

In my opinion, it is a bad idea to let a tool move things into production for you. Every place I have ever worked as DBA, the developers were required...

Yes, it sounds like a good idea to me.

Osql can connect to any database that the user has been granted access to.

Be sure to change the cdoSMTPServer proeprty to your SMTP mail server. Your code shows it as still using your.server.com

EXEC @hr = sp_OASetProperty @config, 'Fields(cdoSMTPServer)', 'your.server.com' -- SMTP Server

What the optimizer recognizes is that the table(s) involved in the subquery could have changes committed during the execution of the query and therefore the result set could be different...

Ken C., you are incorrect. When using Not In Or In with a subquery, SQL Server does not execute the subquery and store the dataset for comparison against the main...

First of all, you can use local temp tables in dynamic sql.

Secondly, if you really want to use a global temp table, add a column called SPID and insert @@SPID...

Or store it as an integer like the others suggested and then add a computed column that formats it in the format you want

Alter

Table

You can only do that with replication going from 2005 to 2000. SQL 2000 doesn't know about the new datatypes, so it can't transform the data types. SQL 2005 still...

Step 1. Look up the following in Books Online: extended stored procedures [SQL Server], creating

Considering that the website has been dead for quite some time, probably not.

I've never used SQL Dev Pro, so you would have to tell me what it does before I...