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...

I tend to agree with you, Wayne. No time for silly "how do you think" questions. But that's why I wouldn't work for Microsoft: I don't fit in. They're looking...

We can coordinate if you'd like and we had a number of people take their names out of the running for prizes, myself included.

Best wishes from me as well.

Great answer!!!!

That's probably why you got hired. Thinking business in practical terms.

Make sure you're using TCP/IP. Named Pipes usually is only for local connections.

We used to use a few at different times. We've run DELL servers and they can notify you when there's a failure with their system software.

We've also had the vendor's...