February 11, 2011 at 4:43 am
i downloaded ASSP.dll and added to assemblies(in SSMS-Database Engine)
and then
trying to execute
call SQLQuery.Executesql(
"provider=SQLNCLI;server=localhost\sqlexpress;database=sriharidb;trusted_connection=yes"
,"select * from dbo.srihari");
and getting...
Query (1, 6) The '[SQLQuery].[Executesql]' function does not exist.
plz hlp me...
in my sys..i've
MS SQL Server 2008 Enterprise edition
Thanks in advance..
[font="Verdana"]SRIHARI(:~[/font]
February 13, 2011 at 1:23 pm
Hi ,
I suggest you read the ASSP documentation carefully on the codeplex site.
The SQLQuery is placed in a different assembly. That has been done for security reasons.
If you want to have the SQLQuery assembly download it from here. http://asstoredprocedures.codeplex.com/releases/view/41108
It is the last download link on this page..
named SQLQuery v1.3.5.zip.
The second suggestion I have is:Learn and use SSAS out-of-the-box before first before using advanced functionallity.
Regards Kees
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply