Along with SQL 2008 instance i need to have SQL 2005 instance too.

If i doing upgrade from 2005 to 2008 whether i can have sql 2005 instance.

Not only master DB i want to restore all system DBs

I want to retain following informations such as

1.SQL Server logins and the passwords which needs to be transferred

2.SQL Server...

Paul

I have found the solution

thanks for ur comments.

I hope u do know family relationship.

Hi

  Thanks for the help, i changed few settings in sp_addlinkedserver now its working fine.

I tried sp_addlinkedserver ,still unable to find the solution, what information u need from my side let me know

Can you help me how to create linked server

i connected as a dbo

using default schema (dbo)

Msg 443, Level 16, State 15, Procedure sample, Line 9

Invalid use of side-effecting or time-dependent operator in 'INSERT' within a function.