I cannot find the settings in SQL 2005 that allow me to change password
security policies (such as how many days before a user has to chagne his/her
pwd). But I did find this:
http://searchsqlserver.techtarget.com/news/article/0,289142,sid87_gci1102101,00.html

Wish to learn SQL..pls help :)
hi all
i am interested in learning SQL but i cant afford to buy any software since
i am broke :( is

Was there ever a period in SQL Server history, when you could not control
security by putting NT logins into a domain group, and giving that group
privileges in SQL Server?
I keep hearing that around the office, that we have 900 user logins

Does anyone know where I can get a detailed list of what OS, Registry, NTFS
and SQL related permissions I would need to assign to a domain account to use
it for running the SQL Server and SQL Server Agent Services? The only article
I have found is http://support.microsoft ...

I am newbie and for getting version of server, fired SELECT @@version in my
Sql 2005 express but i am getting Server-2000 and i expected it as 2005.
Please clarify.

I have a query abou the BUILTIN\Administrators Account, I have recently had
a problem with a System Administrator not knowing what they were up to and
adding a new maintenance task to my sql server installation 2005 on Windows
NT machine to make backups that were a. being done, b ...

Hi,
We have a primary server and another server that is the mirror of the
primary server and a snapshot of the mirror on that same server. SS is droped
and recreated everyday. Mirror also copies all the logins and security to use

My client has a W2003 Server with Sql 2000 SP4 running. There is a security
group defined on the W2003 Server that has all the logins that can access
the application database.
I installed SQL Express 2005 on a client computer which is a member of the

I am talking about .Net Framework 2.0 and .Net Framework 1.1
When accessing SQL Database through ADO.Net C#, in the connection string
when we specify Windows Integrated Authentication. i.e. "INTEGRATED SECURITY
= SSPI" , what exactly happens... Does the .Net Framework , access SQL ...

I have SQL server 2005 express verions install and get KB954606
security update failed since Sep/2008.
What should I do for this?
Does it mean that my computer has virus or contorled by someone to

I know that in SQL 2000 these ports needed to be disabled for none trusted
connections. Do you need to do the dame for 2005 and 2008?
Thanks
Peter

I am trying to install Sql Server 2005 SP3 on SQL Server 2005 developer
edition SP2 running on windows 2003 SP2.
I get an error i am pasting below:
Unhandeled exception at 0x01090e9a in hotfix.exe: 0xC0000005: Access

In my company we are more than 10000 users. I want windows authentication
but I do not want to create 10000 login accounts. My server and databases
should allows all valid windows users (we use active directory).
I only allow the public role (of every db) to execute certain stored ...

could someone please let me know, which are the minimum admin rights
(security role(s)) needed to provide a sql user just the possibility to work
with activity monitor?

We are running a mix of SQL 2000 SP4 and SQL 2005 SP2 servers and only
utilize replication on one box.  For this advisory we plan to update the one
2000 box per the Advisory's workaround directions, and update the SQL 2005
boxes to SP3.  Our question is, do we really need to also ...