quote:

---

1. Can you use Query Analyzer and Enterprise Manager with it (considering we already have a license for MSSQL2K)?

---

Have you run DBCC CHECKDB to your database?

sp_helptext your_sp_name

The table will spread on all files that make up the filegroup.

Which version of SQL Server you are running?

To use AWE memory, you must run the SQL Server 2000 database engine under a Windows 2000 account that has been assigned the...

These stored procedure and function return information about objects in the current database(local) only.

quote:

---

For sp_helprotect I tried this:

SET @full_table_name =...

Make sure the account has sufficient privilege to run SQL Server and SQL Server is configured in mixed authentication mode.

From BOL.

"Using a Domain User Account

A domain user account uses Windows...

Setup server alias in your client machine using client network utility.

The job history table will tell you whether job itself completes or not only. If dbcc checkdb find any errors, it will report the errors in SQL Server errorlog.

You received this erro when backing up user database that backup is nothing to do with TEMPDB. You also need review machine application/system logs that may give you some error...

Can you post exact error message? Which database (user, system or tempdb) are you referring to? Have you performed hardware check in I/O disk storage?

Edited by - allen_cui on 11/04/2003...

You don't need /3GB and /PAE in SQL Server standard installation because it can run only with 2GB memory and doesn't support AWE.

In Enterprise Edition installation, if you have more...

Choose the customization installation during the setup.

No I am aware of it.

I don't has both Windows 2003 32Bit and SQL Server 64Bit, but in theory 64bit application can't run 32bit system just like 32bit software can't run 16bit system. You...