don't remove the whole thing, just remove the spaces.

the string of characters is special and they are removed from posts hence why I need to put spaces in so that...

I was always told to not trust the sys view as it can differ from what was in the table, that was back in SQL 2000 days so unsure if...

A quick Google search for "using triggers to track changes" yields many results

http://www.philosophicalgeek.com/2008/05/13/tracking-database-changes-using-triggers/

First off run this

select 'insert into #temp select count(*),'''+name+''' from '+object_schema_name(object_id)+'.'+name+';' from sys.objects where type = 'u'

Then copy the output from the above and paste it into the comment...

Transactions or records as they are two completely different things?

You can reference the named instance in the linked server configuration

On the General page, in the Linked server box, type the name of the instance of SQL Server that you...

Do you have a firewall in place between domain A and domain B for the Server VLAN? If so you will need to ensure that the correct ports are...

SQL will use memory from outside of the buffer pool, things like CLR for example use additional memory, so even though it is capped, it can go over by usually...

Do the procs have the EXECUTE AS clause to let them run under higher privileged accounts?

System processes are no longer limited to SPID < 50 they can go over 50 depending on the task they perform.

Potentially down to page splits where the updates have now pushed the xml off into the LOB pages from in_row, depending on how big the XML data is in the...

It would depend on the load on the SSRS server as the XML will need to check that all depended objects exist first before allowing you to actually look at...

If its 2008 R2 have you tried caching the shared datasets so that it doesnt have to prepare and execute then each time the report is accessed?

http://msdn.microsoft.com/en-us/library/ff487452%28v=sql.105%29.aspx

DECLARE @sql NVARCHAR(MAX)

SELECT @sql = REPLACE(

CAST(

(

SELECT 'USE ' + QUOTENAME(name) +';' + CHAR(13) + CHAR(10) +

'SELECT ' + CHAR(13) + CHAR(10) +

'DatabaseName = DB_NAME(), ' + CHAR(13) + CHAR(10) +

'a.FILEID,...

Do you have transaction log backups? Do you know when the corruption happened?