I got a Problem with a SP procedure execution which runs perfectly
fine in SQL 2000 within 1 sec  and same query when i run on SQL 2005
it takes 3 min 45 sec +- 2 seconds
I got  SQL 2000 std and SQL 2005  std RTM  running on same machine  on

Our users get their rights within SQL server 2005 as follows: user is member
of domain group, domain group is member of SQL server logins, domain group in
SQL server is member of database role. The database role has the view
definition rights on the database.

How to chekc which SP I've installed on my SQL Server 2005..?
Tried the following query:
SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'),
SERVERPROPERTY ('edition')

I have ISS using ASP pages to access SQL server on the same machine.
Is there a way that I can limit access to only from that machine outside
from limiting the port number from the router?  It is on a win2machine
Ie limit it to only allow access from 127.0.0.1

I know SQL Server has a good security system for the enterprise manager.
But are SQL server 2005 databases password protected?
In other words, suppose I make a database, named DATA1, with all its tables
and data on SQL Server 2005 I.

We are experiencing some strange behaviour on SQL Server 2000. Certain
members of a domain group are unable to login. The error log says something
like
2007-04-27 08:45:14.33 logon     Login succeeded for user 'Accounts\joe'.

I need to grant a consultant access to one database on an sql server.
I do not want to give him remote access to the server.
I have installed the client tools (Enterprise manager) on his laptop.
I put him in Users and made him db_admin.

How do I acomplish the following in MSSQL Server 2000?
GRANT ALTER TRACE TO <user>;
GRANT VIEW ANY DEFINITION TO <user>;
Thanks

I have a user who is just responsible for monitoring SQL backups. However I
seem to have to grant sys admin rights in order for the user to be able to
see the backups in Enterprise manager. What is the lowest level that I can
grant to the user in this situation ?

I need to let my user no ddl changes in dbo schema, only creaete(new)/update
permision in MySchema schema.
Can I?

I want to let my developers to create/alter stored procedure only under a
specific schema. which role let the login create a procedure , or Which role
let the login make ddl changes only in on schema (not in the dbo schema)

Does anyone know what are these accounts that created by SQL 2005
installation?
Server1\SQLServer2005MSFTEUser$Server1$MSSQLSERVER
Server1\SQLServer2005MSSQLUser$Server1$MSSQLSERVER

I have a VB.net 2005 application where I want to determine what rights a
user has on an SQL Server database...
For instance, I have a database where some users only have 'readonly" access
to the database. When the application loads, I would like to check certain

What are the necessary steps to lockdown the SQL2005 EE for tightest
security?  Thank you.

Hi friends,
   I was hoping that somebody out there would be able to help me out
with this one. I am trying to assign a database level db_owner role
permission to a SQL server level login that I have created. I can