what is the serverity and state of the 18456 error, that will then all depend on the action/s to take

if it gives you the information you need then its fine

yeah that will work, but in the case you will want it to be IS NOT NULL as I have just run this on my test machine with NO logshipping...

you will want something like this

select

LP.Primary_Database as LogshippingDB,

'' AS NotLogshippingDB

from

msdb..log_shipping_monitor_primary lp

union

select

'',

sd.Name

FROM

sys.databases SD

LEFT OUTER JOIN

msdb.dbo.log_shipping_monitor_primary lp

ON

sd.name = lp.primary_database

WHERE

lp.primary_database is null

your syntax is wrong for the whole query

you need the 3 part identifyer

msdb.dbo.log_shipping_monitor_primary

when you correct it you will get

Msg 4104, Level 16, State 1, Line 7

The multi-part identifier "dbid.SD"...

put your CV up on the job boards like totaljobs.com/jobsite.co.uk/monster.co.uk/contractjobs.com, you will get plenty of agencies contacting you.

i've just started a new role and i'm still constantly being called by...

as the primary table contains DB's which are logshipping configured you wuold just tie it back to sys databases where its not in the primary table

the script zip attachment has been removed by the OP, i managed to get a copy of it before it was removed

this url will help http://msdn.microsoft.com/en-us/library/ms175106.aspx

the table your looking for is log_shipping_monitor_primary which details all the source db's which are involved in logshipping

the information on that is in the wiki link.

port 445 is the port used for file copy's so that both nodes can copy TRN files

you could use, SSIS, Import Export Data Wizard, BCP.

Quickest would be the wizard but if you want to do fancy things with the data on the copy then SSIS

believe I have resolved it

i created a deadlock and it didnt fire the alert

and i was still trying to fire the same deadlock alert, but I had to create a...

you have to allow the other servers internet connectivity

we have DEV/TEST servers here in the UK locally and PROD servers in the US managed by a 3rd party.

I'm a fan...

we connect to a 3rd party ftp site, download a zip file using a http connection manager

we then have a C# script which checks the unzipping directory and clears it...

you could create an ssis package and give it a script task which will execute VB.net or C# code and then schedule the package as a job