What status should i check of SA at linked server. Please let me know Thanks..

thanx pradeep,

both mdf files having same primary filegroup

nitin

thanx for yr reply byt could u pls tell me what is procedure to chg the transaction lvl

no dear i m not using any recordset object i just wann to do this directly thru SQL server/enterprise manager or QA

i m going to update some risky data so in that case i just want to confirm first that how many data r going to update, i can use the...

hi lucky

thanx for ur reply

the user have the rights to access that network drive, it can easily copy any file in that netword drive. are u saying about the...

Thanx to u all

i really did not want to use like

thanx again

hi david,

thanx for ur solution,

i solved it through this procedure

CREATE Procedure select_Proc1

@Key3 varchar(10) ='%'

As

BEGIN

Select key3

From Or_Table

Where

(key3 like @key3)

END

GO

thanx again

Can we do this thing without Top command?

can u pls explain this solution

thanx

thanx sir but i have this problem-

"I plan to use an MSDE (or Sql Server Express) database in my single-user

application. My problem is that the mdf file will be...

I plan to use an MSDE (or Sql Server Express) database in my single-user

application. My problem is that the mdf file will be accessible (at least

readonly) to anyone...