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

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

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

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

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

Compression in SQL Server 2008
how can i use compress backup option  in sqlserver 2008r2 

Answer Question   |  May 18, 2012  5:35 AM
compressed backup, SQL Server 2008

cluster install node failure when adding
I installed a sql server 2008 cluster, first node went fine, however the 2nd node install fails with the following installing failover node sql server 2008 This resource does not have all the nodes of the cluster listed as ‘Possible Owners’. The group that this resource is a member of will not be able to [...]

Answer Question   |  October 11, 2011  8:27 PM
Cluster management, SQL Server 2008, SQL Server clustering

Halt audit trace if audit file doesn’t rollover
I have a security requirement for SQL Server 2005 and 2008: “SQL Server shall be configured to halt if a failure in audit file rollover occurs”. How do I accomplish this?

Answer Question   |  March 31, 2012  4:59 PM
Audit File Rollover, Audit Trace, SQL audit, SQL Security, SQL Server 2005, SQL Server 2008

Setup SSIS for a group of developers.
I newbie and I need help here. We are doing a new MS SQL and BI setup for our developers here. We have a team of 12 developers here doing different projects. We have one server with MS SQL being installed. This single MS SQL will be setup with each individual database for the projects that [...]

Answer Question   |  March 31, 2012  3:16 AM
SQL 2008, SQL Server, SQL Server 2008, SSIS

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