I recently ran across this issue in one of my data conversions for a client. Same error but different symptoms. I was able to narrow the issue down...

Other useful info. I found a way to create the linked server without creating a System DSN. I have created a stored procedure that allows you to pass...

This is the script for creating a linked server after you have followed the instructions for configuring ODBC and OPENROWSET etc. Replace @datasrc=N'YourODBCDataSource' with the name of your odbc...

Looked at the execution plan further. The "bad" query that was doing more logical reads...but it was doing index seeks and loop joins. The "good" query that was...

Any suggestions on how to ignore results where the searched for text only occurs as part of a comment?

Not too long ago, I was working for a subprime mortgage company. I watched the size of our company go from 2500 down to 50. They kept me...

There are a lot of articles out there on this topic. Search on "perfmon" and you should find what you are looking for.

Most likely your sql server agent is running under a (Local System) account as opposed to a domain account.  You get the same problem if you have a Windows Service...

Thanks for the candid response. One thought I have is to do a comparison on the system tables, sysindexes I presume to see where the extra used space is...

Try turning on sql profiler, opening a new alert dialogue, and see what commands are sent to the db to pull up that screen. Go through them to see...

This type of manipulation would be better suited for a trigger then a default value. Just use the basic if logic in a trigger to define the values.

Write a script to pull the table names out of sysobjects where xtype = 'U'. Something to the effect of :

Select 'Truncate Table ' + name

From sysobjects

Where xtype =...

The Production primary File Group:

FileIDFGrpTotalExtentsUsed Extents

11109408 91567

The Restored primary file group on dif server:

FileIDFGrpTotalExtentsUsed Extents

11109408 46945

...

Read "Executing a DTS Package" in Books Online. Should cover everything you need to know.

More information may be helpful...

Is the data the same during the day as it at night? If so, doing it at night makes no sense to do because transactional...