Implementing row level security in SQL 2000
Is there a way to implement row level security in SQL Server 2000?
View Answer
| Jun 18 2008 7:27 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server 2000, Security, Implementation
Don’t run the SQL Server Account as Local Administrator or member of the Administrator Group?
Based on the advice "Don't run the SQL Server Account as Local Administrator or member of the Administrator Group"Will this setup prevented you from using critical features? How did you get around this? The link below makes reference as to how a critical feature "Automatic Server Restart Feature"...
View Answer
| Jun 9 2008 1:09 AM GMT
| asked by
Aswad
SQL Server security, SQL Server administration, SQL Server
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...
View Answer
| Jun 6 2008 7:21 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server security, SQL Server replication, Database security
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 on...
View Answer
| May 21 2008 2:09 PM GMT
| asked by
SQL Server Ask the Experts
Access Rights, SQL Server 2005, Permissions and settings
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...
View Answer
| May 17 2008 0:12 AM GMT
| asked by
Kwoodall
SQL Server 2000, SQL Server security, SQL injection
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?
View Answer
| May 15 2008 2:52 AM GMT
| asked by
Salmonthefish
SQL Server administration, SQL Server performance, SQL Server security
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 and TBL_2....
View Answer
| May 11 2008 7:49 PM GMT
| asked by
DetayMan
SQL Server 2005, SQL Server security, ADO
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
View Answer
| May 2 2008 3:24 PM GMT
| asked by
Ellie
SQL Server security, SQL Server 2000, Suspect database
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 Native...
Answer Question
| Apr 10 2008 6:43 AM GMT
| asked by
WarwickW
SQL Server, SQL Server security, T/SQL
Best 3rd party monitoring software for sql
Best 3rd party monitoring software for sql
View Answer
| Mar 26 2008 6:52 PM GMT
| asked by
Fran
Monitoring, SQL Server, SQL Server security
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...
View Answer
| Mar 21 2008 8:45 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server, SQL Server security, MMC
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?
View Answer
| Mar 18 2008 11:51 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server security, 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 Access...
View Answer
| Mar 16 2008 10:22 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server security, SQL Server upgrades, SQL Server 2005
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? ...
View Answer
| Mar 7 2008 4:39 PM GMT
| asked by
Jfw1007
SQL Server 2005, SQL Server, SQL
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...
View Answer
| Mar 5 2008 10:07 PM GMT
| asked by
Tcstl
SQL Server 2005, SQL Server 2000, SQL Server security
SQL Server Command String
What is the max length of the Command String that can be submitted to SQL Server?
View Answer
| Dec 21 2007 3:40 PM GMT
| asked by
Hank1039
SQL Server security
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
Answer Question
| Nov 7 2007 9:16 PM GMT
| asked by
RJpoorvin
SQL Server security
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 sufficient...
View Answer
| Oct 25 2007 7:50 PM GMT
| asked by
Maura d'ae
SQL Server security, SQL Server
