try this

EXEC [SERVERNAME].[DBNAME].dbo.sp_Help 'ViewName'

you can achieve it through many ways like.

Execution Context

Cross DB Ownership Chaining

Create same user in both databases.

but keeping security and the associated risks with...

there are many ways to handle this..

1. take regular log backups.

2. log shipping.

3. mirroring

hope this helps.

try this

Select distinct IDID, Data= REPLACE((Select distinct t1.data as [data()]

From #Unpivot t1 Where t1.idid = t2.idid Order by t1.data FOR XML PATH ('') ), ' ', ',')

if you restore SQL 2005 on SQL 2008 you will not be able to make use of some of DMV's unless you change compatibility level to 100 and also ...

if you want to archive data by horizontally partitioning the table then you have to go for table partition, but for table partition you need to have good candidate key...

we normally archive data either through table partition or we make use of filtered index.

as Steve rightly mentioned latest Service pack for SQL Server 2008 R2 is SP2

Hi,

Below are the steps i normally follow..

1. I check is there any blocks through sp_who2 (check BlkBy column)

2. if there any blocks, check both SP ID (SPID & BlkBy SP...

Hi,

I think the better solution would be to have log shipping enabled on both Proc1 & Web1 to site B and then enable replication only if you want to put...

Hi,

you can upgrade yourself to MS SQL 2008 or MS SQL 2012, MS has changed Certification pattern in SQL 2012.

go through for more info.

Hi,

I think we can achieve the same without rank function.

SELECT * FROM GetMissingItems WHERE RowNumber = 1