Assuming a key:

SELECT count(*), <column(s) that make the key>

FROM <table>

GROUP BY <column(s) that make the key>

HAVING count(*) > 1

Be great!

Mike

We have a spreadsheet housing the requisite information per each server. Here is a list of things we 'keep track of.' Not really referenced by the seasoned folks,...

If you want to put the results into a table:

CREATD TABLE testt(

tab varchar(125),

cnt int)

GO

INSERT INTO testt

EXEC sp_MSforeachtable "select '?', count(*) from ?"

GO

Be great!

Mike

Try this:

EXEC sp_MSforeachtable "select '?', count(*) from ?"

Be great!

Mike

Try this:

create proc sp__shrinklog

--------------------------------------------------------------------------------

-- Purpose: Shrink transaction log of the current database.

-- Author: Andrew Zanevsky, AZ Databases, Inc., 12/25/1999

-- ...

CREATE INDEX...ON <different filegroup>. Fill in the blanks for all of the indexes you want to move.

Be great!

Great collection of resources! Any chance of putting out an "all encompassing" list of resources for various issues? The rest of us could suggest a link or 2...

We have had to rebuild replication so many times. That would seem logical.

Thanks for the insight.

P.S. We "discovered" this while running a query for a CAST product....

Yes it is a user database.

SELECT name FROM sysobjects WHERE type = 'V' ORDER BY name

That would make sense, sort of, if replication is creating those. This database is...

Unless I am missing something, the FatBrain link lists you as a co-author. However, the US Amazon site does not list you. Is this the same book?

Perfect! Sorry for the abbreviated code. My full script has the values with comments. I used the numeric values because that is what I found in an...