Thanks for your thoughts.

The data is coming from a SQL Server 2005 database (Access was used as a front end and report generator) so I know that the data in...

I did that for all of the varchar data elements (did not do it for int or datetime elements, and it made no difference.

Any other ideas about how a tablix...

I've seen this too, along with other problems in SSMS. (check your event log for errors).

This could be caused by corrupted Management Studio user data. Someone said that this could...

This could be caused by corrupted Management Studio user data. Someone said that this could fix SSMS crash problem. Just a simple step, try it.

Go to:

1. %SystemDrive%\Documents and Settings\<user>\Application...

Since you restore a full backup of your database to another server (let's call it backup-dbserver), when you do a log restore, you must be logged onto backup-dbserver.

I normally...

Since you've already done the database restore, you shouldn't need the move at all. Have you tried the log restore without a move section?

Also, can you post the errors...

We have been having similar problems. After extensive diagnostics, we've come to the conclusion that there is a subtle 'bug' when connecting from a 32-bit client to a 64-bit...

It turns out that the problem is caused by the expiration of the Kererbos token on my Windows login account. Once that happens, access to SQL server Agent is...

Steve,

Thanks for addressing this so quickly. I would have been be very upset if the transfer to RedGate could so severely twist the MARVELOUS help-tool you've built here....

Take a look at this:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=162&messageid=110942

Regards,

Peter

Steve,

I think one of your indexes is slightly sick. We already know all about the sale. Now, we need the Upsert article, please.

(We all hope this is...

If your question is 'How do I shrink the logfile?', you can do that with 2 commands:

Backup Log dbname_here with TRUNCATE_ONLY

...

Hi, Bill,

'Been there, done that!'

This error comes from the log shipping monitor job that was probably set up automatically when you set up log shipping. Basically, the primary server...

The best tool I've found is called DTSDoc, you can find details at http://www.dtsdoc.com. The price is right, too - $39.95!

Peter

Steve,

My experiences showed me two things -

1) firmware upgrades are VERY important

2) telephone support staff needed to go to class.

Our solution was a...