Server upgrade 2003 to 2008
I’m upgrading my server hardware, I currently have server 2003. I also want to upgrade to server 2008 too. The new server I’m getting comes with its own new drives. How can I upgrade to a completely new server and upgrade to 2008, while retaining all of my data and Active Directory, etc.

Answer Question   |  March 26, 2013  10:13 PM
SQL Server 2003, SQL Server 2008 R2

mdm.udpValidateModel can be run twice with no side effect.
I am new to MDS, client give me the mdm.udpValidateModel SP with @username etc. parameter. i don’t know i parsed first time or executed. I again executed. will there will be any side effect . please guide me urgently. urgent. SET @User_ID = (SELECT ID FROM mdm.tblUser u WHERE u.UserName = @UserName ) SET @Version_ID [...]

Answer Question   |  October 29, 2012  11:38 AM
SQL Server 2008 R2

File server
I have a server 2008 R2 that while in Explorer on the left navigation pane show “Network” and under that a list of workgroup computers (it’s a file server) I have one computer in that network thats name is blue and underlined. Is there significance to this?

Answer Question   |  June 19, 2012  12:14 AM
SQL Server 2008 R2

Scrip an select from linked Oracle database in Management studio gives multiply fields
In SQL Server 2008 R2 Management studio under Linked servers I want to script a select from an Oracle database table. The result is that many of the fields occur three times. What can the reason for that be? See this example: SELECT [RATETYPE],[RATETYPE],[RATETYPE]             ,[FROMCURRENCY],[FROMCURRENCY],[FROMCURRENCY]       ,[TOCURRENCY],[TOCURRENCY],[TOCURRENCY]       ,[VALIDFROM],[VALIDFROM],[VALIDFROM],[EXCHRATE]       ,[FROMFACTOR]       ,[TOFACTOR]       ,[CREATIONDATE],[CREATIONDATE],[CREATIONDATE] [...]

Answer Question   |  May 30, 2012  11:42 AM
Oracle Database, SQL Server 2008 R2

Sql Server 2008R2 on Windows Sever 2008 R2
When i attempt to install it tells me that my operating system is not supported, rule “Operating system supported edition” failed. however when i check the list of valid operating system it is listed, anyone had this issue before or know why i wont recognize, thank you

Answer Question   |  May 16, 2012  3:48 PM
SQL Server 2008, SQL Server 2008 R2, Windows Server 2008 R2

session error
Just upgraded a vendor app from sql 2005 to sql 2008 r2 sp1 and are consistently getting Error: 18056, Severity: 20, State: 29. The client was unable to reuse a session with SPID 72, which had been reset for connection pooling. I have applied all patches and stil lcan’t get rid of error. User’s seeing [...]

Answer Question   |  February 28, 2012  3:12 PM
SQL Server, SQL Server 2008, SQL Server 2008 R2

Error Message in SQL Server 2008 code.
Hi, I am currently going through the Tutorials on SQL Server Management Studio 2008 R2. One of the samples instructs me to run the following code: SELECT  Mgr.EmployeeID AS MgrID, Mgr.LoginID AS Manager,  Emp.EmployeeID AS E_ID, Emp.LoginID, FROM EmployeeDemo AS Emp LEFT JOIN EmployeeDemo AS Mgr ON Emp.ManagerID = Mgr.EmployeeID ORDER BY MgrID, E_ID; [em]When [...]

Answer Question   |  March 31, 2012  11:20 AM
SQL Query, SQL Server 2008 R2, SQL Server Management Studio, SSMS 2008

Challenge improving query performance on large tables
Hi, Here’s the structure of the db I’m using: * Table frs_ArticlesBDFournisseur which contains article main data.One row per article/color. Key is Refrefart (int). Size is over 220000 rows at the momemt. Only index is the PK (clusterred). * Table frs_ArticlesBDFournisseurTaille contains all the various sizes and barcode for the corresponding article/color from the previous [...]

Answer Question   |  March 31, 2012  2:21 PM
Query optimization, Query performance, SQL query optimization, SQL Server 2008, SQL Server 2008 R2

connecting to SQL server with mdf files
What is the best way to connect a website on a VPS to sql server 2008 R2 express, using MDF files as databases. The VPS is running on server 2008 R2. I installed the same environment on the development computer. IIS gets a connection because it sees the users that are in the ASPNETDB.MDF file. [...]

Answer Question   |  March 31, 2012  12:52 AM
.MDF files, SQL Server 2008, SQL Server 2008 R2

sys.conversation_endpoints build up
 It Seems that there is a lot of problems with SB cleanup? I have SQL 2008 r2 running on two different servers. The target system processes the millions of records in the queues but will not clean out the sys.conversation_endpoints, or the sys.conversation_endpoints tables. This is part of the activation proc that is run on [...]

Answer Question   |  March 31, 2012  11:40 PM
SQL Server 2008, SQL Server 2008 R2, SQL Server Service Broker, SQL Service Broker

