SELECT a.agentid,c.restid,c.plancode

from #a1 a, #c1 c

where c.restid not in (select restid from #b1)

if you check the system log(in event viewer), you will see the source as 'service control manager' and you will see the details there.

other alternate is use linked server.

edit:-

follow this linke on how to configure

http://support.microsoft.com/kb/306397

Thanks a lot Stew

Actually I cant read my signature while posting the...

Thanks it worked. Though was giving error 'Incorrect syntax near ','.'

but sorted it by removing the breacket in

group by (.......,.....,...).

Thanks again for help.

Can we use the same method...

you can create as many linked server as u want with same destination server but your linked...

if you create the account in model and give required permission, then i think whenever then new database created, it will inherit the defaults from model.

have you found the solution of the problem as I am interested to know the investigation done and suggested.

the steps which is creating the new db, you can mention additional steps to grant required permission to the account which is running package.

I have posted some steps here

http://www.sqlservercentral.com/Forums/Topic993548-338-1.aspx#bm993618

could be useful for you

do one thing,

run the profiler and make it specific to that database and then from front end try to login and on back end your profiler will capture the...

but if you able to see the database then can you try to do--- select top 100 from a perticular table using gui(SSMS).

Also if the application was running till yesterday...

is it case sensitive server/database?

if the database like sharepoint database then put them in [ ] code.

Other option, if you able to see the database, right click on table and...

Thansk for your feedback.

found one good article from MS website :-

http://www.microsoft.com/downloads/en/confirmation.aspx?FamilyID=66d3e6f5-6902-4fdd-af75-9975aea5bea7

having 490 pages but extracted the information relevant to my upgrade.

Can someone please review my steps :-

1.1.1.1Backup/Restore Upgrade Method

Take the following...