Bill Galashan (7/12/2010)

---

Anything wrong with the event handlers already available within SSIS. It is very simple to set up an SSIS template with the event handlers coded to generate logging,...

Yeh, was planning to post it, but was rushed with the earlier posting 😀

Just replace

"<< YOUR SERVER >>" with server name

"<< INSTANCE >>" with instance name, or DEFAULT...

I have a script that runs in a Powershell script step of a SQL Agent job to do this.

Makes deployment pretty easy as it's just T-SQL to create the SQL...

Powershell would be a good option and the one I'd pursue.

However for those that don't want to dabble in Powershell and don't want to enable xp_cmdshell, you can pipe the...

ROFL

iHurt

You need to use two single quotes

eg:

@query = 'exec uspEmailSQLServerHealth10 ''192.168.1.120'', ''abc'', ''suyog.pagare@gmail.com;;'', ''test'', ''MYSELF''',

If you're editing the SQL statement in Management Studio the entire value for the @query...

Yes.

Basically the global variable has become "corrupted", the GUI interface can't handle correcting the problem, so you have to delete and re-create the variable.

You may be able to fix it...

A selection of examples

http://www.sqlservercentral.com/articles/powershell/65324/%5B/url%5D

http://www.simple-talk.com/sql/database-administration/why-this-sql-server-dba-is-learning-powershell/%5B/url%5D

http://itknowledgeexchange.techtarget.com/dba/powershell-sql-server-health-check-script/%5B/url%5D

Actually xp_dirtree has been around for a...

Unfortunately, as evidenced by a number of replies to this article, its not only executed by...

nplace6530 (2/2/2010)

---

Hi All

...

With:

select @Str = 'EXEC Master.dbo.xp_DirTree "' + @URL + '",1,1'

INSERT #dirpaths SELECT 'PATH: ' + @URL, 1, 1

This replaces the "EXEC master.dbo.xp_cmdshell" command with the undocumented "EXEC...

louis.young, One thing I can think of is to make sure you are in the same database that you created the queue in.

Great article Jonathan, looking forward to more. Especially...

Try this one, http://support.microsoft.com/kb/918992

Using this procedure, you can use OSQL to output all the logins to a single file. If you want individual files per login, just loop through the...

I use the following on SQL 2008 to pull messages off the event queue that are related to a 'sa' login event. Another procedure processes the records in the work...