How do I create jobs using steps in SQL Server 2008 R2 Management Studio
How do I create jobs using steps in SQL2008 r2 Management Studio? I am really having a problem with the syntax when using operating-system commands and transact-SQL commands. Examples would be great.

Answer Question   |  March 31, 2012  11:56 AM
Management Studio, SQL Server 2008, SQL Server 2008 R2, SQL Server Management Studio, SQL Server Management Studio 2008

The SSIS 2008 R2 job does not complete execution
I have an SSIS package created in 2005 SP2. I have compiled this and is sheculed to run under SQL Server 2008 R2, which connects to a SQL Server 2005 database. What the package does. 1.The package FTP’s some files to the local folder. I verified to confirm the files are downloaded correctly. 2. Truncate [...]

Answer Question   |  June 13, 2011  5:10 PM
SQL Server 2008, SQL Server 2008 R2, SQL Server Integration Services, SQL Server tables, SSIS, SSIS 2008, SSIS Job

SSIS 2008 R2 performance and Windows Server 2008 R2 with a clustered SQL instance is slower than when connecting to a non-clustered instance?
I am testing different configurations for loading data from a remote SQL server using SSIS. In a clustered situation SSIS seems slower to speak to the local clustered SQL instance when compared to a non clustered local SQL instance. It looks like any scenario where SSIS speaks to a clustered SQL instance; the communication occurs [...]

Answer Question   |  May 22, 2011  9:22 AM
Business Information Warehouse, SQL Server, SQL Server 2008 R2, SQL Server 2008 R2 Performance Monitoring, SQL Server Performance Monitoring, SSIS, Windows Server 2008 R2

Frequency of witness pings to partners
Does anyone know how often the witness instance pings the partners? I am aware of the timeout setting but want to know exactly how often the ping is initiated. Is it the same or different from the timeout value. Thanks in advance for your reply.

Answer Question   |  May 4, 2011  6:59 PM
Network Timeout, SQL Connection Timeout, SQL Server 2005 SP3, SQL Server 2008 R2

SQL Server Fails to Start When Moved to Different Node
Sql 2008 R2 on Windows 2008 R2 cluster. When I move instance from node 1 to node 2 everything is fine: all resources come online as they should. When I move the instance from node 2 to node 1, all resources except sql server and agent come online. If I delete errorlog and start the [...]

Answer Question   |  April 11, 2011  5:24 PM
Failover Clustering, Failover Clustering nodes, SQL Server, SQL Server 2008, SQL Server 2008 R2, SQL Server clustering, Windows Server 2008 R2

International SQL Server Replication
I have a unique challenge involving keeping 2 SQL Server Databases in synch, one of which will reside in Iraq, the other will be in a base camp in Kandahar, Afghanistan where the local clinic will use a client application that communicates to the local database. The database in Iraq will be for billers to [...]

Answer Question   |  February 22, 2011  8:28 PM
Secure Data Transfer, SQL replication, SQL Server, SQL Server 2008, SQL Server 2008 R2, SQL Server database, SQL Server replication

SQL Server 2008 r2 won’t install
I receive the following error when installing SQL Server. I have installed .net 4.0 full x64 bit as some sites suggest but I can’t get past the failure. The following error has occured: An error occurred during the installation of assembly ‘policy.8.0.microsoft.vc80.crt, version=’8.0.50727.4027′, publickeytoken=’1fc8b3b9a1e18e3b’, Processorarchitecture=’x86′,type=’win-32-policy’. HRESULT:0x800736fd I have uninstalled, installed . I am out of [...]

Answer Question   |  March 4, 2011  11:00 AM
SQL Server, SQL Server 2008, SQL Server 2008 R2, SQL Server installation, Windows Server 2008, Windows Server 2008 R2

Cross-database name change in SQL Server 2008 stored procedures
Hi: The easy part is the databases will be on the same server.  However at the moment I am writing code in database SOMEDATABASE_TEST which is accessing objects in SOMEOTHERDATABASE_TEST.  When its time to go to production the names are going to change to SOMEDATABASE and SOMEOTHERDATABASE.  However the queries in SOMEDATABASE_TEST stored procedures read: [...]

Answer Question   |  February 2, 2011  5:03 PM
SQL 2008, SQL Server 2008 R2, SQL Server stored procedures, Stored Procedures

I need to replace a word in a Document through SQL Server 2008
Hello  i’m using SQL 08 R2 to store my resume collection , i want Sql to find an Email  in the MS WORD document and replace it with an empty string  so far I’ve succeeded to find the word using fullTextSearch  this my example for finding the documents that contain an email  SELECT  document FROM [...]

Answer Question   |  January 4, 2011  3:52 PM
SQL 2008, SQL Server, SQL Server 2008, SQL Server 2008 R2

SOLAP in SQL 2008R2
IS there SPATIAL OLAP implementation in SQL 2008R2

Answer Question   |  December 20, 2010  9:28 PM
GEOSpatial, Oracle OLAP, SQL Server 2008, SQL Server 2008 R2, Windows Server 2008, Windows Server 2008 R2