DTS or linked server would be my suggestion.

SSC

If you really need clustering, be sure that you benchmark your 30 servers and have enough hardware to support it. The clustering, unless you are geographically dispersed, won't give you...

I think there would be some gas savings, more it would be a personal savings for lots of people. As for the environment, avoiding those plane trips would save way...

My final solution was like this one:

Sue Andy Brian Steve Kevin

Blue Yellow...

First, I have some thoughts here: http://www.sqlservercentral.com/columnists/sjones/whodoyouhire.asp

second, I would always have a team interview. Put the candidate on one side of the table and the whole team, whether 2 or...

I've run both on the same XP machine and W2K3 server. The uninstall is definitely something to be careful of as there could be some dependencies. They should be separate,...

Pls don't cross post. We check all forums.

Yes you can do this. Do it just as you wrote it, perhaps using a parameter instead of the scalar value 100.

Check out this link: http://www.wardyit.com/blog/blog/archive/2006/04/26/101.aspx

The sp_helprevlogin broke with an update to ss2k5, so if you are using ss2k, be sure you keep this around.

Good advice above for moving.

You don't want growth or shrinking unless really necessary. Both slow the system, though arguably growth is worse.

You want to size appropriately and grow when needed to a size that...

The recommendation is remove these accounts unless they need access. I have done it both ways. There are times I want the administrator having sysadmin privileges, like when I'm on...

Schedule it twice, once for Fris, once for EOM. Be sure the time on the day for EOM is later than the one for Fris. Then add logic to the...

The MS licensing states you must license every processor on the box where SQL runs, whether you have set affinity or now. This means 2 CPUs = 2 per processor...

I have defragmented both ways, on and offline and they both work. The load on SQL Server might be an issue if you try to defragment when it is heavily...