For 2005 you can use this to get what you're looking for

Select * from sys.dm_exec_sessions

I beleive you can run the install again and then name the new instance. (Default will no longer be an option)

hmm.. did you log out of the domain with the Domain account in question? You need to refresh your token..

lol.. He insists that he would have to rewrite most of his apps if he were to move away from ADO.. He is a silly goose for sure, but we...

Thanks Ninja.. I would have preferred he had done it like that.. but as always.. he doesn't have time to do a rewrite.. So in any case I figured...

While I don't really agree with the clustering review above - we have 5 W2003/SQL2K clusters that run without issues- I will say it seems you might be better served...

is the domain account in question in another AD group with login perms to the server? Did you completely disconnect from the sql box before trying to connect post AD...

Sounds like your cluster config.. not your rdms..

I would suggest perhaps implementing a change control policy also..

there are a couple of ways.. you can use Mgmt Studio and in object explorer you can right click on the DB you wish to copy and then click "copy...

I believe the migration wizard asks you where you wish to store the migrated package files on the second step... You could try rerunning and noting the destination.. as...

Well I don;t know that you can grab the exact DDL from the systables but this will give you some of the info

SELECT...

I believe you will need to set up a PC at home with an internet facing website (requiring a static IP from your ISP or use a dynamic DNS ...

Are these all regular tables or are you talking about the temp tables you create in the procs themselves?

Thanks Holly.. I think I found the the solution.. in a dataflow task I added an OLEDB source and funneled the results into an OLEDB command task and just mapped...