thank you!

Not to be obtuse, but just to clarify - the server is still considered passive even tho it's in H/A? we aren't using it for anything but H/A.

very helpful..thanks guys!

We are using high availability.

We had a similar situation - but did something different.

We needed to buy new SAN's anyway - so we found a few that do SQL SAN level duplication (and...

1) Who said anything about nightly index rebuild? It sounded to me like you did some massive cleanup process that removed hundreds of GB from your database and you want...

I'd really prefer not to have to do a nightly rebuild on every index - don't think I have enough time to complete that nightly anyway.

Can I just do a...

I need the max

This seems to work :

SELECT * FROM [SQLNODEBSTAGE].[PEC_PROD].[DBO].[Staging_Eligibility]

WHERE (select max(staging_eligibility_id) FROM [SQLNODEBSTAGE].[PEC_PROD].[DBO].[Staging_Eligibility]) <> (SELECT MAX(staging_eligibility_id) FROM [SQLNODEBSTAGE].[STAGING_Archive].[DBO].[Staging_Eligibility_archive])

The staging tables will not be deleted only...

Thanks . I figure it out. It really was a NULL.

I am querying in an A/G group and needed to add a linked server to reference my primary to get...

Yes.

Thanks everyone most helpful.

Thanks.

I think I found one that is pretty good - has fiscal dates (Quarters/Year end, etc)

Thanks everyone..that worked!

Thanks, but I'm looking for somthing similar to this..(but I can't this working - nothing prints)

USE Master;

GO

SET NOCOUNT ON

-- 1 - Variable declaration

DECLARE @dbName sysname...

Wish we could. End users need to be able to choose parameters.

It would be ideal if the end user...