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