What errors are you getting when trying to log on to the server?

Have you enabled remote connections through surface area configuration?

Does some firewall is blocking the connection/port?

I think the OP wants to update products where suppliers for that product > 2. So, should the rows be filtered by COUNT(1) > 2?

...If you are using dynamic SQL, make sure to take care of SQL Injection attacks.

The function STATS_DATE gives the last updated statistics on an index...

SELECT name AS index_name,

STATS_DATE(object_id, index_id) AS statistics_update_date

FROM sys.indexes

Actually, I can't read people's mind:D...Jeff, though, after...

Well, if I understood you correctly (its better if you can post some sample data & the table structure in script format), this is what you are looking for....

SELECTCOALESCE

(

BO.DDS...

Other way is to edit the table design in SSMS (don't save it) & just save the generated script, though I never tried this myself.

I am not entirely sure on what you exactly wanted, but may be you are looking for DB_NAME(), this gives the database name in which it runs.

...Not enough information, you should be more specific about what you need, what are the

inputs & what is the expected output. See this article on how to...

In simple terms, there isn't any equivalent to CONNECT BY of Oracle, but you can achieve the same functionality using CTE (Common Table Expressions)...

Here is an AdventureWorks example from BOOKS...

Do you see *.lock files in the directory "C:\Practice Files" when you running the linked server query? If so, then delete those files & try re-running the query.

Just an oversight from myside, thanks john for correcting it.

So, have you checked the linked server by accessing it?

SELECT * FROM North...Orders

Here is the solution...

DECLARE @strFullPath VARCHAR(MAX)

SELECT @strFullPath = 'E:\SomeFile.sql'

SELECT RIGHT( @strFullPath, CHARINDEX( '\', REVERSE( @strFullPath ) ) - 1 )

Can you re-create the linked server by using the following script?

DECLARE @strLinkedServer NVARCHAR(100)

SELECT@strLinkedServer = 'North'

EXECUTE master.dbo.sp_dropserver

@server = @strLinkedServer,

@droplogins = 'droplogins'

EXECUTEmaster.dbo.sp_addlinkedserver

@server = @strLinkedServer,

@provider = 'Microsoft.Jet.OLEDB.4.0',

@srvproduct = 'OLE DB...