missed one thing..

modify FETCH...

Just modified the cursor example from BOL

=========================================

Declare @LN varchar(255) -- variable to store Last Name

Declare @FN varchar(255) -- variable to store First Name

DECLARE Employee_Cursor CURSOR FOR

SELECT LastName, FirstName FROM Northwind.dbo.Employees...

You can also use cursors or Loop within the first SP and calling the 2nd SP for each rowset from within the cursor/loop.

Same question reported twice!

http://www.sqlservercentral.com/Forums/Topic619170-169-1.aspx

If both databases have different users. db A contains users user1, user2, user3 and db B contains users user1, user2, user4 and you want to add user4 to db A...

Read this article on synchronizing logins http://www.sqlmag.com/Article/ArticleID/25710/Synchronizing_Logins.html

If comparision is necessary, you can opt for the tools as suggested in earlier replies which would also help you with information on schema changes.

*If* you're concerned only about record...

Thanks for your replies Adi and Perry.

Though i consider attaching a database the simplest option to put the database back in action, i gave that option as an alternative.

Few google...

refer to the following URLs on using query plans.

http://msdn.microsoft.com/en-us/library/ms179880(SQL.90).aspx

http://msdn.microsoft.com/en-us/library/ms187032(SQL.90).aspx

download.microsoft.com/download/4/7/a/47a548b9-249e-484c-abd7-29f31282b04d/Forcing_Query_Plans.doc

Seems he forgot to come back to see the responses!!

His visits count still is 1.

http://www.sqlservercentral.com/articles/Administration/introtodatabasemailinsql2005/2197/

Unfortunately msdn and BOL doesnt have much say on this than

The Table Spool physical operator scans the input and places a copy of each row in a hidden spool table...

well i too presumed the format was mmddyyyy..

he can still twick the query even ih he doesnt know the server's date format by executing either set dateformat 'dmy' OR set...

the datetime data type stores both date and time.

so the result of

will output all dates less than on equal to 2008-12-12 00:00:00.000

if the record has a RegisteredDate...

I think the script written by Garadin should help you on the Inner Join that is required her.

SELECT *

From Database1.dbo.Customer C

INNER JOIN Databaes2.dbo.Ship S ON...