Under what circumstances would I want to check the server property "Use AWE
to allocate memory"?
Our server:
Windows 2003 Enterprise edition

Does anyone know, I will be add two new columns with small int data type to
existing table that has 121 million records. How long will finish? We use SQL
Server 2005 EE with SP2 (OS Windows 2003 with SP1).
Thanks!

I am moving from an Oracle Db server to a SQL server running on a new w2k3
member server. Prior to purchase I would like to select the appropriate RAID
level for the server which gives me the best performance and recovery options.
I heard something about RAID 10?

Can some tell me where I can find the list of latest updates for SQL Server
2005? I'd like to find a way of being informed when the latest update is
released (I'm assuming Microsoft Update doesn't list the cumulative update
packages released every so often?)?

Does anyone know if it will be possible to upgrade from SQL Server 2000 to
2008 when it becomes available?  
As a follow up, would we be able to detach the 2000 databases and attach
them to the 2008 server?  

I noticed that the built in admin account is given sysadmin role, but it is
also given dbo on every database.   Isn’t this redundant?  I thought sysadmin
role automatically gives a user dbo rights on any db it uses.
When I add the new group of dbas to replace the built-in admin ...

I would appreciate some advice on generating a PK and/or synchronizing data
between two (maybe three) locations.
Simplified scenario.
Using SQL Server 2005 (could got to 2008 if needed).

I have a SQL 2000 database that is almost 3 gig's.  Small by some
people's standards.  I would like to convert the Database to a 2005
format.  Is there a conversion wizard, or a process that will do
this?  Please advise with as much instruction as possible.

When .aspx try to connect SQL server then show the following error, Any idea?
I already try to change Authentication mode to "SQL Server and Windows" but
still get the following error.
===================================================

I'm moving an asp.net website application from server2003 to Vista.  It runs
fine now on server2003 and accesses Sql Server via a dbo user using NT
AUTHORITY \ NETWORK SERVICE.  However, Vista, like XP, must use ASPNET as
the user.  The problem is that on the Vista machine I am ...

I would like to have SELECT/UPDATE/DELETE permission for a web developer
UserA on database DBWeb.
For convience's sake, I also want to grant permissions to the UserA so that
UserA can CREATE and DROP Table on DBWeb,

I need to change the security access policy in my environment. We are
consolidating several older servers for licensing considerations and
we want to change our security to a group based security where
possible. I've created the groups that are required and gave it a go

I notice a bunch of log_nnn.trc files on my C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\LOG folder.  The file size keeps increasing.  However,
I cannot find any instance of SQL Server Profiler is running.   And nobody
ran profiler at all.  I notice the same on other SQL ...

Maybe somebody can point me to a right direction on how to do this.
Here is a simplified version of what I am trying to achieve:
I have 2 tables:
Table A (

Is it possible so send email notification if SQL Server service (or any other
service for that matter) fails to start?