You have to do a backup database to get a copy of the users entered records, then you can drop and move to a new location.

"Don't roll your eyes at...

Actually I think epol suggestion is great but I would take it one step further. I would create a Stored Procedure for each possiblity and a centrally called procedure following...

See http://support.microsoft.com/default.aspx?scid=kb;en-us;Q224071 for additional information on moving databases and their files.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

You can't use a case to define the table choice. Dynamic SQL or using If Else logic and maybe multiple stored procedures for storing individual execution plans is your other...

Check out http://support.microsoft.com/default.aspx?scid=kb;en-us;Q222628 and see if applies to your case or at least offers the fix.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston...

Can yuo post the section of code back to the creation of your objects. (Note change sensitive informtion like usernames and passwords whe posting). I need to see your logic...

Start here and see if any of these help first. http://search.support.microsoft.com/search/default.aspx?Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&Product=sql&Query=time-out%2520expired&Queryc=time-out+expired&withinResults=false&srchstep=0&KeywordType=PHRASE&Titles=false&numDays=&maxResults=25

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

COuld be an issue with the hooks to stop and the start the mail process that is causing this. Have you tried in QA to run the first start and...

Please do not cross post, see replies at http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=4217&FORUM_ID=5&CAT_ID=1&Topic_Title=xp%5Fstartmail+and+switching+profiles&Forum_Title=Administration

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Yeah it does become kind of hard to get very specific especially since index changes and adding of column statistics can potentially change the process. Hoever the query engine is...

If you look at the backupset table the field backup_size is the number of bytes of the backup, but for the size of the backup file add 1536 which is...

Definently sounds like a DTS process. This way you can map the old schema to the new one and import the data to the new schema. You can also build...

What is the error you are getting. And how have you defined your Linked servers connection with regards to your ODBC connection.

"Don't roll your eyes at me. I will tape...

No Select trigger exists. As for firing an sp when a user connects, this has to be built into the logic of the application they are using. At this time...

To watch what SQL is doing run in QA with Show execution plan on. The query engine will make some decisions which can vary based on the data itself and...