Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cmspinto
Starting Member
2 Posts |
 Posted - 2008-01-28 : 09:25:54
|
Hi all, I'm new in the forum. I have just started in SQL 2005, I'm now migrating from 2000 to 2005. What happend is that we have a sp that run the stored procedure 'xp_makewebtask' and it is giving an error. I have search and I have two articles that specify that sp. One says that by running:EXECUTE sp_configure 'show advanced options', 1;RECONFIGURE WITH OVERRIDE;EXECUTE sp_configure 'sys.xp_makewebtask', '1';RECONFIGURE WITH OVERRIDE;EXECUTE sp_configure 'show advanced options', 0;RECONFIGURE WITH OVERRIDEthe store procedure should be working and the other is this one:http://www.navicosoft.com/software/SQLServer2005-DVD/ReadmeSQL2005.htmthat says that the sp exists in 2005 but it is disable by dafault. But I'm starting to suspect that this sp can not run in 2005.I have try to refine the search to the microsoft website but the first 1000 results are in chinese!!!http://www.google.com/search?q=msdn+sql+2005+xp_makewebtask&hl=en&client=firefox-a&rls=org.mozilla:en-GB:official&start=120&sa=N Has anyone worked with this sp in 2005?Does anybody know a stored procedure taht can replace this one?Thanks in advance.Carlos |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-01-28 : 09:38:40
|
| you're probably reffering to sp_makewebtask_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
 |
|
|
cmspinto
Starting Member
2 Posts |
Posted - 2008-01-29 : 06:06:03
|
| Hi, yep, sometimes the solution is really simple, you just can't see it.Thank's very much.Carlos |
|
|
|
|
|
|
xp_makewebtask in 2005