- Did you also rebuild all indexes after your migration process ?

- replace the ltrim with a like statement if you can.

- as Gail already pointed to : don't use...

No.

Restore performs its action to the same number of files as was the case for the original database. (the one you backed up)

It even needs the same space requirements to...

Out of the box...No.

- you could search SSC for some scripts to help you out 😉

http://www.sqlservercentral.com/scripts/Maintenance+and+Management/61340/

http://www.sqlservercentral.com/scripts/Miscellaneous/31893/

- You could build your own SQLSMO application, generating dependent objects and then using the...

JanM (9/29/2008)

---

Hi

I try to get the server version by the followin command:

osql.exe -Sserver\instance -Usa -P*** -Q"USE master SELECT @@version" -p

This works for the Instance installation. But how do we get...

Strange having your reg pointers messed up :crazy:

I haven't seen that issue ...

I'm glad you managed to fix it and got to do the thing you intended to.

HTH

Adam Bean (9/26/2008)

---

When I first went from EM to SSMS a few years ago, I absolutely HATED SSMS ... couldn't stand it. Yet after about 6 months or so, I...

I think my little article regarding sqlserver and SOx can help out.

I think you should use :

start /wait setup.exe /qB VS=PRESQL17 INSTANCENAME=PRESQL17 REMOVE=ALL ADMINPASSWORD=XXXXXXX GROUP="SQL" IP="XXXXXXXX

Be carefull with remove all !

If this is the only instance on the box, it's ok,...

Thank you for the feedback.

We still haven't found the cause of this incident.

We do have a number of servers with sql2000 on it, this is the only cluster that...

fjmorales (9/23/2008)

---

I used the query for a server on SQL Serv 2005 and until now its been greate but teh server that I whant to verify is in 2000.

Is it...

just a simple server level login trigger will also do the job for you.

(i.e. do users still log in)

- Out of the box (if you're on SQL2005 SP2)

- every login

-...

Attached you'll find what I tested as a result of your request 😉

My dev edtn is on SQL2005 SP2 + CU9 ( 9.00.3282 ) so its results may...

- Can you rebuild your indexes (clustered and non clustered) ?

- If this behavior is still the same afterward, you can force it to use the index, but then I...

- I would first make myself comfortable with SSMS.

- regarding databases:

- rebuild all indexes

- sp_updatestats

- dbcc update_usage (0) with count_rows

- switch...