SET NOCOUNT ON

-- declare all variables

DECLARE @sTableName SYSNAME

DECLARE @sSQL sql_variant

DECLARE @sSQL1 Varchar(220)

DECLARE @iRowCount INT

DECLARE @t_TableNames_Temp TABLE

(table_name SYSNAME)

INSERT @t_TableNames_Temp

SELECT name

FROM master..sysdatabases where name not in('northwind','pubs')

ORDER...

Are there any text/image columns in this table?

MJ

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...