• Local clients loose connection to local SQL Server when system network drops connection to HQ.

    When line to primary Domain controller is dropped, some of the current logged on clients are dropped by SQL when they try to access the database.  For some clients, the application still works just fine. The clients are all set up and authenticated in the local Domain Controller. It is my thought...

    TomHelm5 pointsBadges:
  • Encrypting passwords on SQL server 2000

    I m using SQL server 2000 and I want to use a password field for Employee Master. My question is how to encrypt this password field in my insert query. I have heard about the “EncryptByPassPhrase” function and symmetric key, but it is provided from SQL Server 2005. I have tried using pwdencrypt...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Adding users to my SQL Server 2008

    How do I increase the number of users CAl to my SQL server 2008 Licensed by server?

    Georgy25 pointsBadges:
  • How to Export a MS SQL Image column to a file.

    I have pictures stored in a Ms Sql table in an image data type column. I want to be able to write the image(which is a JPG to a file. Is there a function in MS SQL 2005 or is another tool necessary?

    KatanaBeach115 pointsBadges:
  • create a procedure

    i want to create a procedure it should be able to audit any change done in the database ie. drop/delete of schema tables. the procedure should be able write audited data into a remote server machine inaccessible by the system manager/dba.

    Shwetamishra5 pointsBadges:
  • SQL Table Layout

    Hi I am creating a database. In my legacy system I had what we called a tables system where coded data could be expanded into different values   eg 0 = No 1 = Yes I tried to create this in SQL by having a properties table and then relating the other tables to the property table. However this wont...

    Philsal25 pointsBadges:
  • Resources for learning about SQL Servers

    can some one teach me this

    Mulky5 pointsBadges:
  • Moving Distribution database from an instance to antother does increase performance ?

    The Publisher database is in use by nearly 300 users with a trafic of about 340trans/sec. After adding replicas with a [strong]push[/strong] subscription (transaction replication with queue mngmt) to 1 subscriber (15 users) the CPU need on the server moved from 25% to about 55% and I can see some...

    AGiachetti5 pointsBadges:
  • SQL Server memory usage

    I have a situation where a total of 13 GB RAM is being used by SQL server. Is there any way I can break down the 13 GB usage by application?  Is there any data or technique which could be used?

    Cgardel30 pointsBadges:
  • What is the easiest and best Front End development for SQL server.

    What is the easiest and best Front End development for SQL server. I have Visual Studio 2008 Professional IDE. VB.net or VB.

    KRMerker5315 pointsBadges:
  • Problems with SQL Server 2000

    In my office we work on SQL Server 2000, and we have software in .NET Question 1: Sometimes the message display reads “You cannot access because of user limit". What does this mean? Question 2: Some of my computers work slow in SQL for an hour or two at a time. What can I do to fix this?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Running SQL Server 2000 and 2005 simultaneously

    When simultaneously running SQL Server 2000 and 2005, what performance effects can I expect this having on the box? Should the memory be increased? And what can I do now to fine-tune it before the install of 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • row_number in sql 2000

    how to find out the row_number in sql 2000 like using row_number() function in sql 2005

    Rl10 pointsBadges:
  • Adding files to TempDB

    Do I need to restart SQL Server 2005, if I have added additional files to the TempDB?

    SQL Server Ask the Experts2,585 pointsBadges:
  • ASP.NET

    i have four textboxes abd a database whicjh is already created. what i want to do is if i enter the value in the four textboxes and press button it should automatically gets updated or saved in the database.

    5555544425 pointsBadges:
  • ASP.NET

    i want to insert the data into the existing database

    5555544425 pointsBadges:
  • The most-watched IT questions this week: March 9, 2010

    1. A member asks how they can apply GPOs to non-domain computers to make sure they don’t get on the corporate domain, and MrDenny, Technochic, Denwood, and SiThu help with a solution. 2. A member asks about business intelligence in a cloud environment. 3. A SQL Server reader asks how to monitor...

    Michael Morisy8,323 pointsBadges:
  • Multiple rows locked in sqlserver when updating one row

    In Microsoft SQLServer, I found out that when you perform an SQL update, in a lot of cases multiple rows are locked, even when row-locking is configured for that table and page-locking is prohibited, and even when you force row-locking in the SQL statement using WITH (ROWLOCK).

    Nevenfi5 pointsBadges:
  • When submitting a procedure via CL program, i do not get any abnormal end message.

    When submitting a procedure via CL program, i do not get any abnormal end message even though the procedure has not not completed normally, is there anyway by which we can find the cause of the failure of the completion of the procedure normally.

    JohnsonMumbai1,160 pointsBadges:
  • How should I make the SQL in iBatis having Parameter of ListMap?

    How should I make the SQL in iBatis having Parameter of List<Map>? When I search primery key at a table having two primery key, I have plural parameters as a parameter. This parameter is List<Map>. It is an example of Parameter as follows EX) 1. parameter List<Map> paramList = new...

    Jhyukchoi5 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