I could be wrong (and would love to know the solution if there is one) but I think you can only retrieve the last recordset from an SP.

You know ya'll could leave the original question and the answer for the rest of us to read :). I love reading stuff with solutions .. its a lot...

All you are looking for is a list of column names and their definitions correct?

In that case why not use INFORMATION_SCHEMA.COLUMNS. It should have everything you need.

Here is an example of what you need to do:

declare @sql nvarchar(400)

declare @test-2 int

set @sql = 'select @test-2 = count(*) from sysobjects'

exec sp_executesql @sql, N'@test int output', @test-2 output

select @test-2

You...

Assuming the service pack doesn't work have you thought about taking a different route?

And fair warning I'm not an expert on replication. I know just enough to be dangerous.

Have...

Very cool. I've never seen the CROSS APPLY before. Is this new to 2005? Also I have to say the BOL help on it is one of...

True enough. Although I have used views within SPs that get called more on the order of 100-1000 times a second without any real problems.

I'm still thinking the rename...

I think we need more information on this one. I'm not sure I understand what you mean by using 1 column from the query as a sub query? ...

So then you are back to doing a manual adjustment of a script file.

However I would like to see the performance on the view assuming that you have an identity...

In that case I would change name of the Doctor table to Doctor_Name and the name of the view to Doctor. That way your code and views and SPs...

Andras Belokosztolszki (11/14/2007)

---

Disclaimer: I wrote a large part of this tool and I do work for Red Gate. There are other alternatives, but the one I mentioned is the one...

A completely off the wall thought and I'm not even sure it would make a difference but have you checked the compatability level? Any chance it a 6.5 database?...

You could try making a copy of your mdf, ldf files and then attaching them rather than doing the backup restore route.

Does the file "e:\MSSQL_dataew_db_data1.ndf" still exist? Did it ever to your knowledge?

You could try doing a backup and restore to another DB Name just to see if it works....

Definatly not stupid. And had you been working in 2000 it would have been a reasonable one (minus all of the problems I've mentioned above). Fortunatly (or unfortunatly...