Honestly, if you are thinking of this, I'd do it this way.

Replicate back to separate DBs on your main server. This gives you some DR stuff since you can quickly...

You might be better off with taking your list and running a "connect" to each one as a domain admin (should work) and getting the version. I think that's what...

missing a comma up there before one of the CASE statements.

CASE when ... end

is like a column. Needs commas to separate out.

You have

select x

, y

case...

The odds?

Depends on whether it was your day off or not

The code pages for the data are different. Meaning the way in which the data is encoded is causing problems. Since the OR works, I'm guessing there's some bug here.

Report...

It's the cross apply with the function that gets the text. It's not in a table, need a handle to the plan to get it.

I've run out of INTs in some situations. Like SMS, constant scan type of stuff.

Eventually it's an issue. BigINT gives you more space. If you run out, need to move...

It's a secure channel/AD thing. For some reason your token isn't being accepted.

Check times (need to be fairly synched) among machines. Check the AD channels (need a network/AD person to...

Use Verifyonly, but periodically run a restore from the backup file. It's good practice for you.

Also periodically restore from tape or whatever archive media you're using. Ensure that it's really...

Yep, same as other databases.

xp_sendmail is the best way if you are looking for the server to send mail (all coming from one box).

What are you trying to do?

No idea here. I'll try and see if I can get the author to respond.

Steve

Those are definitely good points to consider. Especially with large SANS dropping disks on a weekly basis in many places.

I'm definitely not sure if I'd want to take care of...

Luke,

That was my first thought, but I'm assuming they have some sort of RAID technology as well built in. The MAID software also periodically (I think I saw weekly from...

I don't think it's an NDA violation, so I'll give you my take.

I can't remember using any menus from the top during the simulation. You actually don't have SSMS, you...