What is the best way to replicate SQL 2008 DBs to a failover site?
We are looking to replicate our SQL 2008 databases to a hot failover site.  We can’t use DB mirroring due to the number of databases we have.  Has anyone replicated databases to a hot site using a replication solution and what was your experience.

Answer Question   |  November 16, 2010  3:58 PM
Failover, SQL Server, SQL Server 2008, SQL Server database, SQL Server replication

Using Excel 2010 to pull data from SQL Server?
How can I use excel 2010 to pull data from my sql server? I have an odbc connection set up and need data from a specific table in a specific database. I want excel to do some projections and calculations.

Answer Question   |  November 1, 2010  9:05 PM
Excel 2010, Excel Database, ODBC, SQL Server, SQL Server database

How to find Windows Operating system values for SQL database: OSId, Descr, Edition, ver, arch,
I’m managing a large group of virtual machines using SysCenter Virtual Machine manager (SCVMM). I want to add data to the SQL Database for SCVMM application so that additional operating systems will be available in the properties of the SCVMM application. I know how to do the statements which add the data to the database table and [...]

Answer Question   |  September 23, 2010  4:28 PM
Operating system Values, OSID, SQL Server database, Systems Center Operations Manager, Windows, Windows Server 2008, Windows Server 2008 R2

SQL Server 2005 backup server
Is there a way to replicate a SQL server database to another SQL server with the same hardware and software? I want a live copy of the data up to date in case something goes wrong and we need to switch to the backup server.

Answer Question   |  January 30, 2012  8:08 PM
Backup, Backup and Recovery Hardware, SQL 2005, SQL Backup, SQL Server 2005, SQL Server database

Help navigating SQL Server 2008 database?
Hi all, I’m facing an interesting challenge… Lets say: I have a payment coming in and of course my client has not specified which of the 45 open invoices he is paying. The amount does not match any single invoice so it has to be a combined payment for 2 or more invoices. Now, I [...]

Answer Question   |  August 31, 2010  8:44 AM
SQL Server 2008, SQL Server 2008 administration, SQL Server database, SQL Server tables, VB.NET

How to display values in one table by referring and checking values in another table?
how to display values in one table by refering and checking values in another table

Answer Question   |  July 28, 2010  8:08 AM
SQL Database, SQL Server, SQL Server database, SQL Server tables, SQL tables

sql 2008 export to txt for backup and incremental backup
Hi i have one db that i want to back up, so thought id export to txt file/flat file then back that up and then daily increments into that file? cant find the steps to do it..have the wizard..

Answer Question   |  July 23, 2010  10:34 AM
Backup, SQL 2008, SQL database replication, SQL Server, SQL Server 2008, SQL Server database

Mirroring SQL Server 2008 to a disaster recovery machine twice a day
I want to mirror my SQL Server 2008 to a disaster recovery machine two times a day. Is there any free software to do this on a running SQL Server? If not, are there any cheap alternatives? Can scripts be run to copy the files over while SQL is running? Can I use shadow copy [...]

Answer Question   |  July 21, 2010  1:59 PM
Disaster Recovery, Shadow Copy, SQL Server, SQL Server 2008, SQL Server backup, SQL Server database

SQL To Excel Data Dumping with the help of SSIS flow task.
I am trying to do a Sql To Excel Data Dumping with the help of ssis flow task.I create a sql connection and give the query in the sql source.I aslo have a excel template to map in excel destination ready which has around 400 columns/fields.In bettween i use a dataconvrsion for unicode/non unicode issue.Now [...]

Answer Question   |  July 19, 2010  3:37 PM
Excel 2003, Excel Metadata, SQL Server database, SQL to Excel Database Conversion, SSIS Package

Best way to back up SQL Server 2008 database?
What’s the best way to back up my SQL Server 2008 database? We are currently backing up the SQL data files during off hours but soon we’ll be going 24/7 and we’ll need to use maintenance plans and shadow copy. Can someone provide help?

Answer Question   |  July 16, 2010  7:50 PM
Shadow Copy, SQL Server 2008, SQL Server 2008 administration, Sql Server 2008 Backup, SQL Server database

Connecting to the SQL- SERVER from VS-2008 C#
How can I connect to the SQL SERVER from the VS-08 C# and how can I insert, modify and view the database in SQL SERVER.

Answer Question   |  July 15, 2010  11:55 AM
Connecting to SQL SERVER FROM C#, SQL Server connectivity, SQL Server database, Visual C# 2008, Visual Studio 2008

Linking users of Access 2003 to SQL Server 2008 database
We plan to go to SQL Server 2008. We need to link our Microsoft Access 2003 users to the databases created in SQL Server 2008. Will we be able to do this considering ODBCAD32 is what we use, and the databases we create will now be 64-bit?

Answer Question   |  June 28, 2010  8:03 PM
Access 2003, SQL Server 2008, SQL Server database, SQL Server Management, SQL Server Migration Assistant

Import data file into SQL database
I need to import tis .dat file into sql database table having four column client-007092~WITCO clname-CORPORATION ,matter-0005,mattername-LAZY OIL V. WITCO

Answer Question   |  June 1, 2010  4:38 PM
Data File Utility, SQL Database, SQL Server database

Java Code to Copy AS400 file to SQL Server database/table
I need Java code to access and copy an AS400 file to SQL Server database/table. It must also copy a specific amount of records from the SQL Server side. 

Answer Question   |  May 26, 2010  7:24 PM
AS/400, Java, Java code, SQL Server, SQL Server database

SQL server 2000 sp3 database remote access
hi i want to access a sql server 2000 sp3 database in remote system where no sql server 2000 is installed. can anyone help me for this?

Answer Question   |  May 6, 2010  6:27 PM
Remote SQL Server, SQL Server 2000 SP3, SQL Server database

SQL Server user name issue
We have a server in which Windows 2003 is installed and we have created users in the domain (e.g. – aaa). The server is installed with SQL Server 2000 and data is stored in the database. The user name for the server is “administrator.” When we login from the user computer with the same name [...]

Answer Question   |  April 9, 2010  3:38 PM
SQL Server 2000, SQL Server database, SQL Server User Accounts

MS DNS query logging to sql server?
Does anybody know if it is possible using 2003 server r2 dns to log querys to a sql server database instead of a file?

Answer Question   |  March 3, 2010  10:19 PM
DNS queries, SQL Server database, Windows Server 2003, Windows Server 2003 R2

Removing and adding new space to databases.
The scenario: SQL_SVR_A (2000)has x amount ‘too much’ SAN disk space that they want to reclaim/use to allocate to SQL_SVR_B (2000)- which doesn’t have enough space. What is the best method to, first, remove the disk space and keep all DBs in-tact and secondly, how to add new space to ServerB, keeping the DBs in-tact, [...]

Answer Question   |  February 24, 2010  7:38 PM
SAN, SQL Server, SQL Server database

Merging MDF files on SQL databases after restoring from a backup
I recently restored our SQL Server database from a backup, but unfortunately I used a Wednesday backup instead of Thursday, and it is now Friday. Is there a way to merge MDF files, to join all the data together because, as of now, we are missing Thursday’s data.

Answer Question   |  February 24, 2010  7:34 PM
MDF, SQL Server, SQL Server database

Monitoring log files in a SQL Server 2000 database
I have an intermittent problem with a SQL Server 2000 database. The job, to truncate the log files, doesn’t start on time, and the transaction fills up preventing users from logging in. I would like to monitor the log such that I can send an alert when the log reaches e.g. 80% full.

Answer Question   |  February 24, 2010  9:18 PM
SQL Server 2000, SQL Server 2000 Database, SQL Server database, SQL Server logs