quote:

---

am stuck because I cannot

recreate the PK or any indexes.

---

Do you get any...

You can't capture the output into variables because the xp return a rowset but you can place the result of xp to a table.

quote:

---

I got the following error while trying to reattach it:

---

It seems to me your...

Did you ever have 'guest' user in database 'BBB' before?

Edited by - Allen_Cui on 04/24/2003 09:13:04 AM

Have you recently applied SQL Server SP3 with 'allow cross-database ownship chaining' enabled?

The share doesn't necessary to be in your production server. It can in be your standby server too or even in third server as long as the SQL Server service...

Copy that text file to the c:\ of your SQL Server machine.

Just share the log sub-folder and grant vendor with read-only permission at NT file level and let them open your log files with NotePad. Your NT administrator sure knows how...

You can call stored procedure either using pass-through query or programming modules that is almost same as visual basic programming.

You are right on SQL Server 7.0 but I did get same error message as you got in 2000. It seems Microsoft made changes in 2000.

Microsoft (R) SQLMaint Utility (Unicode),...

Did you say you can do it in SQL Server 7.0? In order to fix the database problem with 'repair' options either by dbcc checkdb or maintenance plan, the database...

Do you have to use maintenance plan to fix database minor problem? You can run dbcc checkdb with repair options and schedule a job to run it.

In that case, you may take look your RAID 5 configuration in new server. Can you post more information about new server hardware, paging file and how do you...

I don't have test box here but different sort order / code page are definitely the place you have to look into and ensure the server you built has same...

Change the value to 2 in following key.

HKEY_LOCAL_MACHINE\SOFTWARE\MSSQLSERVER\MSSQLSERVER\LOGINMODE