• Setting up SQL Server 2005 memory

    My SQL 2005 Enterprise Edition SP1 on server 2003 Enterprise SP2 has 12GB memory. I set min memory 10MB,10GB for max memory and set 'lock page on memory', but Task Manager show only 4.50GB only and performance monitor show SQL server manager - total memory on 4GB. Expert: Do I setup memory wrong?

    Maylee6330 pointsBadges:
  • SQL Server 2005 memory issue

    SQL server 2005 running on Windows XP. The memory grows steadily then SQL (system) hangs when memory gets to 1.7 GB and then the server must be re-started. What could cause this?

    Uphs25 pointsBadges:
  • Transfer data from DB2 file to SQL Server file

    I want to transfer a data from a DB2 file to a SQL Server file. I do not want to buy a software that do it. I want to do it by myself (perhaps using ODBC) Thanks all for help. Abdou

    HABDOU5 pointsBadges:
  • DB2 (AS/400) data transfer to SQL Server 2005

    How do I do a Data transfer from DB2 (AS400) TO SQL SERVER 2005?

    Hamadaeg15 pointsBadges:
  • SQL Server 2005 information

    What exactly does SQL Server 05 do and if I'm looking out for a job in this field, is there any exam which I have to take?. I'm new in this and have less knowledge about SQL. Please help. Thank you.

    Naughtyrohit15 pointsBadges:
  • SQL Server 2005: SQL statement in a variable

    Can anybody help me? "HOW TO ASSIGN A SQL-STATEMENT IN A VARIABLE". FOR EXAMPLE : TO ASSIGN A STRING IN A VARIABLE, WE DO LIKE THIS: DECLARE @A AS VARCHAR(20) SET @A='HAI' PRINT @A OUTPUT: HAI SIMILARLY HOW TO ASSIGN A SQL-STATEMENT IN A VARIABLE.

    Narendar30 pointsBadges:
  • Writing a SQL Query

    Is it possible to write a query that goes through the entire database to search out a particular phrase to delete it, instead of going table by table? This is on a SQL 2005 Database that was injected. The following appears throughout the database tables: <script...

    Bosco32225 pointsBadges:
  • Flowchart and algorithm

    How can I find a flow chart and algorithm of a program that finds the minimum of three values?

    melkamu15 pointsBadges:
  • IF ELSE in SQL Server stored procedure

    I am using this code which is giving error: if (@report_type = 'CM') Begin Select distinct Region,sum(ClientCount) as ClientTotal Into #NewTemp From ( End else if (@report_type = 'AM' ) Begin ( Select distinct Region,Area,sum(ClientCount) as ClientTotal Into #NewTemp1 From End else if (@report_type...

    Rrj15 pointsBadges:
  • SQL Studio 2005 expired but it is not evaluation copy?

    What happened? SQL Studio 2005 says evaluation period has expired even though I have a licensed copy of SQL Server 2005 installed. Please help.

    Nan57225 pointsBadges:
  • How to open SQL 2005 after installation

    How do I use SQL 2005 after installation?

    lathalakshmichitra5 pointsBadges:
  • Attaching AdventureWorks database To SQL Server 2005 SP1

    How can I get the AdventureWorks database for SQL Server 2005 SP1??

    Never5 pointsBadges:
  • Joining unmatched tables with duplicates

    Hi, I am a beginner SQL user and am trying to take table 1 (contracts) and pull in the calltype from table2 (equipment) with the control number as the common field. However, there are duplicate control numbers in table2 which are causing me an issue. I have created this query on table 2 to get the...

    jruth1325 pointsBadges:
  • Can SQL Server 2005 32-bit and SQL Server 2005 64-bit co-exist on the same cluster machine?

    Can SQL Server 2005 32 bit and SQL Server 2005 64 bit co-exist on the same cluster machine?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2005 is running slow

    SQL server 2005 is running very very slow while it has 32 GB ram 200 GB SAN and 4 Processor of Xneon 566 GHZ. The normal select query takes 30-35 seconds to returning 37 records. Please give me the suggestion how to increase the performance

    Biru25 pointsBadges:
  • I am getting following error for SQL server 2005/2008

    Hi, I have SQL server 2005 and SQL server 2008, both are installed on the same machine. Now I want to pass the server name like mymachine\\mssql2008 to one of my own stored procedure. This procedure tries to get the fully qualified table name of a particular table of some database which is on SQL...

    Brijeshkumar5 pointsBadges:
  • SQL Server 2005 on Windows 2008 64 bit SP2. Installation issue

    I have tried to install SQL Server 2005 on Windows 2008 64 bit SP2. I have installed SQL server 2005 and SQL server 2005 SP2, however only the SQL Server 2005 configuration tools appear. (Everything was selected to install) I have found these posts which have the same issue, but they are for web...

    Jabba12310 pointsBadges:
  • java

    i need to include N number names into the database from single textbox at the run time of the program using java

    SABARISHJAGANATHAN15 pointsBadges:
  • How to retrieve tables?

    My SQL Server 2005 database get corrupted because of a virus infection. No tables are showing now. My database folder contains .mdf, .ldf and file (3 files) can I retrieve my tables using one of this. Any solution please? I don't have any other backups. Please get a solution.

    DatabaseRecovery35 pointsBadges:
  • How to connect my computer to SQL server 2005

    I need your kind support in connecting  my computer to SQL server 2005? I am a bignner and I will be thankful if you explain it step by step? What should I write in the code to recognize my database? Thank you and regards.. 

    Biggner10 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