One thing I forgot to ask. Can/should we be able to change the SID and name values in the master.sysxlogin and database.sysusers tables? If so, this would not...

You are right cmore. We are facing that problem now. Here is the only way we see of getting around this without a lot of manual work. ...

We feel the issue is that SQL Server doesn't recognize SID History as other resources do. I think there is something that can be installed on SQL Server that...

Thanks Antares686!

I had a similar instance where blocks were occurring all over the place. After digging through tons of stored procedure code and VB code, we finally found the answer....

quote:

---

Different people do it different ways. Steve Jones has a 4 part series posted about how he does it, a complicated (to...

Since DTS packages are stored in the MSDDB database as records in the SYSDTSPACKAGES table, you can select the appropriate records (package) and insert it into a different server and...