• Implementing Encrypted SQL Server Database Columns

    This is the problem I'm facing: The database (SQL Server 2005) holds more than 5 million customer records. These records contain sensitive credit-card information that must be encrypted. Implementing an application-side encryption solution involves VB6 and .Net technologies. How to achieve a...

    Kansai5 pointsBadges:
  • SQL Server 2005 Performance optimiztion

    I have the following setup, would like to know what's best for log files, data files, indexes, tempdb files. Also, since the server is used solely for SQL 2005 Reporting Services, how many tempdb data files and tempdb log files should I create, also how many userdb data files and userdb log files....

    ITKE342,450 pointsBadges:
  • SQL Server 2005 Error Registering database

    I try to copy SQL Server 2005 Database to VISUAL Jobshop (ERP INFOR) get message when VJS DB Wizard of Jobshop tries to create catalogue tables "Error registering database - operation is not allowed when object is closed" Thanks for help where I have to look to solve that problem.

    ITKE342,450 pointsBadges:
  • hardware requirement for sql 2005.

    Hi all, We are planning into SQL 2005 server (windows server 2003)with multipledatabases of sizes of around 10gb.What should be the CPU speeds ,type of CPU and RAM requirements for ir

    Infrastucture25 pointsBadges:
  • Why is my logical disk usage enormous?

    I have a cluster server (2003 OS) in my environment with SQL Server 2005. It has four internal disks with RAID 10 configurations. My logical disk usage is pretty high and I am not sure how to find out what exactly is “hammering” our server or what database is making this disk activity enormous....

    SQL Server Ask the Experts2,585 pointsBadges:
  • Setting up dbmail in SQL Server 2005 on Server 2003

    I am having trouble setting up dbmail in SQL Server 2005 running on Server 2003. I am trying to send mail through an Exchange 2007 Server. Do I need to use the SQL Service account with Windows authentication? Also on the Exchange side, how should the "receive connector" be set?

    SQL Server Ask the Experts2,585 pointsBadges:
  • TFS VSTS2010

    Hello Members,                        I am very new to this blog.I want to need some information regarding VSTS2010 TFS(Team Foundation Server).I have couple of questions in my mind. I really want to share with you. At present time we want to implemnet automation testing...

    TE0015 pointsBadges:
  • How to export/ import userschema in SQL server 2005?

    To export userschema in oracle, we can use expdp and impdp commands. Do we have any commands to export/ import userschema in SQL server 2005? Also, How to export all the tables to filesystem? Using SQL management server studio there is an option to export 1 table at a time to a file.      

    Saimadhu455 pointsBadges:
  • SQL 2005 will not recognize other local disks

    SQL Server Management Studio only recognizes one drive on the server, how do I get it to recognize the other Local disks?  The one disk it does see is also on the AX-100, but it will not list any of the others, even the interanl disk, as options for devices to create databases on or for backup...

    Rick2766225 pointsBadges:
  • Database restore

    I'm struggling with when is the right time to do my last transactional log backup before my full database backup. My question is this: if I do a full db backup once a day at 10pm; and a tran log backup every 4 hours (12pm, 4am, 8am, 12am, 4pm, 8pm). If i have to restore the db to a point in time,...

    Thedbaed5 pointsBadges:
  • Auditing Windows 2003 and MS SQL 2005

    Are there any audit scripts I can use to audit Windows 2003 and MS SQL 2005?

    Gideont5 pointsBadges:
  • Is having the auto create statistics on in a database a good thing?

    Hello I have a 250GB database and the auto create statistics is on is that a good thing?

    Rick Martinez585 pointsBadges:
  • How to create a maintenance plan in SQL Server Management Studio Express

    I’m running SQL Server 2005 Workgroup edition with SP2. I’m trying to create a new Maintenance Plan in Microsoft SQL Server Management Studio Express (MSSMSE) by right clicking on the Maintenance Plans object icon. The only option is Refresh - there’s no manual method or wizard. I'm logging...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Different database & server collation

    Hi, We have a database that is sitting on a SQL Server 2005 with different collation setting, the application connect to the database is running with out any issue. Have anyone had this same issue, if so how long has your application run with different database and server collation without running...

    Db23290 pointsBadges:
  • SQL Server 2005 distribution agent failed

    Getting this error message

    ITKE342,450 pointsBadges:
  • Restore a View Sql Server 2005

    I over-wrote a VIEW by mistake. How do I recover the original version of the view? Is there a way to ROLLBACK a "CREATE VIEW..." command?

    VelameLaCosa110 pointsBadges:
  • Resource usage of SQL Server 2005 Generate Script

    Hi, I am wondering how resource hungry the Generate Script for SQL Server 2005 is. We are planing to script out one of our production database on a production server that has over 1000 object to script, and wether this will have more affect on SQL performance during the scripting? Thanks.

    Db23290 pointsBadges:
  • Trying to setup a Merge publication between two database Need Help!

    HI I am trying to setup a Merge publication between two database and I am having troubles.  I have to server one is HKDD01 and LDDD01 and the HKDD01 is set as the distribution and the LDDD01 is set as the subscriptions. I am trying to create a Merge publication with pull subscription and I am...

    Fubarms5 pointsBadges:
  • Change SQL Server licensing

    Hi, I was wondering if it is possible for a 50 seat (i.e. maximum of 50 connection) SQL Server 2000 or 2005 license to be change to a 10 seat? If it is possible is there any limitation on the number of seat that can be change? Thanks

    Db23290 pointsBadges:
  • Oracle LIKE statement on SQL Server 2005

    I'm trying to execute the LIKE statement but it's not displaying  any values SELECT R_NAME FROM LAWSON.DEPTCODE WHERE (R_NAME LIKE :r_name)

    Huhemp5 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