We used to get the Network name is no longer available all the time but our backups had completed successfully. This is due to a timeout condition that is exceeded...

You can use SQL Server Database Publisher Wizard to do this. Very simple and easy to use via gui interface. You can also call it via command line to make...

Had to think about that one for a sec. Nice question.

Good question.

One of our subs does something similar to what opc asking. The application creates and launches a job as the actual execution of the procedure takes way to long to...

One of the ways I have removed duplicate rows in the past is by selecting distinct which just gives you one row per duplicated rows and insert that into a...

What is the FillFactor for the index?

Also what type of data is in the index?

Dang it. I missed the (s) in commands that will fail. I just pick one. Good question though.

Great question, I just had to read up on this yesterday as part of an investigation. What timing. Thanks for the question.

exec sp_help_jobactivity @job_name = 'Your Job Name'

Can you post definitions for 'table' and 'another table'. My guess is that they have a SQL_VARIANT column and you are push it into a NVARCHAR variable without explictly converting...

We are actually doing this for a company sub. We are doing a bunch of different servers one is SQL 2000 and one has a 2TB database in SQL 2008.

Our...

Grant Fritchey (4/12/2012)

---

Personally, I don't recommend using it. Instead, capture the query metrics using a server-side trace, then load those metrics into a database back in your development environment where...

+1

So for the sytax error I would print the command or select statment in the try..catch and run it manually against one of the servers to see if you can...