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

Unidirectional replication in SQL Server 2008
Can transactional replication be bidirectional?

Answer Question   |  March 25, 2013  2:29 PM
SQL Server 2008, SQL Server replication

Linked server SQL select into
I’m trying to create a stored procedure that will trigger every 15 minutes via a server agent job. I need to pull data back from a linked server to our SQL server. The tables have the same columns/fields just different names. I know the linked server logic works because I get the data if I [...]

Answer Question   |  March 22, 2013  3:57 PM
SQL Server, SQL Server Agent Jobs

Creating service accounts in Windows 7 home edition
In Mike Hotek’s book SQL Server 2008 he gave instructions on how to create service accounts using XP. How do I create these accounts using Windows 7 home edition? Thanks.

Answer Question   |  March 14, 2013  12:38 AM
SQL Server 2008, Windows 7

Getting 2008 voting data inside Spatial
When creating a choropleth map, first I must obtain the data. If I have the table of values in my possession, what are the steps for moving the data inside Spatial?

Answer Question   |  March 4, 2013  3:16 PM
SQL Server 2008, SQL Server Spatial Data

Update duplicate records
Before change: CLAIM_ID CR/RE   Internal TAT 11061488        Rebill 27 11061488        Credit  11061488 Credit  11062027 Rebill  34 11062027        Rebill  11071404 Credit  12 11071404        Credit            After change : CLAIM_ID CR/RE   Internal TAT 11061488        Rebill  11061488 Credit  27 11061488        Credit  11062027 Rebill  34 11062027        Rebill  11071404 Credit  12 11071404        Credit         condition : if Credit – Credit [...]

Answer Question   |  November 26, 2012  12:20 PM
SQL Server 2008, SQL Server 2008 64-bit

SQL query
I have 3 columns: development no,city, status for stamp (this column is set by 0,1,2). I want to write a query that specifies percentage of stamps per city; for example percentage of stamps with 1 in city x, percentage of stamps with 2 in city x, percentage of stamps with 1 in city y….and so [...]

Answer Question   |  November 18, 2012  10:36 AM
SQL 2008, SQL Server 2008

Can any one post IKM online test questions (SQL Server 2008) please?
IKM online test questions SQL Server 2008.

Answer Question   |  November 8, 2012  11:03 PM
SQL Server 2008

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

I am getting following error for SQL server 2005/2008
Hi, I have SQL server 2005 and SQL server 2008, both are installed on the same machine. Now I want to pass the server name like mymachine\mssql2008 to one of my own stored procedure. This procedure tries to get the fully qualified table name of a particular table of some database which is on SQL [...]

Answer Question   |  September 12, 2012  6:35 PM
SQL Server 2005, SQL Server 2008

How to create an XML File from typed XML data stored in Multiple Rows and is referring to same XSD
I want to create a single XML file from typed XML data stored in Multiple Rows and it is referring to a single XSD I want to use this XSD to find the position of the respective elements present in various rows. I am using SQL Server 2008 and I am using an XML Datatype [...]

Answer Question   |  September 10, 2012  5:36 PM
SQL Server 2008, XML

machine name/sqlexpress2008r2 is giving error
Dear friends, I have just installed sql server. I created an instance name, but was not able to connect to the server. However, if I put the /SQLEXPRESS2008R2 before the machine name I am able to connect to the DB. However, when using the same connection string in the VB.Net, its giving some error. Can [...]

Answer Question   |  September 7, 2012  3:31 AM
SQL Server 2008

Career change RPG/ILE to ASP.net
After almost 30 years of RPG (from the old RPG I days) I am making the change to .Net. I felt that ASP.net would offer more of a challenge and reflect more of today’s business needs. I am still working for the same company so no real risk in the move. My question is what [...]

Answer Question   |  August 21, 2012  5:19 PM
AS/400, SQL Server 2008, Visual Studio 2008

Restore SQL Server 2008 database backup error specified cast is not valid
Received a SQL Serer 2008 database backup newdatabase.bak from a site in UK and attempted to restore it onto my server in USA. Receive error . I assume this is a Server Collation difference issue. Can anyone help me overcome this so that I may be able to restore this backup on my SQL Server [...]

Answer Question   |  July 20, 2012  5:37 PM
Server configuration, SQL Server 2008 administration

Select Statement & Where Clause ….
On an ASP web page there is a Text Box with default Values for different records. The records are stored in a SQL2008 table called dbo.SOFTWARE and have been type in manually over time and contains many duplicates. The field is called ‘BUSINESS_UNIT’. On the same page i have created a Combo Box populated by [...]

Answer Question   |  July 11, 2012  3:31 PM
ASP, SQL Server 2008, VBScript

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

Error on Transaction log Backups
Getting error -1073548784, when trying to run a backup of transactions logs ( SQL SERVER 2008, STD ed). Can anyone help?  

Answer Question   |  May 30, 2012  9:15 PM
SQL Server backup

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

SQL Server Database Maintenance Performance and Hyperthreading
I have two IBM machines with the same exact hardware 32 cores, 256GB RAM for each machine. One machine has Hyperthreading enabled and the other does not. When I run maintenance jobs (dbcc checkdb, and rebuild index) for the database that is 1TB the maintenance job takes 8 hours on the machine that has hyperthreading [...]

Answer Question   |  March 13, 2012  10:45 PM
microsoft server 2008, SQL Server 2008 64-bit