• deployment

    While running the setup on client machine, An error Number 5 occurred telling - "An error has occurred while establishing a connection to the server. When connecting to SQL server 2005., this failure may be caused by the fact that under default settings SQL server does not allow remote connections....

    Pchandrachoudhary5 pointsBadges:
  • Improving the performance of a SSRS report in SQL Server 2005

    How can I improve the performance of a SQL Server Reporting Services (SSRS) report in SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Transfering table data from one database to another

    I am using SQL Server 2005 i m inserting some data from one database to another. both Servers are resided on different machine.

    Pankaja5 pointsBadges:
  • Migrate FROM SQL2005 Ent. TO SQL2005 Standard

    We recently installed and have been running SQL 2005 Ent. because that is what we planned to use. During the 180 day window our needs have changed and we purchased Standard edition rather than Enterprise. Now we need to migrate from Enterprise to Standard. My question is what is the best way to do...

    Jtncat5 pointsBadges:
  • Log shipping after upgrading to SQL Server 2005

    I've upgraded our warm backup to SQL Server 2005 recently, but our log shipping is down. How can SQL Server 2005 be used with SQL Server 2000 log shipping?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Using the snapshot feature in SQL Server 2005 to replicate an operational database

    We are trying to keep a replicated copy of a customer’s operational database at our hosting facility. Our copy of their operational system will be used to run ETL against each night to refresh a data reporting database. Our hope is that, each night, we will receive a snapshot file and apply that...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Error messaging while using BCP in SQL Server 2005

    I am getting this error while using the Bulk Copy Program (version 9.0) in SQL Server 2005: "An error occured while processing the command line". I am using the following command: bcp MyDatabase..temptable in "C:Documents and Settings\RishiOut.txt" -c -r n -SMyServer -UHamp -Ppass123...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Backing up SQL Server 2005

    Where can I find information on backing up SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SSIS package

    I am supposed to Run an sproc /script for more than one database. I thought of scheduling this sproc as a job for all database instances. But, DBA's suggested me to go with SSIS Package. Can any one quide me in doing this.

    MSDEVELOPER5 pointsBadges:
  • sql server stored proc question

    Hi the code is like this. Its taking too long to excute. if exists(select jbadsd from saldayf sa where substring(convert(char(7),sa.jbadsd),4,4) = substring(convert(char(7),@jbadsd),4,4) and substring(convert(char(7),sa.jbadsd),2,2) = '07') --print'exists' update [national].dbo.tempsaldayfna set...

    Gullu15 pointsBadges:
  • How can I connect my local machine to the SQL Server 2005 Enterprise Edition?

    How can I connect my local machine to the SQL Server 2005 Enterprise Edition?? I can't even run the local service instance

    Jimena8a5 pointsBadges:
  • Differences between values in a SQL Server 2005 database

    What is the difference between the Checksum and TornPageDetection values of the PageVerify option in a SQL Server 2005 database's properties?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Strange Stored Procedure Behavior (Dev vs Prod)

    I have a stored procedure that runs on my Production database in 0.394 seconds. However, when I try to run the SP on a DEV box it takes well over 15 minutes to run *every* time. I have checked indexes and everything seems to be identical (I did a backup/restore to the Dev box in the first place)....

    Noonway25 pointsBadges:
  • SQL problem

    Hi, Iam having two sql servers 2000 and 2005 are installed on the same server. When i run any application it is directily hitting the 2005 serve but i want the application to to hit sql 2000 server only and when i want to hit it to sql 2005 it should hit it means vice vers can some one help me in...

    Vemuseshu5 pointsBadges:
  • SQL Server 2005 vs SQL Server 2008

    When comparing SQL server 2005 to 2008, does 2008 hold more data, or is it just an upgrade on what you are able to do with the data?

    Ryzawack15 pointsBadges:
  • Upgrade SQL Server 2005 32-bit version to 64-bit Version

    Is it possible to upgrade SQL Server 2005 32-bit version to 64-bit Version?

    Reillyjj10 pointsBadges:
  • Maintenance Plans SQL Server 2005

    I upgraded to SQL2005, and cannot get any Maintenance Plan to save, via Wizard, or regular creation.

    Ssutton910 pointsBadges:
  • Bypassing an error messaging involving SQL Server 2005 Alerts

    I have a question regarding how to monitor a mirrored pair using SQL Server 2005 Alerts. Specifically, the question is on how to send an email to an operator via database mail to notify the operator of an error. The error Event ID is 32042, which occurs when the age of the unsent log exceeds the...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2005

    I need to know if and if so how I can change the name of a flat file input and keep the column information?

    TheCiscoShow5 pointsBadges:
  • Error message while querying a linked server SQL database

    We have two remote servers, both with SQL Server 2000 databases. An ODBC data source was setup on the first server to point to the SQL Server database on the second server. Also, a linked server was setup on the first server between the SQL Server databases on both server. It was based on the...

    SQL Server Ask the Experts2,585 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