No problem. Lord knows how any of us keeps up with all of the complexity available.

I would guess that the reason for such functionality is that if you execute...

Don't have a ton of experience mapping COM object to VBScripts, so at first I am not sure how to do this with the OA procs, but you don't use...

Ah, if only I could, then I wouldn't need to do what I am doing.....

Actually, I don't know if mount points...

Looks like I can use Wayne's script as is with just a SELECT * and a DROP TABLE added and no impact on the server, so that's what I...

skcadavre (8/5/2010)

---

jeff.mason (8/5/2010)

---

We did look at that. But there are two problems with it -- 1) we'd like to not enable OLE access if we could avoid it (we...

Full backups don't generate log volume. If you're seeing the log grow then something else is happening during the full log backup. You're not going to fix this...

We did look at that. But there are two problems with it -- 1) we'd like to not enable OLE access if we could avoid it (we see it...

Only in...

If you could read encrypted stored procedures, what would be the point of encrypting them in the first place....?

The trick to dealing with this question is to realize that the addition to 2008 and up was in the performance counters exposed to Performance Monitor. You could see...

2008 is supposed to delete the temp tables on completion of the SP as well, that didn't change...

Also reindexing will cause filegrowth, both on the data files and on the index files (I don't see bulk loading setting making a huge dent in this), and in many...

Not only would you get a gain out of that, if the 3rd party allows it you could get an even bigger gain by putting tables on one disk and...

Old SQL Server 2000 32 bit installs didn't know how to handle 64 bit linked servers. That proc just allows them to do it. It's standard on more...

Yeah, as long as it doesn't take a long time (like a few days) and the other jobs start deleting the log backups, that should work. Log backups will...