You can create a config file for a package

Opening the package in BIDS

Right click the package work area

Select Package configurations.

Its probably worth having read of BOL:

http://msdn.microsoft.com/en-us/library/ms137900.aspx

This talks about config files...

I generally don't auto shrink any databases....

Temp db was obviuosly under a heavy load, that forced it to grow, with autoshrink turned off the TEMPDB will remain at its...

not a lot to go on...but do you have a config file setup for the package? If so what is the connection specified to in that file. If it is...

me neither.

the sp_change_users_login will only work for SQL logins and users.

If the problem is Windows users, simply try creating the windows login on the server without giving db access, ie...

There was an interesting article on this site this morning, I think it was a link to MSSQLTIPs that showed how to read the error log for failed logins...

The link...

Jonathan Kehayias (5/27/2009)

---

GRE (5/27/2009)

---

I think there occaions when an deatach/attach is the best option especially when dealing with larger databases and you only have native SQL backup to use...Sometimes you...

don_goodman (5/27/2009)

---

It is a terrible practice to detach a database from a production server. If you had any corruption in any database file or in the server itself, you will...

Noel McKinney (5/27/2009)

---

GRE (5/27/2009)

---

Have i missed a trick here? I understand that the old way to attach a database is be depreciated, But is SP_Detach_DB bein decreciated too? or will...

GRE (5/27/2009)

--------------------------------------------------------------------------------

Have i missed a trick here? I understand that the old way to attach a database is be depreciated, But is SP_Detach_DB bein decreciated too? or will that remain?

Yes,...

Have i missed a trick here? I understand that the old way to attach a database is be depreciated, But is SP_Detach_DB bein decreciated too? or will that remain?

have you tried using SSIS or the export data wizard. These will craete the neccessary tabs in Excel for you

Have you specified the instance name too?

I haven't read Manu's doc but -2 spid is related to MSDTC...

I have had an orphaned spid (-2) previousl and it was related to a (MSDTC) transaction rolling back.

read the...

I have had a problem smilar to this previously. An SP takes x amount longer when called through the application than when executed in Management Studio. The only noticable dfference...