After enabling AWE, SQL Server will reserve almost all available memory, leaving 128 megabytes (MB) or less. In your situation, You really don't have to enable it because there is...

See whether this KB helps.

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q199/1/31.asp&NoWebContent=1

Which edition of your SQL Server? How do you configure the memory allocation for SQL Server?

Which version of SQL Server do you run?

Is your database in suspect mode?

Logins are in master database. If you detach and attach database from one server to another server, you may have to move the logins too.

Edited by - allen_cui on 08/21/2003...

You may check the registry key \\hkey_local_machine\software\microsoft\mssqlserver\tds.

Try Registry Extended Stored Procedures like xp_regread and xp_regwrite to read, write and delete registry values.

http://databasejournal.com/features/mssql/article.php/1462641

I don't think it is necessary. MDAC 2.8 release installs the same Data Access components as Microsoft Windows Server 2003. It enhances the security and adds some new features.

Test your...

Execute permissions for xp_cmdshell default to members of the sysadmin fixed server role, but can be granted to other users.

As Shoayb suggested, you can setup proxy account for those...

By default, TempDB is created in same folder as other system databases such as master. The drive that holds these databases may not large enough for TempDB.

It has all database objects including stored procedures.

You can move tempdb files by using the ALTER DATABASE statement.

1.Determine the logical file names for the tempdb database by using sp_helpfile as follows:

use tempdb

go

sp_helpfile

go

The logical name for...

You should have virus scan to your database server but to exclude scaning MDF and LDF files.

quote:

---

Can stored procedures be written querying data from 2 databases on the same server?

---