I would always like to use the SQL as

Declare @sql varchar(8000)

select @sql = 'Select... From .... Where 1=1'

Now Start concatenating your criteria to

Somebody posted this sometimes back. Hope this helps.

DROP PROCEDURE dbo.sp_ServerStatus

go

CREATE PROCEDURE dbo.sp_ServerStatus

/*******************************************************************************

Written By : Simon Sabin

Date :...

Try this undocumented sp.

set nocount on

create table #sp_mstablespace (Rows INT, DataSpaceUsed INT, IndexSpaceUsed INT )

Insert into #sp_mstablespace

Exec sp_mstablespace <YourTableName>

select * from #sp_mstablespace

paul

Please follow these, it always helps

1. INDENTATION

2. Define all variables at the very top

3. Document history of changes, at the very begining

paul

I would look at features, that this software supports, which is not supported by SQL Server Backup utility/feature.

paul