Thanks Steve.

In the meantime I'm simply doing the negative - or looking for character NOT in the list I'm looking for.

This: SELECT PATINDEX('%[^a-z0-9]%', 'AbC12|3ABC')

Returns 6 which is correct for me.

I'm...

Thanks all for the tips.

In response your question sdoughty - I did work at a shop in the past which had something setup similar to what I was referring to -...

Thanks again.

Reading the BOL now and I do see what I'm looking for.

Quick question - assuming I create a role and give it CREATE TABLE rights - if a developer...

Mark - thanks.

That's pretty much what I'm after.

Is it possible to grant permissions to do things like CREATE TABLE or CREATE PROCEDURE without having the user be a sysAdmin?  There...

Well I got it working using a proxy user.

And most importantly NOT having my generic SQL user(who calls the SProcs) set up as a sysAdmin.

The formerly mentioned Novick article and this...

Thanks Calvin - pretty slick idea.

And in fact I may end up doing just that if I cannot get this to work.

It's just frustrating that my "Proxy user" is in...

I found this article which helped a bit but still did not solve the problem.

http://www.novicksoftware.com/Articles/SQL-Server-2000-SP3-and-xp_cmdshell-Woes.htm

All is the same up to this point in the article:

<To verify that authorization of...

BTW-

Here's the error message I get when the user is not a sysAdmin.  Regardless of my Domain user account being set as a proxy or not.

Msg 50001, Level 1, State...

Here's more detail.

- DotNet ADO code call an "ImportFile" Stored Procedure using an SQL User called USER_Generic.

- The Stored Procedure executes this code:

dtsrun /F C:\DTS\ImportAFile.dts ...

Now:

1) USER_Generic has been granted...

Thanks Mary-

However - my biggest question relates exactly to what you've just said - "Jobs".

I'm not running any Jobs at all.

I simply:

1) call a Stored Procedure which

2) runs xp_cmdshell with a dtsrun...

Thanks Steve.

However, I've tried that to no avail - here's what I've noticed.

1) The proxy setup exists under the "Job System" tab of SQL Manager.  But, I'm not using a...

Here's more:

I also tried using my NT Account to no avail - and I'm the dbo!!!

EXEC Master.dbo.xp_sqlagent_proxy_account N'SET',

 N'_MyDomain_', N'BillyWilly', N'_MyPassword_'

Nothing.

However, if I make my SQL Account (DB_Generic is the name)...

Robbac?

Hey - thanks for your posts so far - very helpful.

I still have a problem however.

If I make my SQL Server user a member of sys_Admins, all works fine.  However,...

You need to do some reading about the "INSERTED" and "DELETED" tables that SQL Serve provides for you when using Triggers.  Using these tabless will allow you yo copy only...

Thanks..

First to Colin and Jack...

Do you mean Explicit locks?  Regardless,  for my SELECT statments no - I do not explicitly create any transactions.  I just let the system use it's...