tblMashedUp

SQL Blogs on Technet

SQL Server 2008 @ Facebook

SQL YouTube Videos

SQL Posts

NNTP Clients

Saved queries connecting

I have two users on separate PCs each sing management studio express 2005.
When one opens a saved query, they automatically get the popup connection
dialogue prepopulated with server and authentication details.
The other user just gets the query showing with no connection dialogue.
Why the difference in behaviour and how do I get the second user to be the

3/31/2010 10:24:01 AM

NNTP Replication

transaction replication failing

Hello Gurus,
We have a transactional replication running between two production
SQL2K5 servers, one server is the publisher and the distributor while
the other is only a subscriber. At this point the replication monitor
is showing a running status. The row count between the two servers is
off. We ran the initialization, the monitor and verification of the

3/30/2010 6:29:23 PM

NNTP Replication

Maintaining a timely warehouse

I want to try to use Transactional replication to build a warehouse of
our 90 databases....
I've got the warehouse shell set up, and publications that Keep
existing data when they sync. All databases are identical in schema,
and they now contain a Location column that is now used in the primary
key. So far so good: I have two databases pouring data into the

3/30/2010 5:01:42 PM

NNTP Replication

Unable to synchronize the row because of inadequate permissions

SQL2000 merge replication.
The row was deleted at 'devicename.dbName' but could not be deleted at
'server555.SFADB_dbName'. Unable to synchronize the row because of inadequate
permissions.
Anyone have a solution for this error?

3/30/2010 3:11:01 PM

NNTP Connect

One of my application servers cannot get an JDBC XA connection to the SQL Server

Currently we are using SQLServer JDBC Driver version 1.2. My SQL Server
version is Microsoft SQL Server 2005 SP2 - 9.00.3042.00 (X64).
We are getting the following error while restarting the DTC while there are
connections.
javax.transaction.xa.XAExcepti on: java.sql.SQLException: DTC_XA_START:Status:

3/29/2010 12:04:52 PM

NNTP Connect

Tagging a connection for profiler

Hi,
We have a .NET application using connection pooling. What we would like to
be able to do is somehow associate a connection with a session id (an id used
by our application to represent a login session) for the duration of each
command issued on behalf of the session. This would allow us to filter on

3/26/2010 11:03:01 PM

NNTP Clustering

Not all instances on all nodes

I have a sucessfully running cluster with instance IDs available on both, and
with failovers sucessful. I added a third server, Windows 2008 SP2, and have
added another instance of SQL 2008. My problem is that the only one of the
first two SQL instance IDs are available within SQL on the new server, and

3/26/2010 11:25:01 AM

Clustering

Not all instances on all nodes

I have a sucessfully running cluster with instance IDs available on both, and
with failovers sucessful. I added a third server, Windows 2008 SP2, and have
added another instance of SQL 2008. My problem is that the only one of the
first two SQL instance IDs are available within SQL on the new server, and

3/26/2010 11:25:01 AM

NNTP Clients

Windows 7 SQL Server Management Studio cannot connect to SQL Server 2005 - SOLVED

Searching for help on this problem, I found a lot of stuff having to
do with server configuration, and other distractions, and having
figured out the solution (at the end of at least 4 hours of
thrashing), I wanted to share it for the benefit of others.
PROBLEM: A Windows 7 machine with SQL Server Management Studio 2005

3/24/2010 6:21:42 PM

NNTP Connect

Could not get connected to SQL Server 2008

Hi, all gurus,
I installed the SQL Server 2008 on Win2008, on the server side, I could
access the database, but with the management studio, I could not find
any instances, and I could not access the database on the client side
within the same LAN. The client PC runs on Win7.
Any suggestions would be appreciated.

3/24/2010 2:29:08 PM

NNTP Clustering

Hyper-V Active/Active 2 node Cluster

Hi,
We already create an Active/Passive 2 node Hyper-V Cluster, but now, we
need 2 node Active/Active cluster.
Is it possible? How can we do it?
Thanks/Regards,
Daniel Costa

3/23/2010 3:34:48 PM

Clustering

Hyper-V Active/Active 2 node Cluster

Hi,
We already create an Active/Passive 2 node Hyper-V Cluster, but now, we
need 2 node Active/Active cluster.
Is it possible? How can we do it?
Thanks/Regards,
Daniel Costa

3/23/2010 3:34:48 PM

NNTP Connect

how to link a microsoft visualstudio 2005 to the microsoft sqlserver 2005 express edition

hai folks i am new to vb.net and sql plz help me to combine this things k
advance thanks to u
From [link]
Posted via DevelopmentNow.com Groups
[link]

3/23/2010 1:18:48 PM

NNTP Clustering

SQL 2008cluster on the Win 2008 R2

Hi I have trouble with kerberos authetication from IIS server that
connect to the SQL Server . How I enable kerberos authetication in the
SQL cluster ? I have In the cluster 3 SQL instances , how I create SPN
for this ?
thanx marek

3/23/2010 8:51:52 AM

Clustering

SQL 2008cluster on the Win 2008 R2

Hi I have trouble with kerberos authetication from IIS server that
connect to the SQL Server . How I enable kerberos authetication in the
SQL cluster ? I have In the cluster 3 SQL instances , how I create SPN
for this ?
thanx marek

3/23/2010 8:51:52 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

pBlogCategories

sys.books