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 this. [...]

Answer Question   |  November 14, 2008  3:28 PM
SQL, SQL 2005, SQL Server, SQL Server 2005, SQL Server 2005 Enterprise Edition, SQL Server migration

Microsoft Sequel Server 2005 VSS backup
What’s seems to have happened is that the SQLVDI.dll files in the 2 directories: C:Program Files (x86)Microsoft SQL Server80COM C:Program FilesMicrosoft SQL Server80COM are out of sync. This seems to have happened as a result of a service pack for MSSQL which was applied in Dev. The Microsoft Sequel VSS writer is unable to initialize [...]

Answer Question   |  March 22, 2011  11:45 AM
Hyper-V, Red Gate SQL Backup, SQL Server 2005, SQL Server 2005 backup, SQL Server backup, SQL writer, SQLVDI.DLL, Volume Shadow Copy Service, VSS, Windows Hyper-V, Windows Server 2008

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?

Answer Question   |  November 11, 2008  7:06 PM
Log Shipping, SQL Server 2000, SQL Server 2000 Log Shipping, SQL Server 2000 to SQL Server 2005 migration, SQL Server 2000 to SQL Server 2005 upgrade, SQL Server 2005, SQL Server upgrades

Writing a query to store an image file in a SQL Server 2005 table
How would I write a query to store an image file in a SQL Server 2005 table?

Answer Question   |  November 11, 2008  7:02 PM
SQL Server 2005, SQL Server Query, SQL Server tables

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 to our [...]

Answer Question   |  November 10, 2008  7:31 PM
Snapshot replication software, SQL Server 2005, SQL Server database, SQL Server replication

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 SettingsRishiOut.txt” -c -r n -SMyServer -UHamp -Ppass123 >>Error.txt Why might this be?

Answer Question   |  November 10, 2008  7:24 PM
Bulk Copy Program, SQL Server 2005, SQL Server errors

Data retrieval from TextBox and insert in to database
Hi i am learning c#2008 and asp.net3.5. I want to get data from my textbox control and insert it in database so i cant find any source code or presentation so please tell me how to do it or give me site address where i can find this Thanks

Answer Question   |  April 15, 2010  10:33 AM
ASP.NET, ASP.NET 3.5, C#, C# 2008, Database connectivity, Database programming, SQL connectivity, SQL Server 2005, SQL Server 2005 connectivity, TextBox

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

Answer Question   |  November 7, 2008  8:56 PM
SQL Server 2005, SQL Server backup

Connecting to SQL Server 2005 after installing PowerBuilder
I have installed PowerBuilder 11.1 and I am trying to access SQL Server 2005 from my system. I use SQL Native Client for connecting to SQL Server 2005, but I am receiving the error, “Could not connect to Data Source”. However, I am able to connect to that server using ODBC and SQL Server Management [...]

Answer Question   |  August 10, 2010  3:41 PM
PowerBuilder, SQL Native Client, SQL Server 2005, SQL Server errors

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 castsdly = sa.sum_castsdly from [national].dbo.tempsaldayfna sna inner join (select cusnsd,dseqsd,slmnsd,pnumsd,slm4sd,slm5sd,jbadsd, sum( castsd) as ‘sum_CASTSDlY’ from saldayf group by cusnsd,dseqsd,slmnsd,pnumsd,slm4sd,slm5sd,jbadsd) as sa on sa.cusnsd = sna.cusnsd [...]

Answer Question   |  November 6, 2008  5:05 PM
SQL Server 2005, SQL Server stored procedures

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.

Answer Question   |  November 6, 2008  12:57 PM
Business Intelligence, SQL Server 2005, SQL Server 2005 Integration Services, SQL Server Integration Services, SQL Server stored procedures, SSIS Package, Stored Procedures

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

Answer Question   |  November 5, 2008  10:29 PM
SQL Server 2005, SQL Server 2005 Enterprise Edition, SQL Server connectivity

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?

Answer Question   |  November 5, 2008  6:15 PM
Checksum, PageVerify, SQL Server 2005, SQL Server database, TornPageDetection

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 [...]

Answer Question   |  October 31, 2008  8:34 AM
SQL Server 2000, SQL Server 2000 interoperability, SQL Server 2005, SQL Server 2005 interoperability, SQL Server interoperability

Linked servers from SQL 2000 to SQL EXPRESS 2005
I wanted to create a linked server on SQL SERVER 2000 to SQL EXPRESS 2005.Both servers are on the same machine .SQL SERVER 2000 using username and password while SQL EXPRESS using integrated security.Thanks in advance.Any one let me know how to create this?

Answer Question   |  December 15, 2008  4:51 PM
Linked servers, SQL Server 2000, SQL Server 2005, SQL Server Express

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?

Answer Question   |  October 29, 2008  11:55 PM
SQL Server 2005, SQL Server 2008, SQL Server upgrades

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 [...]

Answer Question   |  November 3, 2008  9:01 PM
SQL Server 2000, SQL Server 2005, SQL Server Query, SQL Server stored procedures, Stored Procedures

SQL server 2005 vs. SQL server 2008
What is the benefits of SQL server 2008 over 2005 (version 3.5 over 2.0)?

Answer Question   |  February 8, 2011  8:01 PM
SQL Server, SQL Server 2005, SQL Server 2008

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?

Answer Question   |  October 27, 2008  6:43 PM
SQL Server 2005, SQL Server 2005 32-bit to 64-bit upgrade, SQL Server Upgrade

Backing up SQL Server 2005 databases to a tape drive
I am currently running SQL Server 2005 and I’ve set up a maintenance plan that backs up my databases to the disk. I’d like to change that and backup my databases to a backup tape drive that’s attached to a backup server. Can this done, and if so, how?

Answer Question   |  October 28, 2008  6:00 PM
Backup, Backup to Tape, SQL Server 2005, SQL Server database