Viewing 15 posts - 61 through 75 (of 2,483 total)
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...
June 23, 2010 at 4:04 am
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...
February 23, 2010 at 5:33 pm
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...
February 10, 2010 at 2:49 pm
A selection of examples
http://qa.sqlservercentral.com/articles/powershell/65324/[/url]
http://www.simple-talk.com/sql/database-administration/why-this-sql-server-dba-is-learning-powershell/[/url]
http://itknowledgeexchange.techtarget.com/dba/powershell-sql-server-health-check-script/[/url]
February 3, 2010 at 5:12 pm
nplace6530 (2/3/2010)
The xp_dirtree function was only added in SQL2005 so itβs not likely to disappear and will probably be around for quite a while.
Actually xp_dirtree has been around for a...
February 3, 2010 at 3:17 pm
As Health check scripts are used only by DBAs undocumented stuffare not a huge pblm.
Unfortunately, as evidenced by a number of replies to this article, its not only executed by...
February 3, 2010 at 2:05 am
nplace6530 (2/2/2010)
...
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...
February 2, 2010 at 11:03 pm
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...
December 23, 2009 at 8:05 pm
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...
November 11, 2009 at 3:16 pm
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...
November 11, 2009 at 3:06 pm
Top stuff π
Now for SQL Server 2000, I would do ... :ermm::crying:
October 13, 2009 at 12:12 am
philcart (10/1/2009)
October 7, 2009 at 9:06 pm
Both valid points. But bear in mind that reducing SQL Server memory even further will push more work onto the disks where your real problem is.
October 1, 2009 at 7:16 pm
Viewing 15 posts - 61 through 75 (of 2,483 total)