For password, I'd recommend to use "PWDENCRYPT() and PWDCOMPARE() " because you only need one way encrypt since you don't need to decrypt so having 3rd party s/w is kinda...

This is great, thank you so much!!

BTW, We are already in MSCS so that is down

My one of the biggest concerns...

Yes, backup and restore works the best.. If you want to switch server quickly then Logshipping is 2nd choice.. (BTW, I love LogShipping ^.^)

Kun

I tried Local Drive but it failed every other times as well.. I set to try every 1 minitues and tested on Local drive..

I also tested DTS package to run...

Hi Angela,

I suspected that as well but the CPU load is always under 20%.. this box is dedicated to replication distribution box so there isn't much things going on..

After I...

This is not recommendable but since your database is small and all other folks suggested good to try and didn't work, this might be worth to try.

Based on your...

Allen sounds right, also check the dump file on SQL Log folder (\Program Files\Microsoft SQL Server\MSSQL\LOG) to check if that query really corrupted the database.

I'd like to ask a few questions.

When you make the replica of Production database to TEST, did you use dump and load(Backup/Restore) or Object transfer?

Have you tried this? Since you...

you can have same logical filename on one server though. However, need different physical file name. Use "WITH MOVE" for that.

For Example,

RESTORE DATABASE test3

FROM  DISK='c:\test.bak'

 WITH  MOVE 'test_Data' TO 'e:\test1.mdf',

  MOVE 'test_Log'...

does the proc uses cross database query?

My company also bought the DELL 4cpu with HyperThread and before we change all our SQL servers to dell, I evaulated one server and did the load testing and happend the...

I would do MG's method but make sure to read about those procs from BOL as Shas3 recommended. First make a proc to save the profile as a file or...

Since you have SP3a, might want to check this as well... Still, follow the Allen's suggestion. That would be the first place to look.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q814410

I have to withdraw my opinion about okay with installing .Netframe work. Sorry about confusing fapel. I didn't think about MDAC upgrade. I've seen so many trouble w/ MDAC difference, I...

When you look at the services and see the "Log On As", you can check if this is from Local System or any specific domin login id.

How do you...