Push a row into a table, then have a job poll the table and launch the main job if needed. Or just have the main job run, check the table,...

One way would be to add a timestamp to the table, only do the update if the timestamp was the same. If changed, then you'd have to do conflict resolution...

Not a lot that I can tell. AD really impacts in two places. One is authentication, the other is allowing your credentials to pass through to a linked server. Listing...

This will do it:

Dim oserver As SQLDMO.SQLServer

'create standard server object first

Set oserver = New SQLDMO.SQLServer

With oserver

.LoginSecure = True

.Connect "yourserver"

End With

oserver.KillDatabase "yourdb"

oserver.DisConnect

Set oserver...

Killdatabase is a DMO method, you'd have to instantiate it either in VB code, VBScript, or usin the sp_oa~ procs.

Andy

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

If you have ideas you can send them directly to MS - sqlwish@microsoft.com.

Andy

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

Good discussion. Is there a reason they are mandating the dynamic sql? If you're doing all dynamic sql is there any gain from doing it in a proc vs doing...

I agree that putting the logs on the RAID5 gives you some fault tolerance, more importantly gives you three disks instead of two for your data. Although not recommended...

I think we can probably do something with that. Im still working on finishing zero topics and some work on books, will try to get to it after that.

Andy

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

I think at some point DTS becomes limiting and you might be better off to wrap the whole thing in a exe. Better tools, better error handling, statement completion! Logging...

Saw a similar issue, might help:

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=eDJEyjZDCHA.2248%40tkmsftngp02&rnum=3&prev=/groups%3Fq%3DThe%2Bsubscription%2Bto%2Bpublication%2B%2Bis%2Binvalid.%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26selm%3DeDJEyjZDCHA.2248%2540tkmsftngp02%26rnum%3D3

Andy

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

One way would be increase the transaction level to serialized - though that will slow things down. Another is to just trap for deadlocks and have the app issue a...

Again, if there is enough interest we'd look at it. Keep in mind that even though we dont have a particular forum doesnt mean you cant post to one that...

We've talked some about MSDE. Certainly it has a few unique issues that are worth discussing at times. Not as sure about ASP.Net. If we do that then we'd probably...

Stopping the deletes doesnt seem bad, though it may impact reports and apps if you need to treat them as deleted even though they still exist. Removing the foreignkeys on...