First of all, a semi-colon command terminator DOES indeed work in dynamic SQL. I use it all the time. For example:

Use

master

Declare

@sql

When you say bew server, is it a completely new server, or did it have SQL Server installed on it previously?  If you are loading SQL 2005 with a different...

Use a semi-colon (command terminator) after the USE statement.

select @sql = 'Use MyOtherDB; create proc newsp as select 1'

I no longer have both on my workstation as we are no longer using SQL 2000 here.

Is there anything that your developers would need to do that they can't do...

Have you read this KB article? http://support.microsoft.com/kb/917406

It sounds like to me that once a DTS package has been edited in SQL 2005, it never works right in SQL 2000...

I know that Enterprise Manager is a SQL 2000 client tool and that DTS packages are SQL 2000 as well, but my question is about the database engine. Are you...

You should email the answer to everyone in the meeting,. I'm sure there are many people wanting to know the final answer ....... plus then they'll know that he is...

The reason schedules can be disabled separately is so that you can have more than 1 schedule and disable a single schedule without disabling the job. Suppose I need to...

If you are going to do this on a regular basis, create a linked server.

Are you connecting to SQL 2000 or SQL 2005 with Enterprise Manager? Enterprise Manager isn't forwards compatible with SQL 2005.

And if you truly need to use wild cards, look up PatIndex() and Stuff() in Books Online.

You should consider using transactional replication.

You can create a linked server connection to the MySQL database and execute queries directly across the linked server.

However, you don't want this in a trigger. Set up a process...

I did not get this newsletter. If this is something that I have the ability to opt out of, I probanly have done so. I will check them out though.

Maybe they did miss something. Perhaps what they need in addition to a default schema for a user is a default schema for the database. So it would assume the...