easiest (and cheapest) approach might be to just put a sql agent job together to query the database, save the data and email yourself the results?

Thanks Ken - the definitions should never change (haha.. in a perfect world without them darn users) - but making sure its backed up after each change should be enough.....

i completely agree that you'd have bigger issues..

my philosophy on it though is that if it doesn't need to be there, why have it there? Why even give someone...

sa as a honeypot is an interesting idea - but i'd hate to be the dba that set a complex password which was then hacked over the w/end, either by...

Less chance someone will try and access your system with some different named account rather than sa.

If you have the user sa active, then if I got access to your...

sa account itself should be disabled, if you need mixed mode, fine, create an sa like user, but not 'sa'.. where possible use windows authentication for connecting, and set up...

perhaps you could reload the entire report via navigation but passing a parameter to your master report which would be passed on down to your subreport.. make sense?

tough to explain...

you mean you want to pass the value from the textbox as a parameter for a drilldown report? or an actual subreport shown on the page already?

best of luck - if you need help, be sure to post and i'm certain someone can help with the syntax etc.

have you considered using bcp to insert your data with a format file?

now i'm actually at my desk and reading through the sql, chris is absolutely correct - this sql aint gonna work (which you obviously know).

I'd recommend rewriting it to be...

I have a set of scripts I use as a base and modify as needed - the only real compelling reason is so I can modify them where necessary. ...

you say you got the answer, but now you're trying to tune it further and not getting it?

are you not getting your correct result, or are you not getting it...

its unfortunate that you can't change the table structure to be accurate, why do you need to change them?

however..

CREATE VIEW vDSA AS

SELECT

CAST([CP Code] AS CHAR(5)) AS [CP Code],

CAST([Time] AS...

There are a multitude of ways to write t-sql well - classroom learning, book learning but mostly practice in my opinion.

What I don't particularly like is when people make sweeping...