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

No

This code should help get what you want. It will should the disk\share locations from backup history.

select

a.database_name,

a.Type,

c.physical_device_name

from

msdb.dbo.backupset a

join

msdb.dbo.backupmediafamily as c

on a.media_set_id = c.media_set_id

You are getting the conversion error because DD-MM-YYYY is not the current dateformat on your connection.

Your conversion of the dtTimestamp column to a string and then back to a datetime...