the most complex part of the system is getting the cluster and its resouces in place, the rest is plain sailing

ALZDBA (2/18/2009)

---

We use this sequence:

1) restore the db to SQL2005

2) DBCC for DATA_PURITY

3) switch to dblevel 90 (if possible)

4) rebuild all indexes (individually)

5) dbcc updateusage with count_rows

6) sp_updatestats

7) synchronize users

8)...

run it on...

select serverproperty('edition')

Jeff Moden (2/15/2009)

---

Heh... that's one man's opinion. Anything that won't even allow for more than a 30 character object name certainly isn't the most flexible of the two. ...

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