Please note that to view the SQL Server audit log generated by the Security Audit you will need CONTROL SERVER permission ( or at least SA ).

It was problematic for...

HI Mate,

No, I never found a solution to the problem I was experiencing, I do need to look into it again.

I was starting to think I...

Hi,

I was wondering, where exactly do you see that the results are returning randomly?

From experience, I have seen MS SQL Query Analyzer ( I prefer it over Mngt Studio to...

Hi Sergiy,

Thanks very much for your solution.

It's perfect. What a clever way to do it. So very glad I didn't need to use a cursor

Hi,

If I understand the question correctly, I would use two queries and UNION the results. The first column you could use a text field as an identifier to show which...

Hi,

The SP only returns one result set, however there are a few statements setting up the parameters for the query ( the do contain select statements, and the parameters are...

Hi,

The first step in the package checks that the file exists using Visual Basic:

Dim FileInfo As FileInfo

...

wow, that worked.

I had no idea you could use Alias's in the UPDATE clause.

Thanks!

Measure twice, cut once.

Yes, that works and thanks for your time.

Solution for me is:

ceiling( ( <my result>) / 0.05 ) * 0.05

eg:

ceiling( (fieldname * 0.75) / 0.05...

Hello,

Thanks for your reply.

However, it produces incorrect results for what I am after:

Original75%Desired (1+CONVERT(INT,< my field name > * 0.75 / 0.05))*0.05

...

HI Jeff,

As it happens, there is a cross join; eg For each of my hospitals I join a date period table which would result in ( for a year)...

Hi,

Well the result of the DBCC command is:

No active open transactions.

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

however at the time the stored procedure was...

Hello,

I think my problem lies in the fact that the AutoShrink operation is currently executing on the database I want to restore into.

I guess I am just going to have...

I changed the auto-shrink option off.

Still won't work.

I have actually restored this database today already, and it worked fine.