as from windows 2003 you had to enable network msdtc for linked servers to work.

The security implications are as good or as bad as your implementation - make the rights...

it's a really tiny difference. never used the wizards - I always actually test on a test server and compare results - suggest you try the same.

the micosoft methods in technet work absolutley fine between versions. have used for sql 2000 to 2008 with no problems and now use this as part of DR to keep...

If you do wish to shrink tempdb issue a checkpoint and dbcc updateusage commands first.

I usually use shrinkfile and shrink to a defined size. It's not something I'd normally do...

I'm sure someone will post to say you should have dedicated luns/drives - but real world doesn't always allow you that option, in fact I have a couple of...

no not using DPM. I personally think this is not the way to secure a production system, however, I wondered if anyone else was using this type of backup and...

Let's assume you're using x64, which AMD developed. Sorry but I really think this amd vs intel cpu stuff is a bit of anon starter.

I do believe when you get...

you need sql 2008 ( which is this forum ) and use the output statement ( see merge for further info )

really, really, really bad idea.

I worry a bit because you're asking this question, however, you must have a job to produce the daily backup so edit/cancel the job.

If you're using a maint plan (...

rdp to the server and repeat the query.

You might also want to make sure you're starting on a level playing field by stopping and starting the sql service on both...

This is why reducing permissions is always tricky. There are some pages in BOL which explain the basic rights each account requires, however ultimately it is what you do with...

I can't help directly but I get the semaphore error messages when copying files across a vpn when there are connectivity issues with the connection. I think it's to do...

I take your point but creating a new plan every time is ( or was ) the same as issuing a recompile, probably less efficient. SQL 2008 will recompile at...

my experience over 16 odd years is that it only truly works where there is a QA dept who handle/store all the scripts and manage a controlled release process.