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
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
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
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
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
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
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
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
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
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
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?? 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
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
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
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
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
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
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
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
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