Backups taken with the copy_only command are not visible in an SSMS gui restore. I ran into this same issue recently. Is that what you're running into?

http://sqlblog.com/blogs/tibor_karaszi/archive/2007/09/15/copy-only-backups-and-ssms.aspx

You're almost there, you just have to keep joining to the same table.

Something like this should work:

SELECT

Employees.Name,

Activities1.Activity AS Slot1,

Activities2.Activity AS Slot2,

Activities3.Activity AS Slot3,

Activities4.Activity AS...

Jonathan Kehayias recently wrote about this, it includes a cool script to map temp tables to spids:

http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/09/29/what-session-created-that-object-in-tempdb.aspx

It's a long read, but this looks to be exactly what you're after:

http://www.sommarskog.se/arrays-in-sql-2005.html

This method is borrowed from a blog post here: http://consultingblogs.emc.com/jamespipe/archive/2007/06/28/SQL-Server-2005_3A00_-Passing-variables-into-an-OPENQUERY-argument.aspx

This should do the trick:

DECLARE @VAR char(2)

DECLARE @TSQL varchar(8000)

set @VAR = 'CA'

set @TSQL = 'SELECT * FROM pubs.dbo.authors WHERE state...

I had a typo for my sample data, I intended to include 127 in the result set.... sorry for the confusion there.

Thanks for the help guys, I got it now....

If only 2% of people are getting this correct, it's a sign of a badly written question.

Second, for a dedicated database server there is no reason to set a minimum memory amount. Setting the minimum to 12GB and the maximum to 14GB running SQL Server 2005...

For those that have html tags inside the question (I'm using Chrome), the question shows up properly in the email... and I posted it below:

use master

go

create database testdb

go

create proc sp_test...

Like this?

SELECT ID, UNIT_LABOR_COST, UNIT_BURDEN_COST, UNIT_SERVICE_COST

FROM PART

WHERE PURCHASED = 'Y' AND FABRICATED = 'N'

AND (UNIT_LABOR_COST 0.00 AND UNIT_BURDEN_COST 0.00 AND UNIT_SERVICE_COST 0.00)

The fact that there were any votes for the "delete Resource database" option was a bit scary.

Maybe run something simpler like:

SELECT Title FROM Document WHERE TITLE LIKE '%Sabra%'

and if that doesn't return anything, run this just to confirm you have something there at all:

SELECT Title FROM...

The following works:

create table #Document (Title varchar(64))

insert into #Document

select 'it''s Sabra and Chatilla'

SELECT * FROM #Document

WHERE Title='it''s Sabra and Chatilla'

drop table #Document

You mention the Title field "contains" this...

Looks like it. They'll need to check the Security Properties of the Linked Server, to make sure that either your login is added explicitly, or that any connections to...

So it looks like the Linked Server is there, you probably just need to have rights to the Linked Server. You'll probably need to talk to the DBA at...