how can we write a query and pass multi value parameters to stored procedure in the report? To exec a procedure we simply write

Exec MyStoredProcedure

to exec a stored procedure...

Benediktas:

As such I dont have enough knowledge but I must tell you that in my case,I found Sql Server Agent as stopped.So I started it and my maintenence plan started...

I see.

Thanks alot Kenneth and SQLBill

Jaishree

Thanks USKiwi,

Pt no. 3 was wht i was loooking for,thanks.

Urs efforts are grtly appreciated,

Thanks once again,

Jaishree

Hey pls help

I guess my all fundas are gull(gool)...........

NEWbie says

"will update existing all values in “mycomments” to NULL"

What i mean to say tht why in first place all...

Thanks Everybody,

I will just try wht best suits with my case n wud let u know.

Thanks again everybody.

Jaishree

Hi Everyone,

Does ne one know whether its possible to migrate data and objects from sql server 6 installed on one m/c to sql server 2000 on another m/c in one step.(Not thru...

Thanks Amit

But sql server 2000 is installed on another m/c and sql server 6.5 is on my m/c.

I am not doing upgration on my m/c but migration of data from...

hey , even i am facing the same problem but with server 7.This query "select * from sysprocesses where waittime > 0 order by waittime desc" gave me this result...

hey , even i am facing the same problem but with server 7.This query "select * from sysprocesses where waittime > 0 order by waittime desc" gave me this result...