running sql server 2000 sp4, viewing the sysxlogins table data, and am wondering
about the three items listed with a <NULL> in the name column, all xstatus
= 192, each has a unique srvid value of 0, 2 or 3.
Looking in the MS tables reference book did not help they don't cover ...

I want to use SQL 2005 as back end for payroll software.
If I want the administrator can not see the employee salary, how to use the
built in encryption feature ?
Thanks.

I created a SQL login name which I'm specifically intending to use as the
login id that can allow a user to change their own password.  I currently
have this login id permission checked off as 'Security Administrators' in
the Server Roles tab but I noticed by checking this off it ...

Is it possible to change the UDP port for SQL Server? I know the deault port
for UDP is 1434 and I heard several Worm stories so I am wondering  if this
is possible to change the UDP port in SQL 2000 environment or not?
Thanks in advance

I am wondering what I should look for, in the events logs (I have the
security audit enabled to log to event logs) for successful and not
successful connections using windows authentication ?
does anybody know ?

Why would SQL Authenication be slower than Trusted Connection?
Could the person who coded it done somthing to prefer trusted and when
it fails to use sql authenication and thus slow it down.
The same front-end using sql authenication is 1/20th the speed of when

We have SQL Server 2000 installed on Windows Server 2003 SP 1. The server is
a member of a domain.
We have developers on workstations not part of the domain who need to use a
Trusted Connection to access a database on the server. I've read some other

We have an installation of SQL Server 2005 that allows windows
authentication only.  None of our windows users have been explicitly
granted sysadmin rights, but my understanding was that if you are a
member of the windows administrator group you will automatically have

Using SS2000 SP4. I'm trying to lock down the database as much as possible. I
created a new sql server login and gave the user no permissions other than
public role.
Why am I able to create a stored procedure with the new user. I thought

I backup an SQL Server 2000 database (MY_DATABASE) and restore it in
SQLServer 2005.
Then, when I try to access its properties I get:
Property IsPrimaryFile is not available for DataFile '[MY_DATABASE]'. This

We have Symantec Enterprise Anti-Virus 10.0 but it is not currently
installed on our new SQL box.  I would like to know what files and folders to
exclude from scanning before I install.  I have search Symantec knowledgebase
but no answers.  Does MS have a page on this like they ...

is there any limit to how long of a string SqlDataReader.GetString() can
return?

We have been using SSL between SQL Server 2000 (SP4) and misc ODBC clients
(mix of Access 2002 and some custom apps) for the past year. All has been
working well until it is time to renew our ssl certificate via XRamp:
We get our new SSL certificate installed, keeping the old one ...

I have configure permission for userA and he can access only one database.
When user estabilish the connection via management studio, though he cannot
access other databases, he can see them. Is it possible to hide other
databases for userA?

I'm trying to grant a user full access to a database.
Although I've given this user the role of db_owner, he still doesnt have the
same access as ,for example, the "dbo" user.
When I look at the table permissions, the "dbo" user has everything selected