Just install it at the default location and save the space on the D:\ drive for the data and log files.

Check with your IT to see if they have the port open for Database mail on the server os level.

Whatever total space you have, allocate 20% to the OS and the rest you can allocate to SQL Server. Then within that 80% that you are allocating to the SQL...

shiva challa (10/8/2008)

---

Here is the most updated script, With added code to use SysObjects in 2000 instead of sys.objects

---

/**

Script: list all Usernames, Roles for all the databases.

Author: Shiva Challa (

An MDF file is never deleted automatically by SQL Server. Not even in a clustered environment. Your files probably got renamed or moved by some user due to network latency...

As the command suggests....your database file was shrunk.....and the empty space from your db file was truncated and release back to the Server OS.

shiva challa (10/8/2008)

---

Here is the updated script.

I have also updated the online script, Just waiting for it to be published.

/**

Script: list all Usernames, Roles for all the databases.

Author:...

CAGreensfelder (10/2/2008)

---

Adapted for SQL 2000

/**

Script: list all Usernames, Roles for all the databases.

Author: Shiva Challa (http://challa.info)

and the database Roles that the user belongs to in all the databases....

Schedule your full backup and then your tran log backups but when netapp will do a full backup of your db it will reset the check point on tran log...

When you say 'copy of your server' do you mean just the copy of the DBs or the entire backup of the server including the OS portion and all....

You can't run this script on SQL Server 2000 as the script is based on the catalog views which are newly introduced in SQL server 2005. This script can be...

Here is some more reference items from msdn for sql server 2005 encryption:

http://msdn.microsoft.com/en-us/library/ms189586.aspx

You need to run some more perfmon settings to get the metrics on memory, cpu, page file, sql server usage.

Check out this msdn site for recommended perfmon analysis:

http://msdn.microsoft.com/en-us/library/aa645516(VS.71).aspx

DBCC_opentran

Not in SQL 7. You will have to delete the publication and re-create it again.