How to transfer database from SQL Server 2008 to SQL Server 2005
how to attach database of  sql 2008 into sql 2005

Answer Question   |  December 1, 2010  6:13 AM
SQL, SQL Database, SQL Server 2005, SQL Server 2008, SQL Server migration

How to convert XML data into tabular form in SQL Server 2005
Hi, I have a concatenated string of XML data. I need to convert the string into tabular form. Please suggest how it can be done. Thanks in advance!

Answer Question   |  November 29, 2010  12:02 PM
SQL Server, SQL Server 2005, XML, XML development, XML File Creation

Microsoft SQL Server BCP Utility password
I am executing a Microsoft SQL Server Job that runs a BCP Utility.  The utility loads a table from a file using the ‘in’ argument, a format file and an error file.  I have ‘hard coded’ the user name and password in the command line using the ‘U’ and ‘P’ arguments. I am looking for a [...]

Answer Question   |  November 23, 2010  7:42 PM
BCP Utility, BCP Utility password, SQL Jobs, SQL Server, SQL Server 2005, SQL Server 2005 Enterprise Edition, SQL Server Enterprise Edition

Is it safe to delete SQL Server Transaction Log?
In one point, I create two Transaction Log for a database, and now I want to delete the second Transaction Log in order to free more space. I just want to get ride of the second file. Is it safe to delete it? SQL Server allow me to do it from DATABASE PROPERTIES WINDOW, but [...]

Answer Question   |  November 18, 2010  11:59 PM
Delete Transaction Log, SQL 2005, SQL Server 2005, SQL Server logs, SQL Server transaction logs, SQL transaction logs, Windows Server 2003

How to add an article in transactional replication in sql server 2005?
How to add an article in transactional replication in sql server 2005? and what are the prerequisites for trnsactional replication?

Answer Question   |  November 15, 2010  6:55 AM
DBA, SQL, SQL Server, SQL Server 2005, Transactional replication software

Filename from SQL 2005 Query
I have a batch file that runs a SQL query command overnight once a week and outputs the results of that query to a file as a .csv file. The query produces, amongst other things, a week ending date. Is it possible to to name the output file with result of the week ending column [...]

Answer Question   |  November 12, 2010  12:56 PM
Batch files, SQL 2005, SQL Query, SQL Server, SQL Server 2005

SQL SERVER SAN Setup
I do not know much about SAN’s, I want to setup a SQL Server to use a SAN. 1. Should I use a SAN drive to install the OS or is it best practice to install the OS on a local drive on the server? 2. Should I install SQL SERVER on the SAN or on a [...]

Answer Question   |  November 15, 2010  9:15 PM
SAN, SQL, SQL 2005, SQL Server, SQL Server 2005, SQL Server 2005 (32-bit)

Cannot forward events from SQL Server 2005
I’m trying to forward events from SQL Server 2005 SP3 to a different server, but the only server I can select is the local server.  What must I do to see other servers in the Event Forwarding Server drop-down box?

Answer Question   |  November 1, 2010  4:03 PM
SQL, SQL Server 2005, SQL Server 2005 SP3, SQL Server Agent

Documenting stored procedure jobs in SQL 2005 enterprise
Our consultant created several stored procedure jobs within SQL 2005 enterprise. How can we view them to document them? SQL runs on a Windows 2008 box with 32gb of memory.

Answer Question   |  November 1, 2010  2:19 PM
SQL 2005, SQL procedure, SQL Server 2005, SQL Server 2005 Enterprise Edition, Stored Procedures, Windows Server 2008

How do I INSERT records into AS400 DB2 file from SQL server?
I can pull data from AS400 to SQL but cannot get my command on the SQL server to push the data back.  This is a very small process, I only need an item number and date. Also, the date on the SQL db is “datetime”.  I’ll need to convert that to a more recognizable date field [...]

Answer Question   |  November 3, 2010  3:52 PM
AS/400, DB2/400, SQL Server, SQL Server 2005

Migrating SQL Server 2000 to SQL Server 2005
How can we migrate our sql server 2000 to sql server 2005 on another box? We have about 36 databases and it is around 65 terabytes of data on an external array. The array will be connected to the new server.

