November 20, 2013 at 10:13 pm
Any Alternate code for below query, because sp_makewebtask is not available in sql 2008
Pl help
USE pubs
GO
EXECUTE sp_makewebtask @outputfile = 'C:\WEB\MULTIPLE.HTM',
@query = 'SELECT title, price FROM titles SELECT au_lname, au_fname
FROM authors SELECT pub_id, pub_name FROM publishers SELECT au_lname,
au_fname FROM authors', @templatefile = 'C:\WEB\MULTIPLE.TPL',
@dbname = 'pubs', @rowcnt = 5, @whentype = 9
GO
November 20, 2013 at 11:40 pm
any one who can help me:-)
November 21, 2013 at 3:22 am
The web task procedures were removed from SQL Server 2008.
Looking at MSDN it recommends using Reporting Services.
November 25, 2013 at 11:27 pm
Dear Lynn,
I am not using any report services . i am creating HTML report based on the sql query with help of TPL file.
November 26, 2013 at 12:13 am
Don't know what a TPL file is and since I never had to convert a query using the webtask procedures to SQL Server 2008 the best I could do was tell you what BOL (MSDN) had to say.
November 27, 2013 at 3:17 am
The Web Assistant functionality in SQL Server was removed for SQL 2008 and above. You need to find an alternative approach that gives the results you need. For some people SSRS can give what is needed, but for others this means writing a .Net web service that can respond to HTTP requests and get its data from SQL Server.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply