Odd...this works fine on my system:

function x($ComputerName, $GroupName)

{

Get-WmiObject `

-ComputerName $ComputerName `

...

Well there...

What do you get with a CATCH block like this:

BEGIN CATCH;

DECLARE @err_str VARCHAR(2048),

...

As Lowell said. Severity 16 errors do not automatically rollback your transaction (unless XACT_ABORT is ON) and are catch-able. It is possible you are running into a fatal error (Severity...

pamozer (5/7/2012)

---

So I'm thinking I wasn't completely clear in my issue. The dbmail works fine. I am trying to do a try catch in case somebody goes in...

+1

There is no sense in wrapping DB mail with a SB queue IMO.

If you don't want to mess with permissions at all...

george sibbald (5/6/2012)

---

In our shop everyone gets their own individual windows login to connect to the domain and that login ( and the groups it belongs to) is used to...

Good call George. I cannot think of any reason why you couldn't use Windows login though. You may need to use a proxy too, depending on what the jobs need...

Jeff Moden (5/4/2012)

---

opc.three (5/3/2012)

---

- Your case first...If executed by someone in the instance via a Windows Login then the SQLCLR object can access the file system in the context of...

Perry Whittle (5/4/2012)

---

Partly because of the potential for a non NTFS file system, partly because it isn't the Windows box concern. Mostly because the remote file share is an entity...

Try putting a back-tick in front of the $ sign, to escape it.

Or, you could create a new schema to place your views into and have it owned by the same entity as your table's schema. This would allow you to grant...

Perry Whittle (5/4/2012)

---

n00bDBA (5/4/2012)

---

Hi all,

Just got a NAS share for SQL backups and i wanted to look at the file allocation and disk alignment for it. Doing the normal...

I am not convinced you want an actual IDENTITY column given your comments. Can you please provide the CREATE TABLE statement and an example of the data as you want...

Are you using Check Names just to validate? i.e. are you usually provided the complete domain\account info? If so, while the GUI is good for some things, these types of...