Once connected to SQL Server you can run.

select name

from master.dbo.sysdatabases

where has_dbaccess(name) = 1 --look at databases to which you have access

AND NAME =...

inside a cursor (I must note this is the general idea a cursor is not always the best way to go) Call something like ---->

--OUTSIDE CURSOR

CREATE TABLE #Temp1

(MaxID INT

,MinID...

So you can not change the Design of the table because of a ForegineKey error? How is the Foregine setup Key? And have you checked for a DB corruption? 

You could restore the database to another location or another name then drop and import the restored tables.

Not sure. But I found this link that they are talking about a similar issue and a possible work around.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=236203&SiteID=1

Did you try to look and see if it is being help by the OS. If on Windows OS you can go to the MMC and look at the Sessions...

good to know. Thanks

SQL Server 2005 has the ability to track table changes, if you create the appropriate triggers. Then you will know what has changed and when. You can find info on...

You can use the SQL REPLACE Function in the Select statment if the domain is always the same. Or I agree you will have to use something like SQL CHARINDEX...

what is the error that is generated?

Yes the update script run as a DTS execute SQL Script can update the permanent table. However you may have problems using a temp table in the update script. you...

Sorry but I have to agree. If you did not use sp_detach_db then you probably can not attach. But for the sack of trying everything.

Create a shell database with the...

This is many times a problem with the disk sub system. I would suggest you contact product support.  Diagnosing the cause of an IO completion stall requires several logs from the...

putting the data from the file in to a table is the way to go. You may have to make the table a permante table to do this but here...

I am not completely certain the INNER JOIN will run faster then the subquery (it all depends) but here is an example of how to use a subquery and join...