Tried this using SSMS - SQL Server 2005 SP2

When clicking execute - a message is displayed sating that

The query cannot be represented in the Diagram and Criteria Pane.

.

However you...

Syntax: bcp master..syslogins out -U -P -S -c

Example: bcp master..syslogins out C:\logins.txt -Usa -P -SServername -c

On the target server, BCP...

10,1 is severity and state parameters of raiseerror.

http://msdn.microsoft.com/en-us/library/ms178592.aspx

Manu

Peer to peer replication is sql 2005 feature.

Peer-to-peer replication is available only in SQL Server 2005 Enterprise Edition.

http://technet.microsoft.com/en-us/library/ms151196(SQL.90).aspx

MJ

http://www.sqlmag.com/Articles/ArticleID/44064/44064.html?Ad=1

Listing 1: Safety Trigger That Rejects Attempts to Drop or Alter Tables

CREATE TRIGGER trg_protect_sensitivetables ON DATABASE FOR DROP_TABLE

AS

RAISERROR('This database contains sensitive tables.

A trigger protects the tables from being dropped.

If you...

Please post any error message logged in event viewer/sql server error logs.

Post the full error message that you get when you try to connect.

MJ

Nope it doesn't.

MJ

Try creating e new job with following as its first step

if (DATEPART(dd, GETDATE()))=1 and (DATEPART(weekday, GETDATE()))>2

begin

Exec msdb..sp_start_job 'Call the job you need to execute here'

end

HTH!

MJ

create table #temp

(

dbname varchar(16),

username varchar(30)

)

insert into #temp

exec sp_MSforeachdb 'Select ''?'' as DB_Name, su.name from ?.dbo.sysusers su

join master.dbo.syslogins sl on sl.sid=su.sid

and sl.name=''Enter Login Name Here'''

select * from #temp

MJ

This is from another forum. I used this many times in the past to capture last executed time of stored procedures. It uses the syscacheobjects table.

---------------------------------------

Ok, we came up with...

Why don't make use of script specified at http://www.codecomments.com/WSH/message462337.html to read event viewer logs and check for the cluster node failover event and shooting out a mail to dba group.

HTH!

MJ

Why don't you make use of batch files and osql utility.

MJ

It is important to note that the checks and workarounds described are all targeted at the owner_sid and owner columns in sysdtspackages. The owner is also held in the CreatorName...

Excellent Alex.

Many thanks for sharing the same!!!!

MJ

Try:

select * from sysobjects

where replinfo0

MJ