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...

cafescott (3/6/2014)

---

I understand how repeated querying can slow down a production server. In this case, the database is small enough that I don't think it will be a problem.

The...

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/

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...

And....Blitz! :w00t:

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...

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...

Lowell (3/5/2014)

---

i thought log shipping was just building an always-in-recovery unaccessible copy of the database that is there in case of disaster recovery, and is not editable or...

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://social.msdn.microsoft.com/Forums/sharepoint/en-US/5d79dd2b-9237-4f65-9f68-dadb347e329a/unable-to-complete-login-process-due-to-delay-in-opening-server-connection-in-sql-server-2008

http://technet.microsoft.com/en-us/library/ms189040(v=sql.105).aspx

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...

Glad to hear that!

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...

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...

I believe this is what you are looking for, check out this article by Jeff Moden - http://www.sqlservercentral.com/articles/T-SQL/63003/

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...