hi

check recursive triggers  database propertity is on .

if it is ON turn off .

You can see this in database properity option tab

You can use sp_dboption to alter this...

HI

Exec (@SQL2)  is correct .it is not like this Exec @SQL2

Regards

padmakumar

hi

Version u can get from @@version

I think  8.00.2039  for Sp4  

Regards

hi

it is Divide by zero error  .

regards

padmakumar

Hi

Table Syscolumns store all columns and information about it . it store parm info of proc  .  if you are looking to query name from all table in a...

hi

If your looking for View/proc  or Table  Definition/text then 

For Table it is      sp_help

for text of View/Proc...

hi

Select

CONVERT(varchar(12), isnull(n.TestDateTime,''),103)  from Table

Regards

padmakumar

Hi

To return all start with AB12

 u can use like 'AB12%' or if u need only with space then like 'AB12 %'

Hi

TRUNCATE TABLE  will reset  identity seed  . But delete will preserve the  identity seed  . if it is a small table you can  Use delete . Else Procedure option  you...

Hi 

u can use this statement to know about identity column in a DB .

 Select * from syscolumns  where status= 0x80 

Padmakumar

In this case u can use outparm of sp_executesql .

For more than one result  a cursor can be used as output param

I think this may solve u r problem

DECLARE @SQLCURSORSTRING  nvarchar(500)

DECLARE...

i think u can recover database using

this procedure

first use "sp_resetstatus<DbName>" system proc to resetstatus

after that use dbcc dbrecover<Dbname>

than restart u r server .

if u have too many params and u want to bulid a sql statment according to the data in it u can try sp_sqlexcute or exec()

by using this...

Table Inserted and Deleted are only available

with trigger. IF u want to get info of user add recored u can add a column like username and put default (SUSER_SNAME) for...

rs_save_shipping_history.MoveNext

Loop

This means u r using a loop .

In first loop u created and appended two

Parameters @work_ord_num char(9) and

@work_ord_line_num char(3)

and in Subsequent loops u r...