there are certain conditions that need to be considered when performing this operation.. outlined here http://msdn2.microsoft.com/en-gb/library/ms190981.aspx

Thanks!

Rich

Add to that probably a faster bus and RAM and you should see better performance.. Plus it saves $ on licensing..

Thanks,

Rich

This could be your answer then.. http://www.sqldev.net/misc/waittypes.htm

Thanks,

Rich

This might help.. http://support.microsoft.com/kb/822101

Thanks,

Rich

You can create a Maint. Plan in BIDS and then deploy as any other SSIS package to all your boxes. You can then create a job to schedule to...

You can use a Maint. Clean up task. It will delete backup files older than N days etc etc.

Thanks

Rich

If you have a Query window open and select insert file as text under the Edit drop down it will drop the text(from a .sql) file into the existing...

I agree about the "query lite".. as for your simple backup.. if you don't want to run through the wizard (which is really really simple and flexible),or create a...

And you examined every Windows group the user was a member of to see if any of those groups had that access? Is the NT id in the local admin...

you may want to check the web.config and check the connection strings to see what ID is being passed and grant the appropriate DB access..

Thanks

Rich

You can create a dataflow task in an SSIS package with an Excel file source and do any manipulation you need to and pump it into your SQL DB as...

the linked server

I believe this can be fixed by going into control panel =>add/remove programs => Windows components=>Application server and adding the "enable network DTC'

Thanks,

Rich

You can create a job that fires an SSIS package in the file system also...

1: Yes you can call DTS with Sql2005

2: Yes, you can use Excel file sources and destinations

3: Not sure if there is an automated way to migrate. Could try scripting...