Matt,

when do you get this error ? While attaching the database, then probably the path you supplied in the is not correct. Also make sure that the user executing...

Matt,

attaching a datbase doesn't change settings like read_only or Single_user, no matter if you do it through the GUI or through sp_attachDb.

Your database must be in read_only mode. What...

Agson,

I think DTexec onlu works with SSIS packages. Legacy DTS packages you can either run through DTSrun.exe (like in SQL 2000) or by creating a SSIS package which executes the...

Janet,

I don't know why there are two backups made in your case, probably some leftovers from the migration. But about what you read " MS Upgrade Technical Resource Guide that...

Michael, yes it's possible as long as you use named instances. I'm working here with a active/active cluster running 12 instances 6 on each node.

But you have to keep in...

Just wanted to give an update. The SPN actually didn't solve the issue, but helped us to find the real problem.

What happened is that we had moved this server from...

Terry,

thanks for the response. Named pipes are enabled so that's not the issue. After moving TCP up the list I get anther error, but still Login failed for user...

JP,

have a look at http://www.sqldts.com/

You will find several examples of how to use gloabl variables to set a filename at runtime.

Markus

Terry,

looking at the code of the procedure there's nothing wrong. It should execute on both environments as long as you execute it in the correct way

Exec Get_Calls_By_MLO_By_Date @DT1= '20060712',...

Anik,

are you sure that it's not loading or is it just loading in a minimized window ? I had the same issue with some windows in Management Studio. It seems...

Ryan,

are you sure that SSIS is installed and the service started ? The error seems toindicate that SSIS is not (properly) installed.

Markus

Colin

where do you have a table/view sysusermsgs. I can't find such a table on my server. And all I can find on the web about it points to Sybase.

Markus

Colin,

we tried that already, but it doesn't work on SQL 2005. We restored the old master database as Master2, but if we try "Select * FROM master2.sys.messages" we receive an...

Open Control Panel\Add Remove programs.

Select Microsoft SQL Server 2005 --> Change

Select Workstation Components

Most database specific configurations are either included with a database backup or in a backup of the master database. If you want to save really everything you should also backup...