Answer Question   |  January 6, 2011  3:21 PM
Array, SQL Server 2000, SQL Server 2000 migration, SQL Server 2005, SQL Server migration, SQL Server Upgrade

SQL Server 2005 Enterprise Edition SP3 Performance
We have SQL SERVER 2005 SP3 Enterprise 32-bit running on a windows server 2003 Enterprise 32-bit with 32GB of RAM and 8 dual core processors. Our CPU, RAM, and I/O are always through the roof and the application is always running slow. We use AWE for buffer cache the maximum memory is 28GB, the PAGEIOLATCH_SH [...]

Answer Question   |  January 31, 2011  3:27 AM
SQL, SQL performance, SQL Server, SQL Server 2005, SQL Server 2005 SP3, SQL Server Enterprise Edition

SQL SERVER 2005 Database Options
We have a database in production that is 500GB, what are the pros and cons for setting the ”Page Verify” option to ”NONE” on the database for best performance? How will ”TORN_PAGE_DETECTION” and “CHECKSUM” affect performance?

Answer Question   |  October 28, 2010  3:08 PM
SQL, SQL Database, SQL Server, SQL Server 2005, SQL Server 2005 Database

Extracting in SQL Server 2005
IS THERE ANY WAY TO EXTRACT FROM A FIED EXAMPLE: I HAVE A ADDRESS LINE AS 1065 VALLEY LANE APT 120                                                       SCHAUMBURG                                                        IL 60195 I NEED TO EXTRACT APT 120  INTO ANOTHER LINE LIKE APT 120                                                                      1065 VALLEY LANE                                                                       SCHAUMBURG                                                                        IL 60195

Answer Question   |  October 27, 2010  1:17 PM
EXTRACT, Field-Level keywords, SQL 2005, SQL 2005 Database, SQL Server 2005

SQL Server 2005 Memory
I have a server with 8 dual core processors, 32GB of RAM, windows server 2003 32bit, sql server 2005 enterprise, and a 500GB database running on it. 1. How does sql server use memory in this case? 2. I have heard from sql server pro’s that sql server can only use 4GB of RAM is that [...]

Answer Question   |  October 26, 2010  1:54 PM
SQL, SQL 2005, SQL Server, SQL Server 2005, SQL Server memory

Rolling back a SQL server 2005 database.
We need to roll back a copy of our database 5 hours. We are running sql 2005 on a windows 2003 server. How can we do this? We do not want to effect production data but want to report against the 5 hour old data.

Answer Question   |  October 23, 2010  5:33 PM
SQL Server 2005, SQL Server administration, SQL Server Database Rollback, SQL Server Rollback

Web Hosting strategy – NAT’ing and ARR
I’m looking to develop a new strategy for our web hosting farm. Currently I’ve got  set of standalone IIS 6 web servers and sql 2005 database servers sitting in a network behind a kerio winroute proxy (which handles our nat’ing and intrusion prevention and VPN to our office location) which in turn sit behind a [...]

Answer Question   |  October 18, 2010  10:35 AM
IIS, IIS Server, Netgear switches, Network Address Translation, SQL 2005 Database, SQL Server 2005

Why does SQL server use no more than 500MB in RAM?
Why does sql server use no more than 500mb in ram? We have sql server 2005 running on server 2003 32bit with 32GB of ram and in the task manager under processes, Mem Usage sqlservr.exe is only using 430, 268 K. SQL Server min memory is set to use 25GB and max is set to use [...]

Answer Question   |  October 15, 2010  5:50 PM
CPU, RAM, SQL, SQL Server, SQL Server 2005, SQL Server memory, Windows Server 2003 32-bit

SQL Server 2005
Is user cloning the only way to use windows authentication in sql server?

Answer Question   |  October 9, 2010  3:34 PM
SQL Server 2005, SQL Server 2005 connectivity, SQL Server Express 2005, Windows 7, Windows authentication

Disaster recovery for SQL 2005
How can we setup a disaster recovery sql server? We are running SQL 2005 on a 2003 box. We need a real time exact replica we can switch to?

Answer Question   |  October 7, 2010  4:58 PM
Disaster Recovery, Replicating databases, SQL Backup, SQL Security, SQL Server 2003, SQL Server 2005, SQL Server 2005 security