• 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? Is...

    Jfw10075 pointsBadges:
  • What are the security risks of using hosted SQL

    B"H Where ever I look I see that no one recommends having your SQL Server available on the Internet (public ip). Everyone says that you should only have local machines access your sql. If you need to access your sql then you should VPN into your secure network and then have access. or you should...

    Mplotkin5 pointsBadges:
  • VPN Hollander Powerlink Server issues

    I set up a VPN connection to our Hollander Powerlink Server when I try to set up the client software I get and error message unable to validate the power link server. I have all the drivers mapped on the client machine. during set up I try to map the SQL but I am having trouble making the...

    greatjubee165 pointsBadges:
  • Name Pipe work arounds in SQL 2005 database

    I am working on a SQL 2005 data base, the supplirer is telling me that the reason I am unable to find the SQL Data Base when i run there Client install software through a VPN connection is that the Name Pipes are keeping the Data base from being accessed.   Can anyone herlp me with this issue I...

    greatjubee165 pointsBadges:
  • SQL Injection in my network

    How can I protect against SQL injections and remove the injection point?  Also, how can I remove an injection that my antivir has detected?  My computer is running extremely slow and I'd like to know what information has been compromised.

    ML35 pointsBadges:
  • sys.conversation_endpoints build up

     It Seems that there is a lot of problems with SB cleanup? I have SQL 2008 r2 running on two different servers. The target system processes the millions of records in the queues but will not clean out the sys.conversation_endpoints, or the sys.conversation_endpoints tables. This is part of the...

    Shellz5 pointsBadges:
  • Is there a way to find out when a patch was last applied to an instance?

    Is there a way to find out the date a SQL Server instance was last patched?  I need to keep track of dates each of my instances had a patch applied whether it be a security patch, hotfix or service pack.  I looked in the ServerProperty function but did not see anything that would return this...

    Mrhr246120 pointsBadges:
  • Free IT Book: Securing SQL Server by Mrdenny!

    This week's free IT book is especially exciting because it was written by Denny Cherry, who you may know better as mrdenny. He's always providing quality and thoughtful answers, and we're excited to share a whole compilation of his knowledge in Securing SQL Server: Protecting Your Database from...

    MelanieYarbrough6,345 pointsBadges:
  • I want to create backup of SQL database and set a password.

    HEllo All  i want to create backup of SQL database and want to set Password that anyone who restore this backup after that it cant be able to restore database without knowing perticular Password .... is this Possible....? if Yes please tell me How...? Thanking You Raviraj

    Raviraj1235 pointsBadges:
  • SQL Server and AntiVirus

    We have many sql server running on seperate boxes, the Network team wants to install antivirus software on all the sql servers. Is that a good idea? Why?

    Rick Martinez585 pointsBadges:
  • DBCCShrinkDatabase as Security Cleanup Measure?

    Recently a private document wasposted to a publicly accessible SharePoint site. The file was deleted and removed from the search index by running an intermediate crawl of the content database. Now the client wants to shrink the database, which is just under a 1Tb in size and sits on a SAN, claiming...

    KansasCoder40 pointsBadges:
  • Adding another level of security to SQL 2005 database

    We have a SQL 2005 Database. It is protected by Windows Authentication. Can we add another level of security - requiring a SQL username and password along with a valid user name and password on the domain?

    NewnanIT1,110 pointsBadges:
  • How to create data security in SQL server 2005 so that the code will not be opened

    how to create data security in sql server 2005 so that the code will not be opened

    Gkhlhlhjhhghgg15 pointsBadges:
  • Kerberos unconstrained delegation for MS SQL svc account

    Can an MS SQL service account run non-SQL services if "trust this user for delegation to any service (Kerberos only) has been enabled?

    Calicdaj5 pointsBadges:
  • Database Security: SQL Server 2005 security login

    Like Oracle Logins how can we create Logins in Sql Server 2005? Please help me..........

  • Please explain SQL Ingestion with a example?

    Please explain SQL Ingestion with a example?

    Mayurkhe295 pointsBadges:
  • Security Update for SQL Server 2005 Service Pack 3 (KB970892)

    hi! each time i try to update the captioned update it fails. i guess it has also caused my ooutlook to crash!!! pls help

    Teamwork085 pointsBadges:
  • SQL Database User

    Hello, I have 3 servers running sql server 2005 server1, server2, and server3 with database1 and database2 respectively. I backup database1 on server1 and backup database2 on server2 then I restore database1 and database2 on server3 as read-only on a daily basis. I only want to use one sql...

    Rick Martinez585 pointsBadges:
  • Service Broker in sql server 2005

    [strong]What is a real life application of service broker architecture in sql and how to use it?[/strong] [strong]Can anybody help me in understanding service broker with real life example?[/strong] Thanks in advance

    Srm20095 pointsBadges:
  • Capture SQL Server logged in db User name in Access 2007 Accdb

    I have a SQL Server 2005 backend with an Access 2007 Accdb front-end application.  Security has been established via SQL Server database user groups with associated table-level permissions. I would like to disable certain form functionality based on the logged in user.  Is there a way...

    Ppeterso15 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following