There are a number of very good reasons to snoop, most of which are presented on these pages http://members.iinet.net.au/~bofh/index.html 😉 I think most DBA's, SO's, PFY's should snoop (at least...

Nice script, but....

I need to READ e-mails from an exchange server. In sql2000 that worked ok, but can't get it to work in 2005. Haven't explored 2008 yet on that...

Abhijit, your solution gives me only unused indexes in the current database. I'm looking for a solution to find all unused indexes in a number of databases, which have all...

I'm sorry, a bit in the dark. What does the outcome tell me?

Sorry, don't quite know how :hehe:

Here's something that sort of does what I want:

DECLARE @Database TABLE(Naam VarChar(20))

DECLARE@IndexNaamTABLE(

DatabaseNameVarChar(Max)

,TableNameVarChar(Max)

,IndexNameVarChar(Max)

,IndexIdInt

)

DECLARE@TableCountInt

DECLARE@SqlCmdnVarChar(Max)

INSERT @DataBase(Naam)

SELECT name FROM sys.databases D

WHERE D.name like 'McBam%'

SELECT * FROM @DataBase

SELECT @TableCount =...

Select * from ABC

INNER JOIN PersonVers

ON ABC.PersonID = PersonVers.PersonID

WHERE PersonVers.PersonID =

Try this,...

Tnx, I did all that. After a reset or 4, I CAN get to the SQL Mail properties. However, if I try a Test it hangs. I started the server...

Edited the post as requested. I'll try your suggestion tomorrow. Thanks for the tip.

btw Any new possibilities in SQL2008 that might help?

Cees Cappelle

Thank you, I figured that as much 😉

Cees Cappelle

How about normalizing results?

Write out a record per column/value pair from the SP?

Ok, here goes. The code below has 4 Update statements for the same table. Is it possible to setup some statements doing effectively the same, but reduce the round trips...

Here's a stement to get you started for a dynamic sql query. It'll create a string of all fields in a table, minus the last 3:

DECLARE @Columns VarChar(2000)

DECLARE @NoColumns Int

SELECT...