Starting the job is a good way. Lets you do async execution. Whether you start the job directly or put a row in a table and have the job run...

I think that is it, need 1434 if you dont know the server name. Can you ping the server? Is it a named instance? Connect via Query Analyzer?

Andy

http://www.sqlservercentral.com/columnists/awarren/

Chris, any luck getting info on this at PASS?

Andy

http://www.sqlservercentral.com/columnists/awarren/

Some of the ads do use flash. A tradeoff we went with, thought it better than allowing popups!

Andy

http://www.sqlservercentral.com/columnists/awarren/

There is a killprocess method on the server object. Dont know if there is a DMO way to get the processes directly (can always use execute to run 'select *...

If you create in the designer and script out to VB code, the annotations are lost.

Andy

http://www.sqlservercentral.com/columnists/awarren/

We dont have a step by step guide here on the site yet, you may find one at the MS site. First thing you have to decide is which type...

My two cents on declaring the objects. If Im going to use it more than once I typically declare and use it. Same idea as using a with block, want...

It probably is the ADO connection that hasnt cleared. Connection pooling can be the culprit. To be really safe, I'd recommend connecting to master, then checking sysprocesses for connections to...

I really like the feature added in 2K that lets you run pre/post snapshot scripts. Great place to customize things. In practice I rarely want the same indexes on the...

Usual recommendation is to just leave in the file system, store the filename in the db. I've always been happy with putting the docs into a blob, lets me manage...

OpenXML is a winner, lets you handle cases where you need what is basically a delimited string. We've use for xml in a few cases. Overall our use of XML...

I'd vote for one. The extra complexity of splitting it out can be managed of course, but I'd only do it when I hit a really compelling reason. One might...

If you use DMO you can get an event to fire that matches the withstats value so you can update a progress bar or whatever.

Andy

http://www.sqlservercentral.com/columnists/awarren/

You can fake it some by just including the tags as strings in your select. Not pretty, but will get you close. Beyond that there was a web release for...