| Author |
 Topic  |
|
|
druffyw
4 Posts |
 Posted - 08/25/2009 : 07:47:52
|
Hi,
I have a problem because one of our customers is using SQL Server 2005 without a Service Pack.... I know... but they are.
This means that the SQL scripts created to be deployed on their version of our applications fails.
The main error is:
Could not find stored procedure 'sp_refreshsqlmodule'
Reason being that this sp is part of sp2 or higher. (as I read it, from googling MS sites and forums).
Is there a way I can force DBGhost to make the change script to be "Deployable" to SQL Server 2005 PRE SP2 ?
Kind Regards,
Thomas
DBGhost Version: 5.0.0.1038
OS: Windows Server 2003 R2
RegionSettings: US
|
|
|
leachm
124 Posts |
Posted - 08/25/2009 : 08:14:24
|
Hi Thomas,
There is one idea to workaround this - try creating a dummy sp_refreshsqlmodule sproc in a custom "before" script:
create procedure sp_refreshsqlmodule
@name nvarchar(776),
@namespace nvarchar(20) = N'OBJECT'
as
return 0
To see if this works first get your customer to create the dummy sproc on the target database and then run your delta.sql...
Thanks,
Malcolm
Addendum - sorry - you'll probably want to wrap that with:
If not exists()
Exec('create proc...')
to make it more resilient... |
Edited by - leachm on 08/25/2009 08:58:13 |
 |
|
|
druffyw
4 Posts |
Posted - 08/26/2009 : 04:04:07
|
Hi Malcolm,
I created the procedure on the customer database before deployment and removed it again after (You never know if they suddenly decide to upgrade the cluster on a different project than ours ;-)
It works like a charm, and I am only slightly annoyed that I didn't think of this workaround myself :-)
Thank you for you help,
Kind Regards,
Thomas
DBGhost Version: 5.0.0.1038
OS: Windows Server 2003 R2
RegionSettings: US |
|
|
|
leachm
124 Posts |
Posted - 08/26/2009 : 04:06:12
|
| Cool, glad to hear it worked out :o) |
|
|
| |
Topic |
|
|
|
MS Sql Server 2005 No SP
