If you have SQL2000, what type of recovery do you have? If it is Full, then think that the log also saves the rebuilding process of the index.

Try changing the...

If you already created them, then you can move the tables to another filegroup. The fastest way is through EM in designing the table.

I imagine you can do something with the audit logon Enabled and login failed attempts. Then fire an alert to this event wich also can run a job.

The only thing you can customize is if users can see system tables or not.

Q1. No license is requiered.

Q2. You will have problems. SQL2000 support multiples instances, but not MSDE. So uninstall SQL2000, install MSDE and reinstall w2000 or change the name of the...

Or run profiler and save the results for later analisys

When you run the DBCC reIndex, are you also executing the log backup?

Restart the Resote Process from the full backup first, and then restore the logs backups in order.

Can you post what does the job does?

I think that the best choise would be to spread the tables in different filegroups with many files inside the filegroups.

You could group all the normal tables in one filegroup...

You can install sql 2000 in the server with sql 7 and then migrate everything to sql 2000 while you still have the db in sql 7.

To whom is the mail profile assigned? Log with that user, configure the profile with outlook, then set the mail profile in sql server (For SQL Server Agent and SQL...

Or try this:

@strsql = 'SELECT distinct field FROM table

WHERE field LIKE '+''''+'Ob_L%0'+''''

exec (@strsql)

the full db backup won't clean your transaction log. Only the log backup. Did you try truncating the log with truncate_only option.

The backup will only truncate the finished transactions that...

I don´t know if you can do it directly. Why don´t you create other similar triggers with the functions that you want to disable, and then enable or disable the...