Also, here was a post just today on defragmentation. Just a nice read.

http://www.sqlservercentral.com/Forums/Topic561679-146-1.aspx

Easiest way I can think of is a Job. Expand the menu for SQL Server Agent on the left side. Jobs are one of the folders below that....

Well depending upon the level of fragmentation, you can either Reorganize or Rebuild an Index. Check out books online under 'Detecting Defragmentation' and 'Rebuild Index'.

Hope that helps.

Will it help me find a partner who like cursors as much as I do? I don't think I could date anyone else! 😀

Did you try to Export Wizard? Right click on the database, select Task, then export data. Walk through the steps. I believe it gives you an option...

Sorry, meant that you don't have to have the same hardware/software. 😀

Fraggle

I am about 95% certain that you have to have the same hardware/software running on the servers.

However, it would be a little silly not to. The whole...

What are you doing with the file when you have passed it into the stored proc?

Or just spend $40-50 bucks and get SQL Server Developer Edition. The developer edition gives you all of the power of the Enterprise Edition, which is what you large...

Renuka is correct, although I didn't know it when I wrote the last message.

To setup a Job in SQL Server, you need to expand the Management folder in SQL...

I am not sure how you are doing this update process now, but if it were me, I would setup an SSIS package to do the data migration, and then...

You may also want to check that when you created the queue that the max_queue_reader is set to something greater than 0. I cannot remember what it defaults to,...

Are there any error messages? Can you give us any other details about the failure? Is is possible that you ran out of space?

When you say that you are not getting the correct data after the insert, what do you mean? Do you mean that you are able to decrypt the data,...

Log shipping is a high availablity method. Essentially, you continually run log backup at specified intervals on you primary server and then recover those logs automatically on the secondary...