You can change your query to send the output to .xls...

Post the query...

When you use the table alias use single name instead of three name...

LEFT JOIN dbo.RE7.CONSTIT_ADDRESS_PHONES AS CONSTIT_ADDRESS_PHONES1 ON dbo.RE7.CONSTIT_ADDRESS.ADDRESS_ID = CONSTIT_ADDRESS_PHONES1.CONSTITADDRESSID

If you know the spid you use to query sysprocess table...

select loginame from sysprocesses where spid = ...

You can add no of days as calculated column..

See the following ex:

drop table #test

Create table #test (publicationdate datetime default getdate(), NoOfDays as datediff(dd, publicationdate, getdate() ))

insert into...

You can add no of days as calculated column..

See the following ex:

drop table #test

Create table #test (publicationdate datetime default getdate(), NoOfDays as datediff(dd, publicationdate, getdate() ))

insert into...

SELECT table_name,  sum(COL_LENGTH(table_name, column_name)) AS ColumnLength

FROM INFORMATION_SCHEMA.columns

group by table_name

If these files are backup files then you can use RESTOER HEADERONLY command to check them...

You can either one...

sp_readerrorlog or xp_readerrorlog

Log growth is very high while Indexdefrag process running compared to reindex...

You can try changing the recovery model to bulk_logged before index defrag and can change back to Full once...

Still you can use sp_helptext...

select object_definition(object_id('sp_spaceused'))

exec sp_helptext sp_spaceused

This is one of the new security feature offered in sql 2005...

Until sql 2000, even sql passwords are not case sensitive...

SQL Server 2005 Security Features at a Glance

http://www.microsoft.com/sql/technologies/security/security-at-a-glance.mspx

Administrators...

looking at external load balancing hardware. So if server A is busy the request would be sent to server B - but this would need some sort of two-way mirror...

If both tables used in the query/join has the same column name what you are selecting, sql gives that error...

so it is always advisable to use table alias/name before...

If I am not mistaken.. to use READ_COMMITTED_SNAPSHOT you have to enable it first which is server configuration not the db configuration and it has its own pros and cons...

If...

I will go with single procedure...

create proc abc

as

select * into #temp2005  from Sep2005table

select * into #temp2006  from Sep2006table

Calculate the difference from #temp2005  and #temp2006... these table will have subset of data...