Pink was the development name for OS/2....

Oh I just now caught the v 2002 in the initial post. I hadn't noticed ANY version mentioned until then.

I used to take those "Pink" support calls....ugh.....

About the only way to emulate this is to create a passthrough query object, which you repopulate with a somewhat dynamic call. Of course - this will create a...

both approaches have their sterengths and weaknesses. On the one side - I've found that it can be best to abstract all of the linked server names, so that...

There's also an additional concern with xp_sendmail, which is that it is a synchronous operation. Meaning - because it is MAPI-based, it expects synchronous responsiveness from the account you're...

I can't claim to give you a comprehensive run-down of the differences. That being said - my understanding of the ONLINE restore and indexing functionality is that the objects...

You're trying to sneak in dynamic SQL without actually treat it as dynamic SQL.

The only way to do something like that is to wrap the entire statement into something dynamic,...

You set up the IIS app pools to use different service accounts which then map to different app roles in SQL. You can then set up different app pools...

Try allowing remote connections from Surface configuration tool. Also - make sure TCP/IP and/or named pipes are enabled.

Creating the SQL server resource in Cluster admin isn't going to be your problem. What IS going to be your problem is that you would have to modify at...

For better or for worse - if you find yourself pressed for time, read the questions FIRST, and then head into the case study. I find it helps me...

You might care to look into Notification services as well. This looks to be a good match for that in terms of generating timely "messages". It seems like...

I'm going to go get a sweater - it just got chilly in here;)

Be careful with the "compare encrypted variables". That will work only for exact matches. OP mentioned wanting to use a LIKE syntax, which if run against encrypted data...