You can do it with peer to peer transactional replication by setting vertical partition variable and using sp_articlecolumn.

Peer-to-Peer Replication

it depends...

SSC Stairways-Transactional Replication[/url]

So is this proxy user also a db_owner?...

use [master]

GO

DENY EXECUTE ON [sys].[xp_cmdshell] TO [CmdShellUser]

GO

EXECUTE AS LOGIN = 'CmdShellUser'

EXEC xp_cmdshell 'DIR C:\*.*'

In your profiler setup event Broker:Transmission

It will show the error message when transport error occurs in the transport layer.

You will have to manually uninstall sql server

refer to this kb

http://support.microsoft.com/kb/955404

And then install a fresh copy

Human error happens all the time.

I personally love this QotD part of SQLServerCentral it gives me something to think about every morning.

sqldba_icon (4/7/2011)

---

AlexSQLForums (4/7/2011)

---

i)Under EventClass i see "Existing Connection" and ApplicationName as ".Net SqlClient Data Provider" with two entries which have different ClientProcessID from same server's . However the...

i)Under EventClass i see "Existing Connection" and ApplicationName as ".Net SqlClient Data Provider" with two entries which have different ClientProcessID from same server's . However the Set options...

Grant

How much is your "min memory per query"? If it's at 1024 double it see what happens.

Do you have CLR enabled across all 4 instances?

Can you run this query to check which query is taking up the most ram in cache

SELECT TOP(10) * FROM sys.dm_Exec_cached_plans

CROSS APPLY...

How much RAM does the box have and how much is allocated to SQL Server?

If you don't set max ram in SQL Server (64bit) it will use almost all of...

this is a command line tool and you must be the admin on the target machine.

AccessChk

You will have to stop the cluster and create a cluster resource called SQL...

You can run this in Oracle:

select sum(bytes)/1024/1024 as "Used Space (Mb)" from dba_segments where owner='your_schema_owner';

You can never be sure so double your storage.