Viewing 10 posts - 31 through 40 (of 40 total)
I would suggest reading up on preventing "SQL injection" as your first step:
http://www.sqlservercentral.com/articles/Security/updatedsqlinjection/2065/
If you must pass multiple values in one variable, you'll need to parse out the values...
September 23, 2008 at 9:14 am
You can query several tables, such as log_shipping_monitor_primary and log_shipping_monitor_secondary. However, these likely will just reflect what the scripts from Microsoft are telling you.
It seems like your monitoring server is...
September 19, 2008 at 7:33 am
Thanks. Good info. Have you actually tried it? Not trying to be a smart guy about this... I've heard that the auditing features of 2k8 are world...
September 19, 2008 at 7:21 am
Jeff Moden (9/18/2008)
Ummm... that'll find the last date a table was SELECTED from?
Yes, provided the new 2008 database audit events are set up:
2008 BOL says: "SQL Server audits...
September 18, 2008 at 2:38 pm
Unless there are issues, such as with diskspace or customizations needed, I'd leave the tables alone. There are far more important things to concern about 🙂
But if you really need...
September 18, 2008 at 11:29 am
I've installed Oracle and SQL Server in a development environment a few years ago, with no issues. I've recently installed the Oracle 10G "express", SQL Server 2000 MSDE, SQL...
September 18, 2008 at 11:08 am
Thanks for the dump file. I was actually wanting to see the SQL log file that contains the lines for spid213. If you look there, that might give you...
September 18, 2008 at 4:59 am
Thanks. Could you send the lines above and below this line:
[font="Courier New"]EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process[/font]
For what it's worth, updating your Service Pack might prevent...
September 17, 2008 at 8:48 pm
I'm not aware of any instant way to get this list. But I would get started with this:
[font="Courier New"] use mydatabase
select * from information_schema.views[/font]
The TABLE_NAME...
September 17, 2008 at 8:06 pm
The lines in your log just above what you posted might give a clue. Can you post the prior 10 or so lines, and also show the timestamps? ...
September 17, 2008 at 7:50 pm
Viewing 10 posts - 31 through 40 (of 40 total)