ok, it's time to play...

NAME...THAT...VENDOR!

this is really misleading, because when you click SSMS(NOT logging in to object explorer or a query window), you launch it as yourself...probably someone who certainly can stop and start...

perfect Gail, that was exactly the push i needed.

Thank you so much!

your are confusing the two possible presentation styles of SSMS with how the actual results end up in your other .NET application...they are not the same.

you get a record...

run sp_who2 again...based on the hostname column, is it all from a single machine, maybe even your own machine, since that's the only one you KNOW is running SSMS?

wierd, on my 2008 server all my connections from SSMS say "Microsoft SQL Server Management Studio - Query" or

"Microsoft SQL Server Management Studio" ...none reference intellisense.

do you have a...

try explicitly identifying a collation for the join criteria, like this:

SELECT Customers.dbo.Lead.Last_Evaluation_Product__c

FROM Customers.dbo.Product

INNER JOIN

Customers.dbo.Lead

ON Customers.dbo.Lead.Last_Evaluation_Product__c COLLATE SQL_Latin1_General_CP1_CI_AS

= Customers.dbo.Product.Name COLLATE SQL_Latin1_General_CP1_CI_AS

WHERE (Customers.dbo.Lead.IsConverted = 0)

AND...

yep pseudocode will not help with pinpointing a specific performance issue; you 've got to show the real SQL statement, and preferably, the actual execution plan.

examples of why the SQL...

AFAIK, regular indexes cannot be determined by create_date or modified date; if the data exists, it is not exposed.

you can infer the index creeation for Primary Key and unique constraints,...

the problem is the embedded html.

the FOR XML is going to htmlencode all that, turning them into amp lt ; a and stuff.

of course, but what do you want to check?> just add a WHERe statement that validates teh create_date column to whateever...

sys.objects has got all that info for you;

something like this is pretty close, i bet:

SELECT

schema_name(schema_id) As SchemaName,

name as ObjectName,

create_date

FROM sys.objects

WHERE type_desc IN(

'AGGREGATE_FUNCTION',

'SQL_SCALAR_FUNCTION',

'SQL_INLINE_TABLE_VALUED_FUNCTION',

'SQL_TABLE_VALUED_FUNCTION',

'SQL_STORED_PROCEDURE','VIEW')

ORDER BY create_date DESC

Thanks Ian;

your pointers and a fresh look at it thismorning got me where i wanted to go.

for reference, this modified verison seems to do exactly what I was trying...

in the VALUEs statement you provided, rows one and three are identical for the columns [kp_slownik_kod] and [kod_id], which seems to matcht he...

usually, you use exists to detect a reference/relationship/join between the two:

this is more like what i'd expect to see:

SELECT

*

FROM Report

WHERE NOT EXISTS (SELECT

...