Marios Philippopoulos

Forum Replies Created

Viewing 15 posts - 766 through 780 (of 1,518 total)

RE: Error when running "get-wmiobject"

Jeffrey Williams (1/8/2009)
Can you try the following and see what happens?
$computer = 'name of computer';
Get-WmiObject -ComputerName $computer Win32_Service | Where-Object {$_.Name -like 'MSSQL$*'} | Select Name, StartMode, State, Status;
That ran...

January 8, 2009 at 9:59 am

#923483
RE: Is using triggers the only way of auditing updates of table rows?

TheSQLGuru (1/8/2009)
It is my belief that even if you rewrite the trigger to only do the audit update on rows where something is different between inserted and deleted the trigger...

January 8, 2009 at 9:18 am

#923441
RE: Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts

jesse.roberts (1/8/2009)
Great thank you so much Marios. This would be a big help I've been trying to modify it myself but am a novice with sql.
Jesse
No problem.
The SQL part of...

January 8, 2009 at 9:06 am

#923420
RE: Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts

jesse.roberts (1/8/2009)
Hey Marios
Thanks for the reply. I can get operations manager to supress the alert creation using alert suppression. When creating an alert generating rule against an NT event log...

January 8, 2009 at 8:57 am

#923406
RE: Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts

jesse.roberts (1/7/2009)
Hey Marios
I've been looking for something like this for a while. We don't really want to store the data for future analysis on a seperate db. Is there anyway...

January 8, 2009 at 3:33 am

#923169
RE: SQL Server Profiler: Help needed monitoring one specific store procedure

sweetpea_3007 (1/7/2009)
hai all..
i want to know, how to make sql profiler running daily?
thanks
You just need to script out your profiler session with all your chosen events, columns, filters and other...

January 8, 2009 at 3:13 am

#923166
RE: Error when running "get-wmiobject"

Jeffrey Williams (1/7/2009)
The only thing I can suggest is remote into that system and verify that you can access WMI. I have seen things like this when WMI was...

January 7, 2009 at 6:42 pm

#923027
RE: Is using triggers the only way of auditing updates of table rows?

noeld (1/6/2009)
Don't forget to post back with the results ... 😉
Will do.

January 7, 2009 at 4:04 am

#922406
RE: Is using triggers the only way of auditing updates of table rows?

matt stockham (1/6/2009)
Having seen your post that lead to this one, is your real problem with the performance or in the space taken in tempdb? If it is just...

January 6, 2009 at 3:41 pm

#922236
RE: Is using triggers the only way of auditing updates of table rows?

GSquared (1/6/2009)
To clarify, the decision as to whether to include it in a trigger or not is based on coding needs, not on performance.
If the table will ever be updated...

January 6, 2009 at 2:52 pm

#922206
RE: Is using triggers the only way of auditing updates of table rows?

GSquared (1/6/2009)
Just had another thought. You could accomplish much the same thing as the complex join statement by using an Except query between inserted and deleted and then joining...

January 6, 2009 at 2:38 pm

#922190
RE: Is using triggers the only way of auditing updates of table rows?

GSquared (1/6/2009)[hr
This is a trigger-only structure, since it uses the inserted and deleted columns in the Where clause, so that's not the issue here.
Mea culpa, I don't know what...

January 6, 2009 at 2:36 pm

#922185
RE: Is using triggers the only way of auditing updates of table rows?

noeld (1/6/2009)
By the way if the columns are "nullable" you need three way comparison like:
(
i.col1 <> d.col1
or (i.col1 is null and d.col1 is not null)
or (i.col1 is not null and...

January 6, 2009 at 2:21 pm

#922170
RE: Is using triggers the only way of auditing updates of table rows?

GSquared (1/6/2009)
On the point of making sure the inserted and deleted tables are different, a trigger can look like this:
update MyTable
set LastUpdate = getdate(), LastUpdateBy = user
from dbo.MyTable
inner join...

January 6, 2009 at 2:11 pm

#922165
RE: Is using triggers the only way of auditing updates of table rows?

GSquared (1/6/2009)
On the point of halving the row versions:
Let's say you have a table with people's names in it, and LastUpdate (datetime) and LastUpdateBy (varchar) columns.
So, you issue a command...

January 6, 2009 at 1:39 pm

#922138

Viewing 15 posts - 766 through 780 (of 1,518 total)