SQL Server Tag Directory

Browse Alphabetically:

Featured SQL Server Questions

  • SQL Server 2005 Express SP3 Memory Usage

    Upon Startup of my system the sqlwriter process immediately grabs 700mb of RAM and holds it. As I use the SQL Server to do different thing the memory usage grows and causes the memory on my system to decline. The SQL Server never releases the memory and it causes my system to respond slowly. I fear...

    Ndea4475 pointsBadges:
  • Differences between SQL Server 2005 Standard Edition and Enterprise Edition?

    What is the difference between running SQL Server 2005 Standard Edition and SQL Server 2005 Enterprise Edition?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to check Max Worker Threads in SQL Server 2005

    We've had a few performance incidents in SQL Server 2005 and I want to check the Max Worker Threads. Would someone explain how to return that? Thanks. Moderator Note: This is a user submitted question

    BrentSheets6,925 pointsBadges:
  • Performance issues with a large table in SQL Server 2005

    I have an application that is managing inventory for a company that has multiple locations. Items are being inserted into an inventory table roughly every 5-6 seconds from three locations. At the same time, this company is packing inventory in boxes in order to fulfill orders. I have a table setup...

    Thecoolestguy5 pointsBadges:
  • Lagging Microsoft SQL Express Server 2005

    Hi, I have Microsoft SQL Server 2005 Express Edition with SP3, SP4, on Syperemicro Server, Intel Xeon E3-1220 v2 3.10GHz,8GB RAM and OS Microsoft Server 2008. We use Windows 7 desktop clients machine with enough CPU and RAM and arcgis software who is sync with MSSEE. But works very slowly. I am...

    mICROSOFT1235 pointsBadges:
  • Incremental backup in SQL server 2005 and SQL Server 2005 express

    Question: a) steps to backup the daily incremental in sql server 2005. b) steps to backup the daily incremental in sql server 2005 express.

    david2009575 pointsBadges:
  • Why can’t I connect to SQL Server 2005 through ODBC?

    Hello people, the situation is this: we have 2 computers, one is for local store (let's call it backend) and the other is a web server (let's call it frontend). Both are PCs running Windows Server 2003 SP2 and both have the SQL Server 2005 Enterprise Edition installed. The webserver is using IIS...

    MrGeorge65 pointsBadges:
  • Upgrade SQL Server 2005 32-bit to SQL Server 2005 64 bit

    Hi, We have one development server which is running on sql 2005 32 bit contains Databases ( including Tables, SPs, views, assemblies..etc) Applications ( .net 2.0 web application, crystal reports..etc) Note: now this databases & application is under development stage. But our plan is in future we...

    Jadi5 pointsBadges:
  • .dts and .dtsx config files in SQL Server 2005

    Hi I have .dts and .dtsx config files. i want to execute these packages in the db server, can u tel me what are the steps required to attach and configure these packages for it to execute?

    Sangeeth30 pointsBadges:
  • Returning string value from a stored procedure in sql server 2005 to vc# ide code at runtime

    Hi, This is Pushan Chakraborty from Kolkata. I have complied 2 stored procedures to retrieve the names of 2 user defined tables that I have created. The stored procedures are set: ANSI_NULLS ON set QUOTED_IDENTIFIER ON go -- ============================================= -- Author: -- Create date:...

    Pushan12345 pointsBadges:
  • How to Display Japanese character in Crystal Report 8.5

    Hi, I've some data stored in Japanese language in SQL Server 2005 database using nvarchar datatype. When I execute store procedure in SQL Server, it's showing japanese character properly in SQL server. However, when I'm trying to display data in crystal report 8.5, it's showing ????? character....

    Kaushalp50 pointsBadges:
  • 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:
  • Cannot INSERT data into table with identity column

    In my program I have an EmployeeRegistry table which holds data of each employee's work attendance. Every attendance record is uniquely distinguished by an IDENTITY COLUMN called "AttendanceID" which has an IDENTITY SEED of 1 and an IDENTITY increment of 1. However when I try to insert an...

    Obhasha0795 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:
  • SQL Server Management Studio Express 2005

    I have installed Studio Express on my system but I am not able to start with it. I am not able to connect to the server. Error-40 and Error-26 is coming.What is the procedure to connect?

    Sweetu20 pointsBadges:
  • Invalid String or buffer length ERROR

    I am trying to connect to SQL server 2005 express edition using JDBCODBC bridge driver. I have succesfuly configured the data source but when I use DriverManager.getConnection("jdbc:odbc:sql")-->sql is the data source name.. I catch this Exception.. Many thanks in advance

    1023965 pointsBadges:
  • error in creating new database using sql server

    I enter as the administrator, and when creating a new database a message always appear stating that permission denied in database master! what shall i do?

    Ladylynn15 pointsBadges:
  • How do I resolve this SQL error

    [-1] SQL Error: '[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK_cat_validation'. Cannot insert duplicate key in object 'dbo.cat_validation'.' SQLState='23000' SQLNativeError=2627.

    ITdisciple55 pointsBadges:
  • Crystal Reports XI period in database name

    SQL Server 2005 database has a period in its name. For example, data.12. I call a crystal report from VS2008. I use ConnectionInfo object to pass connection info to a report. I get errors in formulas. Renaming DB resolves the issue. How can I get it to work with names like data.12?

    Fortuna35 pointsBadges:
  • Sharepoint 2010 x64 central administration problem http error:503. The service is unavible

    Hi. I installed Sharepoint 2010 x 64 version. My sql server is Sqlserver 2005 + Sp3+ hotfix. I confingured sharepoint central administration with NTLM. When i tryed open central administration it gives me Service Unavailable   HTTP Error 503> the service is Unavailable . My operating System...

    Eliyevelxan1,235 pointsBadges:

Browse Alphabetically:

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