I suggested this because you can find info in the trace that the report does not...

Object changes are captured by the default trace, so you should be able to find the information there.

http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/

This script will truncate tables that are not referenced and delete the data from tables with foreign key references and then reseed the identity columns.

Truncate All Tables

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=65341

You should forget about using NOLOCK.

With SQL Server 2005, set the database to read_committed_snapshot, and your queries will not take locks or be blocked in most situations.

You should read about...

That is not true. You can restore over a database when it is offline.

Setting the database to single user do not prevent someone from making a connection. It just kills the current connections, and prevent users from making more than one new...

repent_kog_is_near (10/20/2009)

---

Jeff

Just thought about it.. we may have to throw in or remove some indexes into the reporting DB.. that essentially rules out the DB Snapshot/Mirror and Shared Database, doesn't...

emily-1119612 (10/19/2009)

...

The problem is the size of the folder and the available bandwidth, i.e., the data is too big and the pipe too small.

Any suggestions? I imagine some of...

The value returned by the DATENAME function is dependant on the language setting of the connection; the DATEDIFF method is independent of language.

homebrew01 (10/20/2009)

---

You could get a trial version of Redgate. Redgate also has a utility to convert their backups into "normal" backups, which you could do with your trial copy...

Why did you start a new topic for the same problem?

http://www.sqlservercentral.com/Forums/Topic804719-149-1.aspx

You seem to have ignored the most important point from the prior thread, which was to limit the number of...

Don't encrypt the password. Store is as a hash.

I'm not sure what you mean by simplify, but here are two functions that you can use with each other to do the search you want. At the very...

Dave Ballantyne (10/19/2009)

---

a sarg is a searchable argument. By making the Longitude and latitude searchable as below, this will quickly eliminate all those zipcodes outside of the squared...

bigmikeg (10/16/2009)

---

...

The destination column in my system is a datetime. For the select part of my clause I'm using:

case ACTION

when isdate(ACTION)...