I´m not sure you can restrict that. Not from SQL at least. Maybe ask a win2000 if it can be done.

Or remove permissions from them and you...

By adding more files you will gain in performance. If you use several files in filegroups, you will have the paralelism that you have with Raid.

You should...

That's right. To execute a dynamic sql statement you must put it into a variable and the execute it.

You can also execute the dynamic transaction with EXEC sp_executeSQL 'Dynamic...

Can you tell me what type of column is F10 in Excel? It seems the problem is in the data source (In excel), not in the DTS package.

Or you can...

I also think you can change it running from the command line the rebuildm.exe utility.

Here you can change the language, sort order and other stuff with out re installing the...

Did you check the history of the job??

What does the job do?

Check also the event viewer and sql error log.

Try turnning it On, maybe someone change it without your advice. Re run the maintenance plan and see what happens.

If you run your DBCC manually, shows the same error. Are...

Do you have any job that can be causing this problem. Did you tried with sp_who2. This one shows more info.

With sp_lock, did any spid had an exclusive lock?

What you can do is in notepad write

OSQL -E -Q"Backup dbName to backup_device" -oc:\Backup.log

or whatever you want to do, and save the file as .cmd. Then you simple executes the...

That's true. I also prefer BCP to export data. Or if you want to make it really easy, run DTSWiz to import and export with a wizard

I don't think you may have any problem but

if you are planning to use auto_shrink you should check the results, and much more in a production server. I would shrink...

I would say that you make the comparision in the backup server only. You first should start some tools to compare. Execute :

Set ShowPlan_All On or use query analizer Graphical...

Hi, I think you should place a Clustered Index on that column. The index will place all the rows in order in new pages in and index structure.

This way your...

Well, I think that what you should do is copy the files from the original server (It must be stopped) to the new server. Then attach those files without changing...

Any Error in Event Viewer or SQL