CrazyMan!!!!!!!!!!!

Good capture...............

give the restore database name....

explore the folder where backup file is placed.

then in last text box manually type the name of backup file

including filename + .bak .

It works

give the restore database name....

explore the folder where backup file is placed.

then in last text box manually type the name of backup file

Check the property of your backup file....it is saved with .bak extension then there should not be problem.

when restore give your DB name...........thats all

Thanks,

kruti, Peter Brinkhaus

your both's reply works and i get solution thanks............

ok.

But I do not need row count i need count(name).

eg.

count(name) name surname

--------------------------------

1 ...

Ok. Thanks

create table #ORStable (doclen bigint, doc varbinary(max))

insert into #ORStable

select len(bulkcolumn), * from openrowset(bulk 'C:\TABLEINFO.TXT', SINGLE_BLOB)

as r

select * from #ORStable

select CAST(doc as nvarchar(MAX)) from #ORStable

or search for openrowset

--USE THIS ONE

BEGIN TRANSACTION

SELECT * FROM UserStats WHERE UserID = @user-id

IF NOT EXISTS (SELECT * FROM UserStats WHERE UserID = @user-id)

BEGIN

INSERT INTO UserStats (UserID) VALUES (@UserID)

END

COMMIT...