SQL Server Security

Looking for best way to have SQL Server data security, replication as well as security maintenance

I joined a production environment recently, and I’m the key person here. We have 2 servers: one production server and a replication server. Data from the application goes to the production server every second and that is replicated to the replication server. We fetch the data from replication...

Setting up access rights in a SQL Server 2005 database

Hello, I'm using MS SQL Server 2005. I'm connecting to the server via ADO. I have a question about access rights. Let me explain this with an example. Let's say I have a database named DB. In DB there are 3 tables. TBL_1, TBL_2, TBL_3. I want to create a SQL Server user that will have all rights...

Read Only access to a SQL Database? Best way?

We're trying to prevent hacks on our site. We've been down several times and the idea came up that we could prevent the SQL Injections by making an account for just the public-facing side of the site that has Read Only set for it. This is a Microsoft SQL 2000 server BTW. Our hosting company...

disk activity is running at 100%

24 hrs ago disk i/o and activity shot up to 100* with quues grwoing. our average i/o queue is normally around zero with disk activity at <15% we have had this before - lasts a couple of days and then stops. we have never found out why? can anyone help?

Access rights in SQL Server 2005 users

Hello, I'm using Ms SQL Server 2005. I'm connecting server via ADO. I have a question about access rights. Let me tell this with an example. Let's say I have a database named as DB. In DB there are 3 tables. TBL_1, TBL_2, TBL_3. I want to create a SQL user which will have all righst on TBL_1...

Suspect DB

Hi, I am using sql server 2000 and recently found 2 of the DBs are marked as Suspect and I don't have access to them any more.Would you please help me with this? Thanks, Ellie

Potential over & under security issues with SQLNative Client ?

Hello, I've been unable to find any reports of these two problem when using the SQL Native Client driver (9.00.3042.00), so I'm hoping else has seen these. Firstly check constraint definitions accessed by the following TSQL only returns data with the SQL Server driver, ie nothing with SQL...

Best 3rd party monitoring software for sql

Best 3rd party monitoring software for sql

Is firewall preventing SQL Server from showing up in the EM?

I have a corporate Dell Image laptop running SQL server 2000. Enterprise manager (EM) shows up without my registered SQL server (local or remote). When I try to re-register I see the other registered servers, however, they are grayed out. When I use the MMC Snap-In from computer management, I can...

How can I set the database password by the SQL Server Enterprise Manager?

How can I set the database password by the SQL Server Enterprise Manager?

How to transfer encrypted data between SQL Server 2005 and SQL Server 2000

We are a retail/web/phone order store. We process credit cards for all three stores at our retail location. We have our web data stored offsite on the web server, using SQL Server 2005. We have our retail/phone order data stored onsite in SQL Server 2000. I'd like to add a function to our MS...

Encrypt a Column in sql server 2005

I'm trying to encrypt a column. Unfortunately I don't have access to the C# source code that is accessing the data. All the instructions I've found require me to use the decrypt function in my SQL command. How do I automatically encrypt and decrypt without being able to change the source code? ...

sql 2005 db security for public

I have databases that were converted (by restore) from sql 2000 to sql 2005. I found a script to move the logins (all using nt/sql auth) to the 2005 box. All the users on the sql 2000 box belonged to public on the old box. If i loook at the users inside the db's on the 2005 box (no public) they...

SQL Server Command String

What is the max length of the Command String that can be submitted to SQL Server?

Securing dynamic file uploads to a SQL 2005 Server database

I need to determine what is the best (practices) method for scanning of files/documents (.DOC, .XLS, .JPG, .TIF, .PDF) before they are dynamically uploaded into an SQL 2005 db as BLOBs..Thanks

Create credential

I need to create a credential,and a proxy for my Jr. dba to support and troubleshoot production SSIS and SQL jobs. I want to create a credential/proxy that follows best practice and can be implemented as a standard across environments. Can you give me an example of a credential that has...