Viewing 15 posts - 376 through 390 (of 1,583 total)
This should work for you (create a variable and set the @@ERROR to it, then test for it before you attempt the xp_cmdshell)DECLARE @Err INT
BEGIN TRY
BEGIN TRANSACTION
<A whole bunch of...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 6, 2014 at 7:46 am
cafescott (3/6/2014)
The...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 6, 2014 at 7:40 am
Furthermore, check out Brent Ozar's sp_BlitzIndex (as Jack mentioned) - it does a good job of isolating potential indexes that are not used, and/or ones that are potentially duplicated: http://www.brentozar.com/blitzindex/
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 6, 2014 at 6:25 am
First off I would recommend determining exact which data the analysts needed data to. Define this list clearly beforehand and obtain approval from the wary executive (who should be...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 5, 2014 at 9:34 pm
And....Blitz! :w00t:
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 5, 2014 at 9:02 pm
Weird. Have you tried just using an int?
"Parameters of all SQL Trace stored procedures (sp_trace_xx) are strictly typed. If these parameters are not called with the correct input parameter data...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 5, 2014 at 12:05 pm
To aid what Jack has already said, use the DMV to get a better idea of whether or not the index is actually used...and remmber to keep in mind that...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 5, 2014 at 11:09 am
Lowell (3/5/2014)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 5, 2014 at 10:26 am
What's your default remote connection timeout set to on the server?
Please refer to the articles below, which may point you in the proper direction -
http://technet.microsoft.com/en-us/library/ms189040(v=sql.105).aspx
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 5, 2014 at 9:19 am
Right-clicking on the Agent should give you the option to "View Details", then switiching between tabs (of the Publisher/Distributor) you should see the last error that was recorded there).
Since all...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 5, 2014 at 9:10 am
Glad to hear that!
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 5, 2014 at 8:44 am
Check the data type for your last parameter, per the link below it needs to match the value in the trace that you are looking up (which in this case...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 5, 2014 at 7:34 am
Did you set up an ODBC connection first from your machine, and reference that DSN in your linked server setup? If so, check that you created a System DSN and...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 5, 2014 at 7:31 am
I believe this is what you are looking for, check out this article by Jeff Moden - http://www.sqlservercentral.com/articles/T-SQL/63003/
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 4, 2014 at 3:47 pm
Yes good effort, but what we really need is a script we can run to set everything up with little to no effort. Everyone here is willing to help...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 4, 2014 at 3:39 pm
Viewing 15 posts - 376 through 390 (of 1,583 total)