I agree that I did not know about this function too, nice question.

2 things from reading

http://msdn2.microsoft.com/library/ms186915.aspx

1. Permissions function returns permissions for CURRENT USER, so if he, junior DBA...

Did not realise that the record could be deleted several times. In this case it is easier probably to loop using the same algorithm joining the table to itself and...

I do use 2000 Query Analyzer to connect to 2005 server. It is true that you can not use Enterprise Manager. You may want to install 2005 client components.

If...

Somthing like this (did not test, just an idea):

select t1.LocationID

from MyTable t1 join MyTable t2 on t1.ID = t2.linkID

where t2.ID = MyRequestedID  (12 in this case)

Suppose you have the tables and fields:

UserTable - UserID (your primary key)

Table1 - RefUserID1 (this is  a reference field (foreign key) to userIDin the Usertable)

Table2 - RefUserID2, Table 3 -RefUserID3

You...

David,

Did you try to create an old good Data Source?

Can you ping the server from your client?

This error that you posted is from Named Pipes (the error message says so...

I just updated my post above

They say that Express listens on the local connections by default (shared memory) . You have to enable TCP/IP or Named Pipes, especially if you specify the network library explicitly.

Use...

Hi,

I think that how you describe the server name as \\serverIP\SQLservername that it could be the named instance.

You connect to the named instance as servername\instancename without \\

also port...

Is there a reason to do an unattened install? I would babysit my servers, that is for sure.

But if you want the file you may record it by selecting Advanced ...

Excellent Article with a good overview of develoment features.

I somewhat aggree with Alan too: the examples have typos unless the author did modify his AdventureWorks database.

In the first example...

with port issues sometimes Named Pipes connection will work. Test it by creating Named Pipes alias from Client Network utility.

Looks like a firewall or port  problem to me.

See if you can connect from D to C by other ports: pinging, mapping a drive, register C in EM from D (not...

do you use an "OUTPUT" keyword for the parameter that you want to return? You may see examples in BOL article CREATE PROCEDURE. See the example D there that shows...

Did you try SA with a blank password or SA with sa password?

Are you sure that nobody actually knows the SA password for the server?

Did you run the profiler to...