I've been unsuccessful linking servers.  Could you give me any guidance ?

Thanks

To Anyone, 

Hope this is useful to someone else.

Later on.. a project to standardize our phone number presentation came up.  One app or even one report, one way another app or...

Since you are using integrated security, consider using a udl file.  Avoid hard coded connection strings whenever possible.

http://support.microsoft.com/kb/244659/EN-US/

http://support.microsoft.com/default.aspx?scid=kb;en-us;274536

Dim db As New adoDb.Connection 
db.Open gUDL

Function gUDL() As String
    Call...

Pubs already exists in your standby servers.  Delete it and Log Shipping will recreate from a full backup.

Yes I used the DTS Import/Export Wizard in SQL2K.  I had it run immediately without saving the package.

Didn't see any new files under Tools.

Nothing in server log files either.

Create an Access project (ADP) based on an existing database.  You should get there just fine.

You mentioned "external" which to me sound like you are using an MDB, which will...

We are using Active Directory. If you have a specific KB article, I'll get my administrators to take a look.

On the Linked Server Properties (Security Tab) I have selected...

How do I confirm that Active Directory and Delegation are setup correctly ?

Yes

I'm using EM at my workstation to connect to all SQL Servers via Windows Authentication.

Thanks for sharing the article. After reading it, I do like the new SP3 security implementation.

quote:

---

The debugger behavior has changed in SP3,...

Thanks for the reference to Article 328151. I had not applied SP3 to workstation that only has client tools.

I did that, rebooted, and everything is well.

Thanks...

Interesting reading is available on the MSDN Knowledgebase. Search SQL2000 for Trigger. Read some of the 25ish articles returned.

I only use triggers to indicate by whom and when...

Does anyone even use the debugger ?

Our SAN is used for everything. Lotus Notes, SQL2K, SQL7, File Server, and some servers actually boot from the SAN.

quote:

---

Are you guys...