Forgot to add... the Performance... service is part of Windows 2000. It's not installed with SQL 2K. You'll see it on non-SQL boxes as it has no connection to SQL.

K....

It should not be running normally. The only time it will run is if you are actively running Performance Monitor/System Monitor. It's like the AD Helper Service for SQL 2K....

Renaming is a fairly simply process. I've gone through it before myself. If you're following the steps in BOL for SQL Server 2000, there is a bug in the docs....

GUIDs can be considered non-binary. An example of a GUID:

B579070C-412E-4ECB-9FFF-EE99B5D3FD9A

This can come across as char or varchar. For instance:

SELECT CAST(NEWID() AS char(36))

Other than that, if you want to keep key...

Consider what occurs during a logout process:

- SQL Server takes care of all pending transactions (or at least checks to see if there are any).

- SQL Server goes the...

The only version of the SQL Server engine with a reachable limit is MSDE. It is limited to 2GB. MSDE is a stripped down version with self-imposed restrictions, and that's...

It's completely dependent on anticipated or actual load (new system vs. existing). The best thing to do is if you have an existing system, baseline it, see how the current...

quote:

---

the component was not successfully registered.

---

This question isn't meant to be insulting, it's one of...

ALTER TABLE <Table Name>

DROP CONSTRAINT <Constraint Name>

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

You'll need to run DBCC CHECKDB again, but with a repair option. According to the error message, the only repair opotion that will work is:

DBCC CHECKDB('LFGLead',...

Typically when I've seen an error with the client tools I've just applied the latest service pack (SP2) and that gets everything working again. I'm a little concerned in your...

When you say QA gives the message initially but most of the time you are able to execute the query, are you having to reconnect in order to make this...

If it's a SQL2K system you also have the option of:

SELECT SERVERPROPERTY('MachineName')

Which means you could do the following:

DECLARE @MyServer nvarchar(1024)

SET @MyServer =...

Sounds like a double-hop issue. You're using NT authentication to connect to the original server and then connecting to the linked server via NT authentication as well, right?

If that's the...

This may not be the exact way SQL Server does it, but it's similar enough to understand what's going on: SQL Server is going through the INSERT to the point...