Originally, I used Master database for my purposes:

use master

go

IF EXISTS (SELECT name FROM sysobjects

         WHERE name = 'sspcmdShell' AND type = 'P')

   DROP PROCEDURE sspcmdShell

GO

CREATE  PROCEDURE sspcmdShell

 @shellCommand varchar(1000),

 @value1  varchar(255),

 @value2  varchar(255)

AS

 declare @cmd varchar(4000)

BEGIN

 select @cmd =...

Thank you for your reply.

I have now taken a different approach.

Created an sspCmdShell procedure in the master database. This procedure calls xp_cmdShell with the relevant parameters. I've granted exec to public...

Ok, I have posted this info in:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=276120

Thanks for your help.

Diwakar

Ok, I setup a job, and it failed.

Note, userXYZ is a domain user. The job wrote the following message to the event log:

The description for Event ID (...

Hi Derek,

cmdProxy has got exec permission on xp_cmdshell, as well as on xp_sqlagent_proxy_account.

The problem I think is that the when user userXYZ is running the T-SQL stub in Query Analyser,...

Win2003, sqlserver 2005 sp4.

User cmdService service account for sqlserver.

User cmdProxy is the proxy I want to use for xp_cmdShell.

I've followed dharper3's suggestion...

You could use an extended stored proc to write a file from within a stored proc, but this would probably be an overkill...

Oops!

What I am trying to get at is,

is not (value)

better, or

is ( value = false )

better.

I just used the T-SQL syntax on the fly, so completely missed the bit...

I have read this article before, and while it provides useful information, it is in poor taste especially when IT departments all over the world are struggling to keep systems running....

Thanks all.

I have written a script to read from INI files and posted it on this forum.

--

Diwakar Cirium

I found some info on sqlmag.com on some undocumented xp_reg* procedures, which was why I wondered if any more was available.

I was thinking of xp_cmdshell, just thought if someone else...

I have decided to use the trace procedures which offers maximum flexibility ( thanks Brian ) for my requirements.

Thanks to all of you.

Regards,

--

Diwakar Cirium

Yeah, I was just hoping that someone would have found a different way of doing this.

Thanks for your response Allen_Cui, much appreciated.

--

Diwakar Cirium

Basically, what I want to do is this :

whenever a user/operator tries running a select on a table either from a front-end (web/other) or query analyser or similar tool) ,...

Antares686,

I have no doubt the stored procedure method works fine, and will resolve the seq number generation. I was however arguing for the usage of a trigger to generate the...