How do you turn this option off?  I created a login and didn't realize that
is option was on.  Now if I try to run this command: alter login UserID with
check_policy=off, check_expiration=off  
I get this error: Msg 15128, Level 16, State 1, Line 1

I created a <log in> in sql server 2005. When I tried to delete the log in,
it gave me a message that to complete the process I should delete the users
(belonging to this log in) in each databse, it also said that it may be
necessary to transfer the ownership of the schemas to ...

uninstalling the patch resolves, but that is not a viable solution.
sql 2005 sp2. After installing kb960089, the reporting services instances
fails to start.  any ideas?
Thanks

In one database, after I ran: sp_helprotect @username='public', it
shows:
Owner  Object   Grantee Grantor ProtectType     Action  Column
---------------------------------------------------------------

We renamed the sql server and everything seems fine (sql2005). However, I see
three logins that still have the old name in them:
OldServername\SQLServer2005MSFTEUser$OldServername$MSSQLSERVER
OldServername\SQLServer2005MSSQLUser$OldServername$MSSQLSERVER

Is there an Extended Stored procedure that can enumerate and list all the
members of a given Active Directory group?

This may be a common dilemma but I just cannot seem to resolve it.
I'm using SQL 2005 by logging into SSMS via my own [DOMAIN\User] account,
which also exists in the SQL Logins and has server roles of 'Public' and
'sysadmin'.

We have one server, w2003, fully patched.
runs 2 instances of sql server.
Instance 1: sql2k 8.00.818 which means sp3a with other patches.
Instance 2: sql2005 9.00.3077.00 which is sp2.

Explain ADO and RDO

I am going to setup one way replication from server in US and a server in
India. The two servers are of different domain.
1. What is process to connect these two servers.
2. Any port to be opened.

I get a dozen or more files a day that must be loaded into our SQL
Server 2005 db.
A generic SP loads the data like this:
set @cmd = "insert ...

I'm trying to use the Datagrid in the help file, using the walk thru.
When I downloaded the Northwind database, the instructions in the help file
say to attach the database. I'm using the local account on Windows Vista,
and I'm able to create local databases, attach databaes from ...

I'm working on a mini project to revoke access to anyone who has access to
the MSDB fixed database role db_ltddtsuser.  To accomplish this I first need
to identify all logins who have access to that role in MSDB.
My question is - What is the best way for me to generate a list of ...

I recieved an email about this procedure sp_replwritetovarbin.  one
recomendation is to remove it from your system.  
Does anyone know what this proc is for and what will break if removed?  
Also does anyone know if this is a real threat?

SQL 2000; Windows 2003;  I am getting the following error in the
errorlog:
Login failed for user 'bocada_admin'.
2009-02-03 15:27:26.77 logon     Login failed for user 'bocada_admin'.