Select serverproperty('computernamephysicalnetbios') as [currentnodename]

SELECT * FROM fn_virtualservernodes() –Gives the nodes list

Select * from sys.dm_os_cluster_nodes

Select * from fn_servershareddrives()

Select * from sys.dm_io_cluster_shared_drives

you can't setup transactional replication for tables without primary keys. How did it work?

Coming to the comparision, you just want to check the row count or the data also?...

Can you check on the security settings set for linked server and provide the answer here? We recently faced the same issue when we changed the security option from use...

no one experienced this issue?

I tested it. It has to be physical server name.

we are using-

OS- windows server 2008R2 SP1

Sql server 2008 SP3

Both servers are in domain.

I am trying to connect using my windows credentials. I can communicate from both the servers using sql server account.

Both servers are using same service account...

we are facing the same issue. Let us know the solution if you fixed it.

do we have any already built in tools which will help me to achieve this? I tried to use Dezign which works better to some extent. Any suggestions?

I am planning to work on a dashboard kind of tool , such like when we click on a table it should display all the tables dependent on it and...

The problem is we have too many tables which are inter related. If...

I am working on a project to help developers to know the relationship between the tables. Let us assume pk in table A is foreign key constrain in table B,C...

It's size of indexes 1 TB

First error: someone deleted the row at the subscriber and then deleted the row on the publisher. so it's throwing that error. try to insert that row in the subscriber...

Thanks George. Is there any way we can introduce stripe backups in log shipping.