|
|
| SA Password Change Logging |
| I have an issue at a company I am doing some contract work for. One of the
members of the admin team keeps changing the SA password but we do not know
for sure who.
I was thinking of creating a trig... on 19-Nov-09 |
| |
|
| stop services using bat file |
| HI,
I have 2 bat files one for to stop the service and the other to start the
service.
start service will be done using sp_procoption
basically i need to stop the service on the existing node when... on 18-Nov-09 |
| |
|
| SQL Server Authentication, NOT Windows NT |
| Hi all,
Running Windows 7 / SQL Server 2008 / Office 2007 (12) -- I set up ODBC with
SQL Authentication, specifiying a user name and password that connects just
fine when setting up ODBC and testing... on 18-Nov-09 |
| |
|
| How to manage SQL server Authentication in Access2007 |
| I have an Access 2007 application using an MSSQL 2005 Database and Views. The
SQL 2005 is using SQL Server authentication with a password. The ODBC
connector is using the same password. On each activ... on 17-Nov-09 |
| |
|
| ODBC Connection and Encryption |
| Hello --
I am currently running SQL 2005 Standard and have a have a rich client
application that communicates with SQL using ODBC connections.
For PCI compliance, I need to begin encrypting the ses... on 17-Nov-09 |
| |
|
| SQL Permissions |
| I have an ETL process that detaches a database from one instance and
attaches it to another (While detaching the old DB). When the
database is attached, it looses its permissions for the users who o... on 16-Nov-09 |
| |
|
| SQL Server 2005 Connection Only By ODBC |
| I have a SQL Server 2005 database server that has a SQL user account that I
would like to restrict it from connecting with SSMS only connecting with ODBC.
Is there something I can do with the user a... on 13-Nov-09 |
| |
|
|
|