I believe John is right on with his comments.

CEWII

I can tell you without resevation that it does not use either xp_sendmail or sp_send_dbmail. If you are still using xp_sendmail I STRONGLY recommend moving to DB Mail if...

Right, extended stored procedures are not coded in T-SQL, they are C/C++ code in a DLL and therefore as SilverFox has commented there is no T-SQL. I too would...

I'm not familiar with any way to do this. You don't have much control over the email portion and even from the tables I haven't seen a way to...

I got to admit this is cleaner that your solution. But I would do it ENTIRELY different. I would use SSIS to loop through the list. It...

Drop the index, leave the view. Don't rebuild the index..

If the query using the view makes an explicit reference to the index using hints then and only then will...

Ok, then you have a problem. Because xp_cmdshell never returns the script can NOT go on to the next items until it comes back.

The statements that follow the xp_cmdshell,...

If the schedule is set to allow from midnight to midnight every 15 minutes with today as the start date then at the next quarter hour it should run. ...

SET NOCOUNT ON

DECLARE @Domain varchar(30)

CREATE TABLE #cmdshelloutput ( outtext varchar(255) )

INSERT #cmdshelloutput EXEC master.dbo.xp_cmdshell 'SET'

SELECT @Domain = RIGHT(outtext, LEN( outtext ) - 11 )

FROM #cmdshelloutput

WHERE ...

I would suggest looking into the db_dtsadmin, db_dtsltduser, and db_dtsoperator roles in the MSDB database.

Also from BOL

SQL Server 2005 Books Online (November 2008)

Integration Services Roles

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/9702e90c-fada-4978-a473-1b1423017d80.htm

Updated:...

emily (9/9/2009)

---

OK Sarcasm dropped. Thanks for helping.

>>1. What other statements?

Insert and updates

>>2. What is the determiner to move on?

Simply that the xp_cmdShell command was executed

<<3. Is this all in a...

Sorry, never used the term reboot for anything but the machine..

CEWII

Then you might as well drop the index on that table because it won't be used except if it is explicitly referenced.. SQL 2005 Std can create indexed views...

I don't know, I think we generally agree. The only real question is how far MA can go outside their boundries and who they can force to comply. ...

emily (9/9/2009)

---

Elliott W (9/9/2009)

---

There is no way to tell, the information provided allows for no conclusions since we don't know anything about what startup.bat or the script you are...