I have managed to get part way to a solution using the following query, The only issues are, if more than one Stored Proc/Query is used by the report only...

I was thinking of using profiler, this problem is that some of the reports access databases on separate servers and there are a number of reports that are run very...

I have cracked it!

Solution was;

create a new database [db name_2] (with new data and log files)

shutdown sql server

swap the mdf file (db name_2.mdf) for (db name.mdf)

bring up the server...

Hi,

yes it looks as though the appl is not clsoing conenctions once it completes it routine. The number of connections created is around 25, with potentially up to 30...

Not sure if this process could ever by 100% accurate, there will always be some clever dick who sticks random characters and numbers into a house name for example, there...

Many thanks for the advice

OK, firstly, it's not that big an issue for me, I just though it was interesting.

Anyhoo, to illustrate the issue let us create 3 SQL logins as follows

EXEC sp_addlogin 'xxx'...

 I would reiterate that the logins are solely SQL logins, there is no corresponding Windows login that would allow the user to access the server/database.

The situation came to light...

I can confrim that the logins in question are SQL logins.

As you will be aware, using EM to create a login with a blank password adds a null to the...

Hello

I use the following SP (I think taken from SQL server central and altered) and SQL job to monitor disk space and issue an e mail alert when any of...

That was my initial thought also, but the spelling is fine.

I have just found the cause of my problem, I was being a silly arse.  The maximum number of characters per row being returned by QA was insufficient to display...

Thanks for all the advice, it looks as though the OS was up'd to SP4, but SQL has remained at SP3/3A.  I am getting anecdotal reports that the previous DBA...

Many thanks, any thoughts on which one to rely on and/or how to get them back into sync?

Thanks for the advice, all sorted now.