Hello,

Does SQL Server Query Analyzer support VBA and macros? I have some pretty repetitive tasks that I would like to automate... Or does anybody know of an alternative solution?

Thanks,

Brian

__________________
Brian

Sounds like a job for SQL Server DTS (Data Transformation Services).

That allows you to create packages that can do data transfers, updates / deletes, exports, run VB Scripts, send e-mail and a whole lot of other stuff.

Look for DTS in the Books Online, or start with the Data Transformation Services node under your SQL Server in the EM.

Update: hmmm, I *just* saw your post in a DTS forum, so it looks like you know how to use it....

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Hey,

Yeah, I've been using DTS at work for a couple projects. Awesome tool. To go a little further into what I want to do:

I need to provide IO statistics and execution plans for my stored procedures to the DBA's. I had posted a while ago about this, but with all the individuals helping me try to find a solution, none of us could come up with an answer (we couldn't do it programmibly via vbscript or VB at the time, didn't try .NET).

See I'm somewhat lazy (although it is justified; I have 120 procs to provide this information for) but I wanted to find an easier way to do this other than copy/paste the queries in and select run in query analyzer. I thought that maybe Query Analyzer supported VBA or macros, but I wasn't sure, and hence the post.

The only way, so far, to cut down on the time was I created a vbscript to create the statements to copy/paste in (by selecting from the INFORMATION_SCHEMA.ROUTINES view), but I want to take this a step further.

Thanks,

Brian

Right, in that case, DTS is not going to be much good.

I am not sure if there is a programmatic access to these plans. Maybe a little VB app with SendKeys (yuk) will do the trick....

Or hire a monkey.... ;)


Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Light My Fire (Live) by Massive Attack (Track 10 from the album: Protection) What's This?