We are looking at a similar issue in migrating two AD forests to a 3rd new forest. Fortunately the network guys have prepopulated all accounts in the new domain/forest.

the fix...

Wow, that surely isn't about SQL.

I know Andy has an IP phone at home, but not sure if he knows. He's a...

The above suggestion is correct. ANY user, including yourself that has a session open to that db has a shared lock on the db.

Not in your area, but there are a few online places, like IMG University (http://www.imguniversity.com/WebUPublic/default.asp). I took a remote class and it was ok.

http://www.sqlservercentral.com/columnists/sjones/imguniversity_olap.asp

Suggestions above are good. Be sure all connection options are the same. I'd also be wary of dbcc freeprocache as it wipes all query plans out and could cause performance...

If you always drop/create instead of alter, then you can use sysobjects.crdate to find changes. RedGAte and others have tools to give you a list of differences in objects between...

You will always convert to string for the exec() statement. However, I think for other values, you should be able to determine the field type from information_schema.columns and then set...

sp_helpdb will also erturn this, but you have to parse the info.

are there any routers/firewalls in the way? Be sure that you can get to UDP 1434 for the remote machine to "find" the instance port. Alternatively you can set teh...

Great introductory article to looking at performance. The suggestions above are good, but most code might be improved if each developer took a few minutes to run these and see...

If this actually occurs, it's a bug. Call PSS.

I don't believe Windows 2000 can do this. Windows 2003 is supposed to be able to tell which are physical and which are logical, but I doubt that SQL Server...

If you can't get this, you can uninstall, reinstall and attach your dbs. You'd lose your pwds and logins, but no data.

As far as this system is concerned, it's a DW backend for a Microstrategy backend, so many of the peaks are not tunable. End suers pick a few things and...

There are no arrays in TSQL, however since the value that is returned is from a field and based on anothre field value, I'd suspect that a join is what...