Dear All,

I have a question with regards to that please.

Ex: Index Idx1 on col1 with include on col2 and col3

The question is if i run and update statment as follows

Update...

Thanks Gail for your reply i appreciate it.

Nader

As a test i changed the alert to datafile size above a certain number and the alert was fired and i got a mail for it, still can't get the...

i did that and still nothing happening and i checked history for alert, i even change value to 0.1 to be sure and restarted sql agent and run slow sqls...

Thanks for your reply.

It went above 70 %

Thanks for your help.

i will try that.

Hi There,

I use the following sql in SQL2008

SELECT

(cast(CAST (A.cntr_value1 AS NUMERIC) / CAST (B.cntr_value2 AS NUMERIC) as decimal(18,3)))*100

FROM

(

SELECT cntr_value AS cntr_value1

FROM sys.dm_os_performance_counters

WHERE object_name = 'SQLServer:Resource Pool Stats'

and counter_name...

Very nice feature, thanks for explaining it.

But what if someone change data through SQL Management studio, how can i track that?.

Thanks

Thanks very much for your reply.

I am using SQL 2008 , using your technique i must first read the xml file, should i do that using the sp_xml_preparedocument stored procedure...

Thanks Jeff,

That's exactly what i will start working on in the next period.

Hi Gail,

What you said is exactly what i need to do, i need to write just a single block of code and reuse it for all tables.

According to our previous...

Thanks Gail,

I appreciate your reply.

But that means i have to rewrite the trigger code again 🙁 and so far i don't have other ideas on how to rewrite it.

Thanks

Nader

Thanks alot for your support , it was very helpfull.

Regards

Nader

Thank you all guys, appreciate your help.

Regards

Nader

can u pls tell me whats wrong in this syntax, i am trying to use table valued functions instead

Thanks

Create function [GetTableData] (@TableName varchar(50),@RowID integer)

returns table

AS

Declare @MySQL varchar(100);

Set @Mysql= 'select...