If the application is properly written, so that it "identifies" itself to the SQL Server when it connects, then you can see all the connections from the application using the...

I think there's a column called HostName that you can filter on.

John

Well, you haven't given us any table DDL to go on, but after a cursory glance I would say that you should use an OUTER JOIN instead of an INNER...

Or this:

SELECT REPLACE(@String, '.', '')

John

This should work as well, and looks a bit neater:

SET @SQL = 'EXEC ' + @dbname + '.dbo.sp_MSForeachtable ''ALTER TABLE ? WHATEVER'' '

PRINT @SQL

John

GO is a batch separator... I don't think you should use it in dynamic SQL. ...

What will happen to the rows that aren't ordered? Please show us how your result set should look.

John

I'm not an ASP expert so it's difficult for me to tell what SQL this is actually sending to the SQL Server. And you didn't post the error message....

Please post the code you're running and the error message you get. By the way, if this is, or is going to be, production code, then it's not good...

You need two JOINS in your query - one to join Company to AddressLink, and one to join AddressLink to Address. In your select list, you only need to...

Anthony

You'd need to create a trigger on your Episodes table that would roll back any INSERT operation that didn't comply.

John

SELECT MyColumn FROM MyTable

WHERE RIGHT(MyColumn, 1) = ' '

John

Karthik

Way 1 isn't syntactically correct, so you'd have to go with Way 2. But I think Jason's way is better still.

Also can you tell me why we haven't use...

Art

That's why I said to search this site - there are some ingenious ways of generating the numbers/dates if you look for them!

John

I've just seen another question answered something like this:

select TOP 100 * from table1 where

...