Can you ping the server? Connect to it with Query Analyzer?

Andy

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

First thought..and not really an answer to your problem...is that you're doing more work than you need to by using DMO and ADO. If you're ultimately going to use the...

Glad it helped. For those following along, the server object has a disconnect method that should be called prior to setting the object to nothing. So far I've never had...

McDoneP,

Cant really argue with any of that. Im here to evangelize that you should stick to the rules until you have the experience to know when its ok to break...

Agreed. Its either TSQL or DMO, take your pick. You can leave the maintenance plan as is, just add in a job that does the differentials.

Andy

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

Have to agree a cursor sounds bad. Before you start recoding though, have you looked at the query plans to be sure the indexes are good?

Andy

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

I shouldnt answer posts early in the morning.

Andy

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

I shouldnt answer posts early in the morning.

Andy

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

I just ran the code, nothing wrong with it. I get the error if I leave a connection open - for testing I just opened the tables node in Enterprise...

Dont see anything immediately wrong - have you verified prior to running your code that no connections to the db still exist? Not just closing everything, checking in Query Analyzer?

Andy

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

Shrinkfile often isnt enough, has to do with virtual log segments. We've got a script on the site that will force the shrink:

http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=26&CategoryNm=Maintenance%20and%20Management%20&CategoryID=1

Andy

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

As you fix this I recommend adding the explicit owner - you get a slight perf boost and fix the problem at the same time.

Andy

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

You're close if I understand what you're asking. Declare your variables as before, then do this:

select @nvalue1=col1, @svalue2=col2

from table1

where col1 = 1

Andy

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

Good answer. Profiling would reveal for sure. On the subject of auditing, you're logging before and after images? Why not just log the before version, the current version would always...

One way would be launch it as a job. Another would be to execute it in a timer event and then disable the timer (so it doesn't recurse). I think...