i find your lack of faith most disturbing ....... LOL

my thoughts exactly

you are trying to insert a varbinary value into a dynamic sql string.

😀 got a feeling he'll be using those anytime now.

Ninja's_RGR'us...

could be you cannot resolve the hostname have you tried using the IP address

one way is to create a database user that is not mapped to a sql login but has alter permissions on the tables to truncate. When the devs execute use...

is this a clustered sql set up then?

you could maybe limit the query

Charles Kincaid (2/13/2009)

---

That works great. I wonder if this works for...

as far as i recall that version should be fine. Double check the delete task

in that scenario yes

Lynn Pettis (2/12/2009)

---

if you had to restore from the previous day without using the end of day backup...

Barkingdog (2/12/2009)

---

When I use sql 2005 Management Studo to list the database servers are my company it returns a list containing servers with MSDE, Sql Server Express, Sql 2005, and...

sql2000 and sql2005 will co exist quite happily

first question is does the hardware support 64 bit platforms?

if yes then you would need to move all objects (databases, logins, etc) out of the cluster to a temporary sql...