Hello,

Thanks for the update. It is always good to hear that an issue has been resolved.

Regards,

John Marsh

Hello again,

I found the below query posted by Bruce Loehle-Conger. Having tried it on one of our servers it seems to do what you want, but unfortunately it relates to...

Hello Again,

Sorry, I missed the second part of your question.

In SSMS you can view Locks via the Object Explorer. Right click the Activity Monitor under the Management Node and then...

Hello,

Sp_who2 is similar to the system SP sp_who, but it doesn't appear in BOL.

If you execute sp_who2 in a query window it gives you a report of current activity on...

Hello,

Does another process hold a lock on the table?

Do any Blocks appear in the results of sp_who2?

Otherwise it sounds like a corruption issue. Can you restore from a backup in...

Hello,

Yes, "GilaMonster" is right. It is the zero filled values that cause the problem.

There is the question of what you want to do in the case of zeros? Do zeros...

Hello,

In SSRS 2005 the recipient e-mail information is stored in the table ReportServer.dbo.Subscriptions, within the column ExtensionSettings. It is stored as XML in an nText data-type.

I think it's the same...

Hello,

I would guess it is an issue with the format that the data is stored in, in the old column.

Is it always the same format e.g. mm/dd/yyyy? Can you...

Hello,

Try the troubleshooting guide in BOL. Under the topic "Troubleshooting Database Mail: Mail queued, not delivered" it specifically mentions mails with a status of "unsent".

Regards,

John Marsh

Hello,

BOL is short for (SQL Server) Books Online.

Regards,

John Marsh

Hello,

This is a fairly good guide: http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1322429,00.html#

Regards,

John Marsh

Hello,

To script an entire DB we often use Red Gate's SQL Compare.

We create an empty target DB and run a full compare between that and the DB that we...

Hello,

According to BOL the input to sp_executesql "Is a Unicode string that contains a Transact-SQL statement or batch. stmt must be either a Unicode constant or a variable that can...

Hello,

Did you read this KB article already: http://support.microsoft.com/kb/842425

Regards,

John Marsh

Hello,

Did the User Logins exist on the DR Server before you restored the ReportServer DB (from the Production Server)? If you look at the ReportServer DB's Users (on the DR...