My manager handed me a portable disk drive containing mdf files of about 15 databases, and asked me to tell him about them - age, content, when last used.....

After...

Very nice script, thank you for sharing.

I made a small change in your final SELECT statement to identify the name and step number for any SQL Agent job processes...

Nice work; you've defined a mechanism for storing and managing server and database privileges in an environment-adaptive fashion. I imagine many of us can utilize this framework.

Now if only...

Very nice contribution; a keeper! Thank you for sharing.

Thanks for your help. I should have realized the error message was returning a page reference and not an object ref; your info helped me determine the table at issue.

I'll...

Thanks for doing the work and letting us benefit from your efforts. Your script is helpful.

Now...

I've looked at these examples but haven't figured out how to join the tables to meet my needs. I need to join @BATCHES to @TRANSFERS, but how? @BATCHES has the...

Ah ha, now I see what I was forgetting. Thanks very much for your help.

In BOL look at the doc for each of the SPs used in replication (sp_addpublication, etc.) and you notice that the job names are marked as for internal use only....

How about something like this as an example?

declare @hival int

select @hival = max(id) from mytable

dbcc checkident(mytable, reseed, @hival)

HTH,

Steve Armistead,

Database Administration

Panther Systems Northwest, Inc.

Vancouver, WA

Okay,

The PK of table RDM_ATC_LVL_4_LKUP (or a unique index) has to be on the ATC_LVL_4_CD column. Each rcd in this table has to be unique by ATC_LVL_4_CD for you to...

You've probably got a record in table XXX with a value in the ATC_LVL_4_CD column that's not in the RDM_ATC_LVL_4_LKUP.ATC_LVL_4_CD column.

use this query to find out if this is...

Thank you all for your ideas and solutions - my problem is no more.

I find it wonderful that this forum is available.

Steve Armistead,

Database Administration

Panther Systems Northwest, Inc.

Vancouver, WA

No, it's the snapshot agents in a transactional replication setup. The other agents appear to be operating okay. I think this is a problem with the clustered server failing over...