It worked. Thanks you. You guys (sqlservercentral users) are awesome.

when I run your query on my laptop getting this error:

Msg 9436, Level 16, State 1, Line 7

XML parsing: line 5, character 15, end tag does not match start tag

How do I delete previous deadlock report?

Hi All,

what would be the Full script if I want to run against 'AdventureWorks' database?

my experience is, I tried to do 'page compression' on a table to gain some 'free space' on the databases level. But when I did it, i got more 'free...

Thanks Sean, really appreciate your help. One thing wondering is it possible to create a SP on 'Mydatabase' but get info of 'Adventurework' database? OR run against 'Mydatabase' and get...

Hi Sean,

I want to get results of 'adventureworks' database But I want those results inserted into 'size' table in 'mydatabase'.

I already have created a table 'size' with 3 columns in...

Did you try 'sp_help_revlogin'?

Source: http://support.microsoft.com/en-us/kb/918992

Thank you much Matt!!! Is there any other options?

Igor/Grant,

Almost all SP are called by Web server. I have CTFP is set 25. I don't see any CPU pressure or slowness, but But when I check 'performance_dashboard_main' it...

Thanks for your reply SQL guy 1. when I run your query I get date, first LSN, Last Lsn....etc. my question was if I have log shipping configured to...

Hi Jeff,

The table is dynamic and active OLTP.

Hi Jeff,

The table contains records which uses, xml, LOB, uniquidentifier.... datatypes.

Thanks Lowell. What I am trying to find out on my Prod Database is which tables haven't been accessed, modified or updated for long time, so I can make a...

Thanks for quick reply. How do I find which tables (data) were changed by date?