You'll need a (temporary) table and you can only "catch" the first resultset, and output parameters.

create table #tmpResults (col......)

insert into #tmpResults

exec usp_whatever (.....)

- did you encounter errors when doing all this ?

- what does sqlservers errorlog state?

- this once more proves you really need backups !

I would certainly test SSMA.

Download it, install it, and see what kind of remark, warning, errors it gives.

You may need to do some stuff as a perparation for the migration.

Make...

syedbilalmasaud (5/19/2008)

---

ok let me try with print statement and see the results and let you know , if you can write script for my specific database it will be very...

Not much you can do about it, but complain :ermm: ......

It would be better to have your companies "software-client" complain and request a sql2005 certificate for it.

Let them reside...

If I were in your shoes, I'd look for "exec" statements, and replace them with "print" statements, then execute the script a see what it does.

It was wrong of me...

rbarryyoung (5/18/2008)

---

ALZDBA, unfortunately, what that footnote is describing is all that Express Edition can do. It cannot exchange messages with Express Edtion instances, including itself. It can only...

Jeff Moden (5/19/2008)

---

...I guess that's why part of my Mantra is "do as much as you can in T-SQL instead of CLR's" and "you can do more than you think...

this means you sqlserver instance service account cannot access "'D:\MSSQL\EC_SunAmerica200805181408.bak"

btw : mentioning "failover" for most of us triggers "clustering".

With clustering, at failover time, shared disks are reconnected to the other...

Robyn Page and Phil Factor published a CLR cribsheet at

http://www.simple-talk.com/dotnet/performance/net-performance-cribsheet/

It also mentiones the ms CLRProfiler.

You can download "CLR Profiler for the .NET Framework 2.0" at http://www.microsoft.com/downloads/details.aspx?FamilyId=A362781C-3870-43BE-8926-862B40AA0CD0&displaylang=en

SQL Server 2005 Features Comparison

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

states :

Service Broker

See...

To generate a restore statement starting from a full backup, placing the new db-files at the instance default location, I use this script:

/* generate RESTORE DATABASE from backup file */

Declare...

- if you want to play it safe, make a full backup before you start.

- then perform then integrety check, so you know the data is ok before you start...

always comming to the same problem, when not storing a column according to its natural datatype. :doze:

Declare @test varchar(15)

set @test = '9:08'

select REPLICATE('0',4 - datalength(replace(@test ,':','') )) + replace(@test ,':','')

- put a clustering index on that table ! (as tight a possible)

(or rebuild its clix)

Keep in mind, by setting a clustered index, it will need to rewrite the whole...