Viewing 15 posts - 91 through 105 (of 126 total)
I don't want to go off-topic but..
Upgrade scripts, Data-Tier Applications plus numerous other approaches
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
July 19, 2012 at 8:25 am
Look at the heirarchy data type - If you use that can, I seem to remember you can get that info very quickly
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
July 19, 2012 at 8:23 am
Many thanks
Always helpful
Cheers
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
March 2, 2012 at 8:55 am
Thanks for the responses but maybe I didn't explain my situation very well.
I am currently running the global traceflags 1204 & 1222 which give the nodes involved and all...
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
March 2, 2012 at 8:31 am
Thanks - It was for a search form that did not worry about dirty data
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
February 28, 2012 at 3:56 am
Already mentioned SP_HELP_JOB with the parameters but also worth looking at :
SP_HELP_JOBACTIVITY
SP_HELP_JOBHISTORY
🙂
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
February 7, 2012 at 2:32 am
You could add the date parameters into the Xp_readerrorlog stmt if you wish to limit the initial result set?
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
December 19, 2011 at 3:37 am
Many thanks for your prompt response.
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
December 5, 2011 at 4:11 am
Hi there - apologies for the lateness of the response.
There are numerous software packages out there that will notify you on the basis of evt log messages or if...
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
September 13, 2010 at 8:15 am
No worries, not an issue.
I find SSIS a useful tool for various different reasons incl. graphical interface for the devt env, ease of deployment with use of the manifest file...
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
August 28, 2010 at 9:13 am
Sorry Jeff - I was anticipating using a script task from within SSIS to get the info that you were after. It should be a relatively easy script that...
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
August 27, 2010 at 6:00 pm
Many thanks for your responses - I am not in the office for a while but I will check as soon as I return.
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
August 27, 2010 at 5:54 pm
I may be being thick but the error that you are getting states that the XML is not well formed. Put a try..catch block to eliminate the badly formed XML....
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
August 26, 2010 at 8:42 am
Check the Evt system log - It stipulates the user that sends the stop and start control for the service.
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
August 26, 2010 at 8:34 am
SSIS?
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
August 26, 2010 at 8:14 am
Viewing 15 posts - 91 through 105 (of 126 total)