From BOL

Important If you choose to use a Windows NT account that is not a member of the local administrator's group for the MSSQLServer service, users who are not...

What hotfix on SP4 are you using?

Tim S

Edit: I am using build 2187

http://support.microsoft.com/kb/916287/

I just wonder if I have the problem.

I read here of some issues

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=65046

Tim S

Try this below if you have I problem I will need table create scripts to fix it.

SELECT Age_Group

FROM

(

SELECT

LEFT((

CASE

WHEN DxAge >= '0' AND...

It should hide the databases with DB_ID less than 5 even if they have the guest user in them unless the user is in a server role.

I have not every...

The top-down data modeling technique will teach you how to create an integrated Logical Data Model, which is fully normalized and populated with key business attributes. The bottom-up data modeling...

It is possible in SQL 2000.

Tim S

See MS Info AT

http://support.microsoft.com/default.aspx/kb/889696

See my post at

http://groups.google.com/group/microsoft.public.sqlserver.security/browse_frm/thread/24c50b41fc85a144/9e4259b3fc8ba957?lnk=st&q=stahta01&rnum=30&hl=en#9e4259b3fc8ba957

Figured it out

SELECT *

FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'paradox 5.x;database=C:\Trax\COM\private\scratch\', carriers)

Where the paradox 9 file is at this path C:\Trax\COM\private\scratch\carriers.db

NOTE: I always heard it was not safe to write using...

I have no idea if it matters, but are the servers at the same service pack?

Tim S

Have you set @smtpsrvr to a valid mail server address?

Does the mail server allow you to use it to send emails?

If not on the same LAN, is the firewall open...

What was the Sybase code?

Have you verified that the sub query returns any rows?

SELECT SBR_SUBSCRIBER_NUMBER

...

sp_cycle_errorlog -- cycles the sql error log file

There is a stored proc to read the log also, but can't find it.

Tim S

edit: found them

sp_readerrorlog @lognum -- lognum is optional

sp_enumerrorlogs --...

Have you looked at IS_MEMBER ( { 'group' | 'role' } )

Tim S

Books on-line

The help file(s) that is normally installed with SQL.

SQL 2000 BOL link below

http://www.microsoft.com/downloads/details.aspx?FamilyID=A6F79CB1-A420-445F-8A4B-BD77A7DA194B&displaylang=en

Tim S

Do you mean have your database not show up in EM (Enterprise Manager)?

If so I suggested the following to someone and he said it worked OK to hide the system...