nerds:~ #

15May/083

T-SQL: Find Duplicates Without Using JOIN

I'd forgotten about this lil trick.

select eUserName from eAttribute GROUP BY eUserName  HAVING COUNT( eUserName) > 1
Posted by: Chrissy   Filed under: SQL Server 3 Comments
7May/084

SQL Server: Change the Owner of All Tables to “dbo”

Reference for me. Reference for you.

sp_MSforeachtable @command1="EXEC sp_changeobjectowner '?','dbo'"
Posted by: Chrissy   Filed under: SQL Server 4 Comments
   

About

    We are IT consultants who grew up living and loving life in Cajun Country.

Authors

Categories

What's Your Job Title?

    View Results

    Loading ... Loading ...

information

wants to be free