i think you are abstracting stuff out, and leaving out critical details.

show us the EXACT command you ran. it really sounds like you say you did one thing, but actually...

'LinkedServerName' was the example...you never mentioned the name you gave that server, so all i could post was examples i thought would be intuitive enough that you knew you'd need...

that's the difference between a JOIN(INNER JOIN) and a LEFT OUTER JOIN

inner joins only show matches, where OUTER JOINS (LEFT and RIGHT) can show you where something doesn't match, if...

In addition to what Sean said, a lot of out-of-the-box portal software, like Dot Net Nuke and Sharepoint store the html in fields in the database, for dynamic content; codebase...

you can set up the linked server so if a specific local user tries to use the linked server, it uses a different set of remote credentials instead:

the way you...

diagnose the linked server before using it in your code;

if you run EXEC sp_tables_ex 'LinkedServerName' do you get any results? in theory, it will return all available tables fo rthe...

another pair of eyes can certainly help; can you post the execution plans from each server so we can see them too?

so many talented folks here, one person might see...

your on the right track; a case statement can help you filter your resulting value;

it might not be obvious, but a CASE statement can have more than one test ,...

Ever since I won the lottery, the only reason I hang out around here is so I can have friends....

try to avoid fields having the same name as their datatype; use a name that is more descriptof the purpose... like "entryDate" or whatever the field might mean to you.

when...

and to change compatibility in SSMS so you can test a specific statement:

ALTER DATABASE [SandBox] SET COMPATIBILITY_LEVEL = 80

GO

SELECT IDENTIFICATION, CREATE_DATE, CREATE_USER FROM CUSTOMER

GO

ALTER DATABASE [SandBox] SET COMPATIBILITY_LEVEL = 90

GO

SELECT...

sweet! glad that worked for you; I'm putting that in my notes that it really works; i wasn't absolutely sure.

yeah, getting the syntax for the dynamic sql part can be...

easiest way is from within SSMS via TSQL for me; the trace file will be open as if it were a table:

you might need to do select * from sys.traces...

in SQL 2000(the forum you posted in), i think it's a little tougher;

the easiest way to be to set up a trace on the server and check that after letting...

take a look at the posts in this discussion; it has a community contribution to script all indexes as CREATE INDEX statementing:

http://www.sqlservercentral.com/Forums/FindPost1079779.aspx

as far as the GUI goes, i think you...