Yes You are right Varshal ,

I rather thinking where exactly stored procedures are stored , thinking blindly to store into some other filesystems, like how we do for tables and...

ok. then u need to create a dynamic query

here it is ...

I HAVE TRRIED.

SHOULD WORK FOR ANY TABLE:

DECLARE @TABLE_NAME SYSNAME

declare @is_null_columns varchar(8000)

set @is_null_columns =''

SET @TABLE_NAME = 'STORES'

select...

ok, if there is no such crieteria , then i have tried like this

create table table1( tid int ,tname varchar(100)

)

insert into table1 values (1,'veeresh')

insert into table1 values (2,'shreeshail')

insert...

delete from tab_del_nulls

where Int_no is null and

var_marks is null and

int_marks is null ...

n T-SQL You can do it with the following syntax

select * into [new_table_name]from [table_name]

example

select * into mytable from sysobjects

You Store, I Manage

in T-SQL You can do it with the following syntax

select * into from

example

select * into mytable from sysobjects

we have to excecute all at once.   so that all will be in one scope;

declare @str1 varchar(100)

declare @str2  varchar(100)

set @str1 = 'declare @t table( t1 int) '

set @str2 = 'insert...

and this one is much better

SELECT RIGHT(CONVERT(VARCHAR,GETDATE()),7) AS TIME

select CONVERT(VARCHAR(10), getdate(),8) ;

Try this

HI,

YOU CANNOT FIRE A TRIGGER ON PERTICULAR DATE OR ON A PERTICULAR TIME, TRIGGERS ARE FIRED ON INSERT OR UPDATE OR ON DELETED OPERATIONS

AGAINST THE TABLE. WHAT YOU CAN...

"index are defragmented."  --> Fragmented

"rebuild the table, " sorry  .. defragment the index.

If the key column is indexed then create  a procedure  and pass the parameter

check the statistics for that table to check to wether index are defragmented. This happens if...

Thanks a lot Mr. Kenneth,

I am not sending mail in trigger . As you said, I am storing the changed column values into sepearate table. The trigger execution for column...

Why do you want to "Select statement after insert" here? directly add "values and Parameters" pass the variable names. You already got the values into variables.

---

SQL = "insert into demo1(servername, cpu, loadpercentage, pagespersec,...

I don't think you can use functions as defaults, either.

Why , then how come getdate() function working for default value.