I liked the SQL as a graphic - stopped me from either running the code or adjusting the layout to read better. I actually feel better about having gotten it...

Does the account SQL is running under have permissions to that location?

The integer division thing in general for me is often one of those "so simple you missed it situations". I'd be interested in what is considered best practice in real...

This link might be a good start. It doesn't mention SQL specifically, however it relates to setting up a Microsoft Cluster in a virtual environment. Form my understanding you would...

I'd be interested in getting a followup to see how their implementation is coming along, especially with the # of databases to be mirrored.

I see this all the time in our VMWare environment when snapshots are running. Probably not what is happening here, but I thought I'd add to the discussion.

Thanks guys for your input. I'm glad is wasn't just me missing something fairly important.

My first thought of the term would imply two or more servers running two or more...

The groups themselves weren't numbered, however I was able to sort this by adding a 'groupby' column to my SQL query, and then create a group based on this field.

Did you ever get this working? I'm trying for a similar thing with a report of mine too.

The only way I could get event log data into SQL was to run an independent VB script, and output to a CSV file, wrapping each element in " characters...

I hadn't actually, however it might be worth a look. Thanks for the pointer!

cheers, Mark

If I understand the link correctly (I'd found it a few times googling this issue), this is about using WMI to get information on SQL server, or creating SQL Agent...

Hi there,

Did you ever get this up and running? I'm currently running a process using windows batch files, scheduled tasks, VBscript and bulk import & its all over the place.

I'm...

Hi all,

Just wanted to add to my reply yesterday, with my issues with @query from within SQL Agent.

I was able to get it to work by first running my @query...

Hi everyone,

Just thought I'd add my 2 cents worth in here. I tried for a few days to resolve this issue, including:

- Changing the logging level to verbose

- The sys.xp_logininfo...