I believe you must put the db in single user mode before attempting sp_renamedb.

exec sp_dboption dbname, 'single user', true

See BOL.

DanaH1976

Could you post some of your code that uses OLE DB instead of using a DSN.  We're in the middle of migrating...

Try this syntax...

 DTSGlobalVariables("myGV_Name").Value = myGV_Value

Yes, I can see where quotes in the T-SQL would cause SQL Server to think that the first quote it encountered due to the 'literal' was ending the SQL statement and...

I see what you're saying, but if the job was executing successfully on the old server, wouldn't that mean that the scripting should come out ok?

I'm not sure that I understand.  The jobs ran fine under the old server.  When I migrated the jobs with CDW, the jobs containing t-sql were not copied to the...

My best guess is that since the database had not been moved yet, SQL Server could not parse the T-SQL for a database that does not exist on the server...

Actually, I didn't have any problems with transferring the DTS packages over.  Just the Jobs which execute the DTSs.  If the Job had T-SQL steps, it was not moved.  Can't...

Try using something like what is shown below in an ActiveX Script task.

You should be able to apply this concept to any task.

(Also, check out http://www.SQLDTS.com)

Option Explicit

Also, something to remember about Unions:

If you use "Union", this will remove any duplication,

whereas if you use "Union All", this will retain duplicate rows.

What does your code look like?  Is this in Access VBA or VBScript in ASP?

Just some initial thoughts...

1)  Bookmark is probably a reserved keyword

2)  Set your combo box rowsource =...

I don't think that this is what I had in mind.  Let me explain.  I am migrating all databases for one server to another server.  In Query Analyzer, I have...

Is there a T-SQL command to do this? 

(instead of specifying the server name when opening QA from a command prompt)

Check out the links below:

FAQ:  http://www.sqlservercentral.com/faq/viewfaqanswer.asp?categoryid=2&faqid=154

SQL 2000: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q272318...

Thanks Frank!!!  I know when I see your name, I'm going to get some good information.  I appreciate it!!!