tblMashedUp

SQL Blogs on Technet

SQL Server 2008 @ Facebook

SQL YouTube Videos

SQL Posts

Clustering

Adding a node to an existing cluster

I have a two-node Windows 2008 cluster (enterprise edition) on which I have
installed a SQL 2008 cluster (Enterprise Edition) with a single instance of
SQL in an active-passive configuration. We want to add a third Windows node
and up to three additional clustered instances of SQL to this existing

6/16/2010 9:31:57 PM

NNTP Clustering

Adding a node to an existing cluster

I have a two-node Windows 2008 cluster (enterprise edition) on which I have
installed a SQL 2008 cluster (Enterprise Edition) with a single instance of
SQL in an active-passive configuration. We want to add a third Windows node
and up to three additional clustered instances of SQL to this existing

6/16/2010 9:31:57 PM

NNTP Replication

reinitialize a merge subscription

Is there a way to tell if a user selected Reinitialize subscription on a
merge subscription, SQL 2005? i am looking at the replication monitor
and it is sending tons of data (download to subscriber) as updates - no
inserts, nothing is showing the upload from subscriber, and it shows
over 28000 schema changes. i checked on the subscriber machine and the

6/16/2010 2:47:29 PM

NNTP Setup

SQL 2008R2 Install Fails with: Action "PostMsiTimingConfigAction"

When trying to install SQL2008 R2 Developer Edition x64 on Windows 7 x64, I
am getting an Error:
2010-06-12 22:05:40 Slp:
------------------------------ ------------------------------
2010-06-12 22:05:40 Slp: C:\tmp\sql\x64\FixSqlRegistryK ey_x86.exe exit code: 0
2010-06-12 22:05:40 Slp: Completed Action: FixSqlRegistryKey, returned True

6/15/2010 4:47:07 PM

NNTP Replication

Request for advice to set up replication

Hi everybody,
We currently have 2 servers: A and B.
Server A contains a production version of a SQL Server 2008 database
and B contains a development version of that database.
We wish to establish a replication of these databases as
follows:
- The production database will be replicated from A to B,
- The development database will be replicated from B to A

6/15/2010 1:14:52 PM

Clustering

Clustering SQL 2008 R2 with SQL 2008

Hello,
Can a SQL 2008 R2 box be joined to an existing SQL 2008 cluster that's not
running R2? If so, are there any known issues?
My understanding with clustering is that the versions of the boxes need to
match, especially when it comes to things like installing patches.
Therefore, to my knowledge, the above is not possible.

6/14/2010 3:44:12 PM

NNTP Clustering

Clustering SQL 2008 R2 with SQL 2008

Hello,
Can a SQL 2008 R2 box be joined to an existing SQL 2008 cluster that's not
running R2? If so, are there any known issues?
My understanding with clustering is that the versions of the boxes need to
match, especially when it comes to things like installing patches.
Therefore, to my knowledge, the above is not possible.

6/14/2010 3:44:12 PM

NNTP Replication

subscription is searching for an old snapshot

I have a pull replication which works fine for 20 subscription. But since 1
week one subscriptions gets this error:
The schema script 'AuditCommon_244.sch' could not be propagated to the
subscriber. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001)
Get help: [link]

6/14/2010 10:29:04 AM

NNTP Connect

Upsizing large Access table to SQL Server

I am using SQL Server 2005 Express and want to upsize large tables from MS
Access to SQL Server.
The upsizing wizard is skipping the large tables without any error.
The QueryTimeout value in Registry was also changed to 0 to avoid the
problem in Upsizing wizard, but the problem still remains and the large

6/13/2010 6:41:05 PM

NNTP Connect

How to Login to SQL server in ASP pages?

I am running SQLServerExpress on my desktop PC having IIS on Windows XP SP3.
I want to login to the SQL server through the ASP pages and access the
database for displaying the results on ASP pages.
I tried creating the connection string using the UDL editor with
1.) Use Windows NT Integrated Security:

6/13/2010 9:29:23 AM

NNTP Setup

SQL Server Configuration Manager WMI Provider Load Failure

Environment: Windows 7 (x64), SQL Server 2008 R2 Developer Edition. When
launching SQL Server Configuration Manager, receive cannot connect to WMI
provider due to WMI Provider Load failure [0x80041013]. I have been working
on this problem for several days now with no success. I have tried all the

6/11/2010 5:47:31 PM

NNTP Clustering

Service Account for SQL Server 2000 Cluster

Dear All,
One of my customer is running a active/active SQL 2000 cluster in
Windows 2003 and the service account for one of the instance is
LocalSystem account.
I am not sure how they changed the service account to localsystem
because SQL Server doesn't allow LocalSystem account as your service
account when you install it on a cluster and it doesn't allow to

6/10/2010 4:20:51 AM

Clustering

Service Account for SQL Server 2000 Cluster

Dear All,
One of my customer is running a active/active SQL 2000 cluster in
Windows 2003 and the service account for one of the instance is
LocalSystem account.
I am not sure how they changed the service account to localsystem
because SQL Server doesn't allow LocalSystem account as your service
account when you install it on a cluster and it doesn't allow to

6/10/2010 4:20:51 AM

Clustering

SQL2005 named instance can't be failed-over

Howdy, all.
I've got a two-node (active/active) SQL 2005 cluster running on Server 2008
Enterprise on which a named instance (ICR) has been installed and is running
perfectly on node 2 of the cluster (the default instance runs on node 1 and
is easily failed-over to node 2). I am, however, unable to fail the named

6/9/2010 3:08:36 PM

NNTP Clustering

SQL2005 named instance can't be failed-over

Howdy, all.
I've got a two-node (active/active) SQL 2005 cluster running on Server 2008
Enterprise on which a named instance (ICR) has been installed and is running
perfectly on node 2 of the cluster (the default instance runs on node 1 and
is easily failed-over to node 2). I am, however, unable to fail the named

6/9/2010 3:08:36 PM

1 2 3 4 5 6 7 8 9 10
11 12 13 14 15 16 17 18 19 20
21 22 23 24 25 26 27 28 29 30
31 32 33 34 35 36 37 38 39 40
41 42 43 44 45 46 47 48 49 50
51 52 53 54 55 56

pBlogCategories

sys.books