• How do i recover the DB from suspect mode in sqlserver 2000?

    I have a database that went to suspect mode in sqlserver 2000.How do i recover the DB from suspect without restore the DB? 

    Sqkservrdb20005 pointsBadges:
  • SQL find duplicates SQL Server 2008

    Up against a SQL question that is difficult to code.  Any help is greatly appreciated.

    Jtigges5 pointsBadges:
  • 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:
  • 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:
  • 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:
  • 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:
  • 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:
  • iseries stored procedure : read character string containing single apostrophe …. ex: Let’s

    I am working on a stored procedure that requires a literal string to be input into a VARCHAR(1024) variable. My stored procedure has no problem reading the word........... Let''s However, if I try to read the word............Let's, I get a code violation. Do I need to read the string as a datatype...

    Dsthornton5 pointsBadges:
  • Forum data transfer – SQL

    Hi, my question is: we're developing a new forum so want to learn how can we transfer the data in one or two tables in old forum’s SQL database to the SQL database of this new forum? that means we hope some posts in old forum to be moved to the new ones. Please give the steps to do it. Thank you...

    Bmblog20 pointsBadges:
  • Can I get a holistic view of applications, like SharePoint, that leverage the capabilities of a number of underlying technologies like SQL Server, IIS

    Can I get a holistic view of applications, like SharePoint, that leverage the capabilities of a number of underlying technologies like SQL Server, IIS, and Virtual Server / Hyper-V? We need to know that SharePoint is performing badly, but we need to know which underlying technology or hardware...

    ITKE357,100 pointsBadges:
  • MS DNS query logging to sql server?

    Does anybody know if it is possible using 2003 server r2 dns to log querys to a sql server database instead of a file?

    Ryan99795 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