tblMashedUp

SQL Blogs on Technet

SQL Server 2008 @ Facebook

SQL YouTube Videos

SQL Posts

Clustering

How many nodes SQL Server 2008 standard support

Hi,
I have question related how many nodes SQL Server 2008 supports? it has
written 2 nodes only.
I have windows 2008 enterprise edition with 2 nodes, and SQL 2008 SE
Clustered install as Active\Passive. I am going to get 2 new windows 2008
enterprise edition nodes, which i am going to build Active\Active cluster,

4/20/2010 3:08:03 PM

NNTP Clustering

How many nodes SQL Server 2008 standard support

Hi,
I have question related how many nodes SQL Server 2008 supports? it has
written 2 nodes only.
I have windows 2008 enterprise edition with 2 nodes, and SQL 2008 SE
Clustered install as Active\Passive. I am going to get 2 new windows 2008
enterprise edition nodes, which i am going to build Active\Active cluster,

4/20/2010 3:08:03 PM

NNTP Replication

Could not find stored procedure 'sp_MSins_XXX' - SQL Server 2000

Hello All,
First of all, I am using SQL Server 2000. Hopefully, it won't be for much
longer.
Using SQL Trace, I discovered that the distribution agent was failing
because it was calling sp_MSins_XXX;2. This procedure does not exist in my
subscriber database. I created a custom set of procedures for a lot of

4/19/2010 6:21:01 PM

Clustering

Re-Installing A Clustered Node For SQL 2008

I have a 2 node active/passive cluster running SQL2008 with SP1.
Installation was performed by command line script using a config file.
Started with 1st node with /action = "InstallFailoverCluster". Second node
was installed with a diff config file using the /action= "Add Node". Cluster
operational for over 6 months.

4/15/2010 11:09:01 PM

NNTP Clustering

Re-Installing A Clustered Node For SQL 2008

I have a 2 node active/passive cluster running SQL2008 with SP1.
Installation was performed by command line script using a config file.
Started with 1st node with /action = "InstallFailoverCluster". Second node
was installed with a diff config file using the /action= "Add Node". Cluster
operational for over 6 months.

4/15/2010 11:09:01 PM

NNTP Clustering

SQL 2008 Mirror

Can anyone tell me how many databases can be mirrored from one SQL2008 server
to another SQL2008 server.
Thanks.
Pete.

4/15/2010 4:03:02 PM

Clustering

SQL 2008 Mirror

Can anyone tell me how many databases can be mirrored from one SQL2008 server
to another SQL2008 server.
Thanks.
Pete.

4/15/2010 4:03:02 PM

NNTP Clients

ODBC Authentication Taking Too Long

Greetings,
I have an application server connecting to a SQL server via an ODBC
connection to run reports. The application log indicates that the ODBC
authentication (SQL authentication) seems to be taking 30 seconds each time
before commencing with the processing.
Any ideas on a cause?
Details:
Application Server: Server 2003 SP2 x86 fully patched, SQL native client v

4/15/2010 8:54:01 AM

NNTP Replication

Merge Subscription Snapshot Fail: Invalid Object Name 'sysmergeschemachange'

I am trying to set up a merge subscription between two servers. They
had a merge subscription, and it stopped working inplexicably. In
trying to remove the prior subscriptions and re-enable replication, I
removed all the replication tables and stored procedures and recreated
them. I have also disabled and re-enabled replication on the

4/14/2010 1:36:13 PM

NNTP Replication

Dropping Indexes on Publisher Database

Hello,
I have a transactional replication in SQL 2000.
If I understand correctly, all the indexes get replicated to the
Subscriber database.
What happens if I drop an index on publisher database?
Will my index on Subscriber Database also get dropped?
Will my replication error out?
Thanks

4/13/2010 4:39:59 PM

NNTP Replication

Horizontal Filtering

This should be easy!
I'm setting up transactional replication. Say that I set up a
horizontal filter such as: mytable.CurrentInfo=1. After the
snapshot's been applied, and everyone's happy, the following happens
at the publisher:
For a given replication row, mytable.CurrentInfo is updated from 1 to

4/12/2010 8:40:36 PM

NNTP Connect

What's the steps to modify a .adp connect string & convert DAO to

What are the steps needed to modify a .adp (Access Data Project) file
connection string and convert the DAO (Data Access Object) code to it's
equivalent ADO (ActiveX Data Objects)? I'm converting a MS Access2007
database
project to SQL Svr2005 back-end and wish to have Access2007 remain as the
front-end aplication. Please note, I have used the Upsizing Wizard to create

4/12/2010 2:31:01 AM

NNTP Clustering

SQL Server 2005 Cluster When Applying SP3

When applying SQL Server 2005 service pack 3 to Windows 2003 server, I
received the following error listed below.
Please help me resolve this issue.
Exit code 29528
Task Scheduler: Created remote folder for product instance target \\XSQL03
Task Scheduler: Transferred payload to remote product instance target \\XSQL03

4/12/2010 2:05:01 AM

Clustering

SQL Server 2005 Cluster When Applying SP3

When applying SQL Server 2005 service pack 3 to Windows 2003 server, I
received the following error listed below.
Please help me resolve this issue.
Exit code 29528
Task Scheduler: Created remote folder for product instance target \\XSQL03
Task Scheduler: Transferred payload to remote product instance target \\XSQL03

4/12/2010 2:05:01 AM

NNTP Replication

Issues with Websynchronisation

Our Server:
- Windows Server 2008 Web Edition R2 x64
- MS SQL Server 2008 Standard Edition SP1 x64
- IIS 7.5
PDAs:
- SQL Server Compact Edition 3.5
- WindowsMmobile Professional 6.5
Goal:
We have a database and want to establish a mergereplication between the SQL
Server 2008 Standard Edition (as publisher) and several PDAs with a SQL

4/8/2010 11:59:01 AM

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

pBlogCategories

sys.books