If all rows are identical, how doest it matter which one you delete ?

For deleting one row. you could use,

SET ROWCOUNT 1

DELETE ForTest where No = 1

SET...

I didn't knew about this feature. Where can I find more information on this new help system?

Put A SET XACT_ABORT OFF  and then test your procedure.

you can not use the MOVE options with diff. backup restore.

try by removing MOVE files options from diff. restore command.

see

http://www.sqlservercentral.com/products/bwunder/archiveutility/

see

http://www.sqlservercentral.com/products/bwunder/archiveutility/

Tim Januario ,

I am trying to answer a quesion "Without using temp tables or cursors, how do I select 10 records for...

does this help ?  Assumed that for a userid , there will be distinct values for textdata.

create table  testdata

( userid int , textdata varchar(10) )

go

insert testdata

select id...

I had a simmilar issue over linked server. Although it was  Oracle as Linked Server, but the problem were simmilar. 

A query of this format

SELECT COL1, COL2, COL3 FROM SERVERA..OWNER.TABLE

WHERE COL1...

Try this from a command line

net stop sqlserveragent

net stop mssqlserver 

if you are on SQL 2000, use CHECKSUM_AGG function.

see BOL for sample on how to use this function.

Can you put up some sample data and expected output? As per my testing data, I am able to get the desried results.

Does this work ?

SELECT A.Membernbr ,

CASE WHEN A.Service <> B.Service AND A.SubService <> B.SubService THEN 'DOUBLE CHANGE'

     WHEN A.Service <> B.Service THEN 'Service CHANGE'

     WHEN...

This seems to be a bug in Query Analyzer.

if you write from a command line

isqlw -U sa -P sa_pwd -S . -d master

it will work...

and

isql -U...

Object_id , db_name and object_name are functions that work in current database only.

that's the reason why your inner query SELECT OBJECT_ID(NAME) FROM [Northwind].[dbo].[sysobjects] WHERE type = 'U' will mostly return...