Thanks both of you for the replies.

This should do exactly what is needed. For some reason, the output has to be a negative number so I took what is generated...

yes and I get a completely different number.

/*------------------------

select CONVERT(bigint,0x80074e21)

------------------------*/

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

2147962401

(1 row(s) affected)

/*------------------------

select distinct CONVERT(bigint,cast([status] as varbinary)) as converted, [status]

FROM [FWS_000].[dbo].[FWLog]

where status = '0x80074e21'

------------------------*/

converted ...

Thanks for replying.

I am not trying to convert that hex to varchar. I am trying to convert that hex to bigint using a field that stores the...

Thanks Michael. I thought about that but could not get it to work. Since the whole thing has to be inside single quotes, it was not quite working.

Now that...

These restores are an audit requirement. Log shipping won't help there.

Thanks Michael and others.

Michael, I was able to make your script work in 2008 by adding some additional fields to the temp tables.

I would like to execute the restore...

Thanks for responding. I can't mirror the setup because there are multiple servers that these backups are coming from, built by different people, at different times. The test...

The problem was that the registration of a Central Management Server is user specific. I had logged into SSMS and registered the CMS under my account and therefor it was...

Thanks Grant. I'll double check.

I don't know how to check that the account has access to the directory as it is PowerShell turning the database into a...

Hi everyone. I found that if I make my variables like this:

$ServerResult = Invoke-Sqlcmd -query "Select @@SERVERNAME" -ServerInstance $instanceName.Name | Out-String

$VersionResult = Invoke-Sqlcmd -query "Select @@Version" -ServerInstance $instanceName.Name |...

This blog article shows how to script multi server queries through PowerShell that can be scheduled as a SQL Agent job. Unfortunately, outputing to the PowerShell window is not useful...

Hi shew and others.

Did you find a way to schedule multi-server queries using PowerShell? I would like to do this too and have been looking at a way to...

It looks like it is not possible using the file system task. I'm going to make a step that does it through command line.

Thanks I saw that option but really wanted a way to have certain words pop out when pasting a long script into the query window.

Hope everyone had a nice weekend.

If I may, how can I handle lines that do not have '<username>' in them? The query has been modified to find failed logins and...