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...

Indeed, the only way you can do this with the standard tools of sqlserver is by restoring the backup to another dbname, script the procs and functions.

Don't forget to script...

you can even avoid the splash screen by adding /nosplash to the shortcut statement.

keep in mind the "old" syntax (*= / =*) has been anounced for deprecation since SQL7.0 sp2.