What does this say when run against the Publisher, the Distributor and the Subscriber:

SELECT SERVERPROPERTY('Edition') AS Edition,

SERVERPROPERTY('ProductVersion') AS ProductVersion,

...

Post the complete result of this:

USE [YourDatabase];

DBCC CHECKDB WITH NO_INFOMSGS;

tz.bahrami (12/27/2012)

---

Thanks alot.

How about polymorphism in sql? Could we use stored procedures for polymorphism?

And for nested relationships can we define an attribute as OId and use it in a select...

In order to change the owner of a database you must have exclusive access to it. Restarting the SQL Server service will not help if the application immediately reconnects to...

MG-148046 (12/27/2012)

---

You could use the stucture available in SQLPS. Set your location to SQLSERVER:\SQLRegistration\Database Engine Server Group\<your group name> then set a variable equal to get-childitem and do a foreach...

More...

Progress. From the remote server what do you get when you run these:

EXEC('SELECT ORIGINAL_LOGIN() as logged_in_login;') AT [ServerName];

EXEC('SELECT * FROM msdb.dbo.sysjobs WHERE name = ''8A427655-9A6E-43F0-9A28-95C7A8F781B1'';') AT [ServerName];

Did the first one...

Here is some available reading on the topic that may help you gain a deeper understanding of what things to consider before implementing your database:

Object-relational impedance mismatch, From Wikipedia

S_Kumar_S (12/26/2012)

---

Hi All

I have a table with identity column as PK.It is accessed by millions of users at a given time. Now there are 2 columns for which if there...

patch

TheSQLGuru (12/25/2012)

---

opc.three (12/24/2012)

---

It should say "physical cores" instead of "physical processors." I would set it to 6 for the number of physical cores per NUMA node. If you're still seeing...

Mac1986 (12/24/2012)

---

I ran the below script and got the Network related error respectively. I wonder why it takes 2 mins to runt his small script.

EXECUTE AS LOGIN = 'Redmond\MyServiceAccount'

GO

SELECT SUSER_SNAME()

GO

EXEC...

Chances are the path "%systemroot%\System32\WindowsPowerShell\v1.0\" was removed from the PATH system environment variable. Removing the path to powershell.exe from the PATH variable made it impossible for you to refer to...

Have you heard of Central Management Server (CMS)? It supports the "interact with each server in a server group from PowerShell" functionality that I think you are after.

If setting up...

It should say "physical cores" instead of "physical processors." I would set it to 6 for the number of physical cores per NUMA node. If you're still seeing too much...