I know you are going ask this question so that I said you can use Maintenance plan which has the buildin functionality to delete older files.

If you are using my...

BOL is the best place to start...

I believe you can create the linked server using system dsn created by ODBC datasource.

Column limitation per table is 1024... see the following link for complete details...

http://msdn2.microsoft.com/en-us/library/ms143432.aspx

where did you see less columns? You said edit page, is it SSMS or something else?

Is your domain admin is member of local admin group? Under what account SQL server 2000 services were running? Does this domain account granted sql login in 2000.

Try to upgrade...

You can create FK without deleting using NOCHECK option and then you can write a cleanup script using not exists command.

You can make use of the script from the following...

If you want to send the email immediately Use the trigger

or

if your table datetime column then use that column check and send the new records using a procedure...

I don't think it will be a problem but you can the load test by creating the multiple jobs for different client to run at the same time.

You don't need to...

If you want to backup the database name 'xyz'

REPLACE 'pubs' with 'xyz' in my code and create the job to run every 30 minutes...

OR

You can...

Looks like your mdf file is corrupted...

Try the following if you can get the data..

1. Rename existing mdf file mdf_old

2. Create new database with the same as corrupted database with...

Post the details of your data file and log file size with used and free space info.

What is the recovery model of the db?

Check if there is any table growing...

You can use the following code...

Declare @Vch_FileName Varchar(255),   

        @Dt_DateAndTime Varchar(20),   

        @Vch_SqlString Varchar(255) ,

@Sys_Database Sysname, @BackupPath Sysname   

select @Sys_Database = 'pubs', @BackupPath = '\\PC-MOHAMMEDU\c$\'

if right(@BackupPath,1) <> '\'   

select...

Becareful when you are giving the access through QA to production servers even if it db_reader access...

If someone runs select * from table which millions of rows without NOLOCK or...

Your query is getting everything irrespective of constrainsts (PK), indexes and statistics etc...where as QA gives you only indexes and uses the following query...

select I.name, I.status from [dbname].dbo.sysindexes I

where I.id...

If you are using SIMPLE recovery model you are out of luck...

Read the BOL topic "Recovery Models" to get more info about recovery models...

Running the backup is depends on your...