There is really no visible server difference between SP3a and SP3; the main difference for us here was that 2 of the clients DLLs are very different in how prepared...

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.mspx

Dated 2004

Tim S

Hey it works in SQL2005; another reason to use it.

CREATE TYPE dbo.CustomerCode4 FROM varchar(11) NOT NULL ;

GO

DECLARE @CUST_TABLE TABLE ( RecID INT IDENTITY ( 1, 1 ), CustCode dbo.CustomerCode4 )

SELECT...

I would add a line below

SELECT @lowBal = amount FROM unitValues u, plans p WHERE firstUnitValue = u.ID AND itemID = '4050-9910-0000' AND planID = (SELECT billingPlan FROM signupInfo...

I would try changing the following if on SQL2000; not sure if it exists on SQL 7.0

SET @clientID = @@identity

to

SET @clientID = SCOPE_IDENTITY( )

Tim S

We use the SQL Diff Tool from http://www.adeptsql.com/ compares SQL objects like tables & store procedures.

And are thinking of getting the DBGhost Pro Tools from http://www.innovartis.co.uk

Builds...

He updated his script here

http://www.database-security.info/Tools/SQLServer/spAuditPasswords.txt

Tim S

No it is not wise;

Look at your linkservers one of them has a login defined on it.

Tim S

Also, check out http://www.chriskempster.com/articles/debugdtcissues.htm

Also try turning off if you can't connect to see if security issue TurnOffRpcSecurity

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cossdk/html/2627a956-60b3-4d26-bc04-e0676ec97786.asp

May want to read http://support.microsoft.com/default.aspx?scid=kb;en-us;224071

Tim S

FROM BOL 2000

sp_resetstatus turns off the suspect flag on a database. This procedure updates the mode and status columns of the named database in sysdatabases. The SQL Server error log...

Lookup sp_changedbowner in BOL

Yes a SQL 7.0 Client will talk to an SQL 2000 DB.

May have problems if server is NOT the default instance; if not default instance you need MDAC 2.6 and...

The only reason I found to have a certain person own the database is if that person would be creating objects and you could NOT get them to remember to...

FYI:

To get one of my Windows 2003 Server OEM with SQL 2000 SP3a to work using MSDTC; I had to re-install MSDTC.

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

AND...