It definitely sounds permission based. I'd logon to the server as the SQL Agent user and double check that it can physically access the folder/file through the share. File permissions...

The resource governor error could be a symptom rather than a cause. Have you seen this article in your Googling?

derek.colley (5/23/2012)

---

Howard - was not knocking your effort (would be a bit rich considering my approach wasn't set based!) but I was after an ordered insert in the absence of...

SELECT TOP 50 * FROM fooTable

This is the problem. You're populating your table with 50,000 rows of data and then trying to determine whether it's done it correctly by only...

derek.colley (5/23/2012)

---

Howard, your approach is good but populates the table with only the first database name returned by SELECT name FROM sys.databases. It produces all the rows, but they...

I could write pages of explanation here, but I'd really recommend reading Jeff's article on the Tally/Numbers table [/url], which more eloquently explains it than I ever could.

With your particular...

By default, remote connections are disabled in SQL Server. Express edition is generally installed as a named instance, so you'll need to:

1) Enabled Named Pipes and/or TCP/IP in SQL Server...

This line isn't required:

myProxy = WebRequest.DefaultWebProxy() 'use default proxy setting

You're setting the proxy directly two lines further down. Not sure what the CType is for as well. I knocked up...

There's nothing fundamental that would cause SP's to run slower via a SQL Agent job than via SSMS. They certainly don't run under a different priority, but there could be...

dkschill (5/21/2012)

---

That is prettier, but I think the duration will have to be converted to seconds prior to the average and back to their format post the average.

You are...

Something like this might read a bit better (it's a horrible design, I'm surprised MS haven't deprecated it yet and designed something better):

;

--The semi-colon really belongs in the previous statement

...

Steve Jones - SSC Editor (5/21/2012)

---

The restore point makes sense, but does it drop your dbs into "recovering mode" or is it some integration that brings it back to the...

Steve Jones - SSC Editor (5/21/2012)

---

Jeff Kelly-310227 (5/21/2012)

---

it's exactly as Gila mentions.

I'm currently testing this with IBM's svc flashcopy manager.

These types of specialized SAN apps are fully SQL aware and...

SQL Kiwi (5/19/2012)

---

Highlighting (and the CTRL+] shortcut to switch between braces at the same level) is only functional when the built-in IntelliSense is enabled. This can be an irritating...

This is indeed correct - just right click on SQL Server Logs...