Clustering in SQL Server 2005/Windows Server 2003
Does clustering become Active/Active when using SQL Server 2005 and Windows Server 2003?

Answer Question   |  September 23, 2008  6:16 PM
SQL Server 2005, SQL Server clustering, Windows Server 2003

Linking to a table in SQL with Visual Basic
How could I link to a table in SQL using Visual Basic?

Answer Question   |  September 26, 2008  6:12 PM
SQL, SQL tables, Visual Basic

Transferring a database from Microsoft Access to SQL Server 2000
How would I transfer a database from Microsoft Access to SQL Server 2000?

Answer Question   |  September 23, 2008  6:09 PM
Access Database, Microsoft Access, SQL Server 2000, SQL Server database

Is SQL Server Upgrade Advisor worth using?
We are undertaking a technical study/risk evaluation as to whether to upgrade a substantial SQL Server database from 2000 to 2005. Is the Upgrade Advisor tool of significant benefit it assisting us with the risk evaluation? Nobody in our company has used this tool as yet, so any advice will be gratefully accepted.

Answer Question   |  September 24, 2008  3:49 PM
SQL Server 2000, SQL Server 2005, SQL Server Upgrade Advisor, SQL Server upgrades

Connecting sql server 2000 to 2 databases simultaneously
I have to create a report to move inventory from an old warehouse to a new one. Each has a separate instance of the database, so I have to get the part# and location from the old warehouse and match it with the new location for that part# in the new warehouse. Is there a [...]

Answer Question   |  September 24, 2008  3:33 PM
SQL Server 2000, SQL Server database

SSIS package failure message
I am running SQL Server 2005 and my package fails with the following error: OnError MyServerserverAD My_Object{F63BA2F3-E28F-4142-98D8-0E631F8D0D3A} {31AB7571-ECB2-4591-BFE1-CC8D59739230} Data conversion failed while converting column “Some_Column” (5017) to column “Copy of Some_Column” (6373). The conversion returned status value 4 and status text “Text was truncated or one or more characters had no match in the target [...]

Answer Question   |  September 28, 2008  1:58 PM
SQL Server 2005, SQL Server errors, SSIS

Re-applying column constraints
I have a 100+ db that was hacked. The column level constraints/defaults were removed. I’d like to know how I can reapply the constraints/defaults while keeping the data intact. I do have an identical database with no data in it.

Answer Question   |  September 26, 2008  1:26 PM
SQL Server 2005, SQL Server database, SQL Server database restore

Advice needed to reinstall SQL 2005
I’m fairly new to administrering SQL 2005. I need to reinstall SQL Server 2005 due to a few problems I’ve been having with dll’s not being registered. We also run the reporting services. I just need to know what impact uninstalling and reinstalling SQL will have on the current DB’s and reports and the historical [...]

Answer Question   |  September 28, 2008  11:20 AM
SQL Server 2005, SQL Server installation

SQL DATABASE SERVER
Hi, Please how can I access a client SQL database server remotely to update date therein. My client have this MS SQL Server Ver. 9.00.2047.00, Product Level: SP1, Edition: Standard Edition. and I will need to update the data. I have to update the database. I have downloaded SQLEXPR and installed in my PC but [...]

Answer Question   |  September 23, 2008  7:03 AM
SQL Database, SQL Server 9.x, SQL Server database, SQL Server Express, SQLEXPR

How can i connect DB and input values in stored procedures using VBA
hi all, i am using a automation tool, which is with VBA scripting. I want to execute the stored procedure by giving the values. guys help me….

Answer Question   |  September 23, 2008  6:41 AM
DB2, Stored Procedures, VBA

Designing a report in SQL from an Excel worksheet
I am trying to design a report from an Excel worksheet, and I’m not sure how to get this information into SQL. I have 180 files with multiple tabs in each that house all the data I need, but I only need one tab from each of the files. Is there an easy way to [...]

Answer Question   |  September 23, 2008  3:20 PM
Microsoft Excel, SQL, SQL Server reporting

create .csv file from table
how to create a .csv file which will contain data in 2 or more tables

Answer Question   |  September 23, 2008  2:23 PM
CSV, M-Business Anywhere, SQL Anywhere Studio, SQL Anywhere Studio/M-Business Anywhere/Avantgo

SQL2000 linked to SQL2005 doesn’t allow TRAN selects
Hi all, I have a SQL2000 machine that has a linked server that runs SQL2005 (before this was a SQL2000) When the systems were both SQL2000 from ServerA it was possible to run: BEGIN TRAN SELECT * FROM MYSVR.MYBD.DBO.MYTABLE COMMIT TRAN After the ServerB has been upgraded to SQl2005 the code above returns the error: [...]

Answer Question   |  September 30, 2008  1:53 PM
SQL Server 2000, SQL Server 2005, SQL Server errors, TRAN

Deploying 2000 reporting services reports on 2005 reporting services
Hi ! I have a large number of reports created in visual studio 2003 .They were originally deployed on SQl server reporting services 2000. Now durinfg the process of upgradation to 2005 , i transferred all the reports from 2000 server to 2005 server using RSscripter which worked fine.However , my problem is that they [...]

Answer Question   |  September 28, 2008  4:33 AM
RSScripter, SQL Server Reporting Services, SSRS, SSRS 2000, SSRS 2005, Visual Studio 2003

Updating values in a table in a SQL database
I have a SQL database with a table. I need to insert a new record into that table if there is no entry for a particular column that day, or I need to update the record if that new record already exists. I am using a count column in the table to accomplish this, and [...]

Answer Question   |  November 12, 2008  5:04 PM
SQL, SQL Database, SQL stored procedures

Questions about a SQL database with hourly transaction log backups
We have a SQL database with a full recovery model that backs up the database once a day, along with hourly backups for the transaction logs. However, we only have one transaction log backup file, and it is overwritten every time. Are transaction log backups cumulative, and if so, does that one file contain all [...]

Answer Question   |  September 23, 2008  4:50 PM
SQL, SQL Database, SQL Server backup, SQL transaction logs

Checking for a transaction isolation level in SQL Server Profiler
How could I check if a transaction isolation level is being used for a LINQ to a SQL statement in SQL Server Profiler?

Answer Question   |  September 19, 2008  4:41 PM
Isolation level, LINQ, SQL Server Profiler, SQL statements

Upgrading from SQL Server 2000 to SQL Server 2005
I have been offered a free upgrade to SQL Server 2005 Express Edition, but I am very pleased with my current version, SQL Server 2000. If I decide to upgrade, will I have any problems with our network? We use languages like C# and Visual Basic often.

Answer Question   |  September 19, 2008  4:37 PM
SQL Server 2000, SQL Server 2005, SQL Server upgrades

The specified module could not be found
We are trying to install a software (on about 70 workstations) that uses a sql type database that is stored on our server. We all have Windows XP and our server is Windows Server 2003. About half the Workstations are able to connect to the database with no problems. The rest are unable to connect [...]

Answer Question   |  September 19, 2008  3:38 PM
SQL Database, SQL Server 2000, Windows Server 2003, Windows XP

For Save .doc file in Sql Server 2000
I want to Save Word File in SQl Server, how it is possible

Answer Question   |  September 19, 2008  6:31 AM
Microsoft Word, SQL Server 2000, SQL Server import/export