While executing the T-SQL a mere 40...

You may want to test this:

SELECT

Owner = USER_NAME(so.UID),

...

wware (12/13/2010)

---

QOTD doesn't get any better than this! It's obvious you paid a lot of attention to detail when you were writing it. And, you required us to...

I would certainly hope that...

Here is another method - but you will have to test to determine which is most efficient. Look up the modulo operator in Books On Line to understand the...

techzone12

Thanks for the feed back.

Now for everyone who wants to help you, the next time you post a question to a forum please provide the table(s) structure,...

I did and thanks for...

Here is a GROUP BY solution

CREATE TABLE #T(EmpId INT, EmpName VARCHAR(50),Salary MONEY)

INSERT INTO #T

SELECT 123, 'andy', 10000 UNION ALL

SELECT 111, 'Maddy', 12000 UNION ALL

SELECT 121, 'Raman', 25000 UNION ALL

SELECT 124,...

Without using sp_ForEachTable you might want to try this code:

DECLARE @Table NVARCHAR(200),@Column NVARCHAR(200),@Sql NVARCHAR(2000)

DECLARE Table_Cursor CURSOR FOR

SELECT so.Name AS 'Table',sc.Name AS 'Column'

FROM...

If you would provide table definition, some sample data and required result based on the sample data, then some one will be able to assist you with a tested solution.

Click...

What you need to do is to develope an overall requirements document specifying what you management expects to use the database for.

a. What data do people...

Have you considered importing the data into a "staging table" , then using one or more T-SQL statements to locate the rows where there is data that "violates the constraint(s)"....

My thoughts: It should be an alert to check...

john.moreno

hmm I tested repeatedly on both 5K and 8K before submitting the question .. always produced the identical answers on all servers...

Are you sure you executed the first 6 lines...

You may want to look at the SQL Server Migration Assistant document (pdf) at:

http://download.microsoft.com/.../SQLServer2000MigrationAssistant_Final.pdf

A TechNet search for the SQL Server Migration Assistant

http://technet.microsoft.com/en-us/default.aspx

This article on SSC will explain its installation...