More Mulitvalue parameter issues...

I have a URL action on a report item that opens a new window to a different
report (using a piece of javascript). I need to pass the selected multivalue
parameter from the first report to this other report. But I cant figure out
how to pass the multivalue paramaters in the url, I have tried just
Parameters!Region.Value and also split(Parameters!Region.Value,", ") and
join(Parameters!Region.Value,", ") but none of them work.
the url actions is...
="javascript:void(window.open('http://server/Reportserver2005?/Report1®ion="
& Parameters!Region.Value &
rs:Command=Render&rs:ClearSession=true&rc:Parameters=false','_blank','location=no,resizable,toolbar=yes,left=200,top=60,height=590,width=760'))"
Any ideas?I haven't done this and don't have a sample, but just for S&G (S and
giggles), try using the encoded equivalent of the "," to join the values...
Call it a SWAG.
"NH" <NH@.discussions.microsoft.com> wrote in message
news:D3528E3E-CF89-4EEB-BA9E-DA8C88A3066B@.microsoft.com...
>I have a URL action on a report item that opens a new window to a different
> report (using a piece of javascript). I need to pass the selected
> multivalue
> parameter from the first report to this other report. But I cant figure
> out
> how to pass the multivalue paramaters in the url, I have tried just
> Parameters!Region.Value and also split(Parameters!Region.Value,", ") and
> join(Parameters!Region.Value,", ") but none of them work.
> the url actions is...
> ="javascript:void(window.open('http://server/Reportserver2005?/Report1®ion="
> & Parameters!Region.Value &
> rs:Command=Render&rs:ClearSession=true&rc:Parameters=false','_blank','location=no,resizable,toolbar=yes,left=200,top=60,height=590,width=760'))"
> Any ideas?sql

more FREETEXT

Continuing problems with FREETEXT...
So... I went through the wizard to create FullText catalog, everything went
nice without problems (selected table and fields to search on)
The problem is that I still have Item Count 0 (properties of the catalog)
after rebuild and full population was done (I have about 1000 records in the
table)
Fields that were searched are "ntext" all containing some data
What to do? What could be problem?
problem was that administrators were not un SQL users list and apparently
MSSearch service was not able to connect to server because of that
"borko" <borko@.borko.co.co> wrote in message
news:d81fbi$mmt$1@.ss405.t-com.hr...
> Continuing problems with FREETEXT...
> So... I went through the wizard to create FullText catalog, everything
> went nice without problems (selected table and fields to search on)
> The problem is that I still have Item Count 0 (properties of the catalog)
> after rebuild and full population was done (I have about 1000 records in
> the table)
> Fields that were searched are "ntext" all containing some data
> What to do? What could be problem?
>
>
|||Borko,
For the benefit of others & to clarify for others who may also encounter
this problem with either FREETEXT or CONTAINS when using SQL Server 2000
Full-text Search (FTS), if you remove or alter the BUILTIN\Administrators
login, then the "Microsoft Search" (mssearch.exe) service will not be able
to connect to SQL Server. Thus the MSSearch service will not be able to
successfully execute a Full or Incremental Population (0 item count is a
symptom of this problem). There are several kb articles on this topic and a
pure TSQL workaround if the BUILTIN\Administrators login must not exist for
security reasons, you can use the following T-SQL code as a workaround:
exec sp_grantlogin N'NT Authority\System'
exec sp_defaultdb N'NT Authority\System', N'master'
exec sp_defaultlanguage N'NT Authority\System','us_english'
exec sp_addsrvrolemember N'NT Authority\System', sysadmin
Hope that helps!
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"borko" <borko@.borko.co.co> wrote in message
news:d8m5vo$63m$1@.ss405.t-com.hr...[vbcol=seagreen]
> problem was that administrators were not un SQL users list and apparently
> MSSearch service was not able to connect to server because of that
>
> "borko" <borko@.borko.co.co> wrote in message
> news:d81fbi$mmt$1@.ss405.t-com.hr...
catalog)
>

more FREETEXT

Continuing problems with FREETEXT...
So... I went through the wizard to create FullText catalog, everything went
nice without problems (selected table and fields to search on)
The problem is that I still have Item Count 0 (properties of the catalog)
after rebuild and full population was done (I have about 1000 records in the
table)
Fields that were searched are "ntext" all containing some data
What to do? What could be problem?problem was that administrators were not un SQL users list and apparently
MSSearch service was not able to connect to server because of that
"borko" <borko@.borko.co.co> wrote in message
news:d81fbi$mmt$1@.ss405.t-com.hr...
> Continuing problems with FREETEXT...
> So... I went through the wizard to create FullText catalog, everything
> went nice without problems (selected table and fields to search on)
> The problem is that I still have Item Count 0 (properties of the catalog)
> after rebuild and full population was done (I have about 1000 records in
> the table)
> Fields that were searched are "ntext" all containing some data
> What to do? What could be problem?
>
>|||Borko,
For the benefit of others & to clarify for others who may also encounter
this problem with either FREETEXT or CONTAINS when using SQL Server 2000
Full-text Search (FTS), if you remove or alter the BUILTIN\Administrators
login, then the "Microsoft Search" (mssearch.exe) service will not be able
to connect to SQL Server. Thus the MSSearch service will not be able to
successfully execute a Full or Incremental Population (0 item count is a
symptom of this problem). There are several kb articles on this topic and a
pure TSQL workaround if the BUILTIN\Administrators login must not exist for
security reasons, you can use the following T-SQL code as a workaround:
exec sp_grantlogin N'NT Authority\System'
exec sp_defaultdb N'NT Authority\System', N'master'
exec sp_defaultlanguage N'NT Authority\System','us_english'
exec sp_addsrvrolemember N'NT Authority\System', sysadmin
Hope that helps!
John
--
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"borko" <borko@.borko.co.co> wrote in message
news:d8m5vo$63m$1@.ss405.t-com.hr...
> problem was that administrators were not un SQL users list and apparently
> MSSearch service was not able to connect to server because of that
>
> "borko" <borko@.borko.co.co> wrote in message
> news:d81fbi$mmt$1@.ss405.t-com.hr...
> > Continuing problems with FREETEXT...
> >
> > So... I went through the wizard to create FullText catalog, everything
> > went nice without problems (selected table and fields to search on)
> >
> > The problem is that I still have Item Count 0 (properties of the
catalog)
> > after rebuild and full population was done (I have about 1000 records in
> > the table)
> >
> > Fields that were searched are "ntext" all containing some data
> >
> > What to do? What could be problem?
> >
> >
> >
>

more FREETEXT

Continuing problems with FREETEXT...
So... I went through the wizard to create FullText catalog, everything went
nice without problems (selected table and fields to search on)
The problem is that I still have Item Count 0 (properties of the catalog)
after rebuild and full population was done (I have about 1000 records in the
table)
Fields that were searched are "ntext" all containing some data
What to do? What could be problem?problem was that administrators were not un SQL users list and apparently
MSSearch service was not able to connect to server because of that
"borko" <borko@.borko.co.co> wrote in message
news:d81fbi$mmt$1@.ss405.t-com.hr...
> Continuing problems with FREETEXT...
> So... I went through the wizard to create FullText catalog, everything
> went nice without problems (selected table and fields to search on)
> The problem is that I still have Item Count 0 (properties of the catalog)
> after rebuild and full population was done (I have about 1000 records in
> the table)
> Fields that were searched are "ntext" all containing some data
> What to do? What could be problem?
>
>|||Borko,
For the benefit of others & to clarify for others who may also encounter
this problem with either FREETEXT or CONTAINS when using SQL Server 2000
Full-text Search (FTS), if you remove or alter the BUILTIN\Administrators
login, then the "Microsoft Search" (mssearch.exe) service will not be able
to connect to SQL Server. Thus the MSSearch service will not be able to
successfully execute a Full or Incremental Population (0 item count is a
symptom of this problem). There are several kb articles on this topic and a
pure TSQL workaround if the BUILTIN\Administrators login must not exist for
security reasons, you can use the following T-SQL code as a workaround:
exec sp_grantlogin N'NT Authority\System'
exec sp_defaultdb N'NT Authority\System', N'master'
exec sp_defaultlanguage N'NT Authority\System','us_english'
exec sp_addsrvrolemember N'NT Authority\System', sysadmin
Hope that helps!
John
--
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"borko" <borko@.borko.co.co> wrote in message
news:d8m5vo$63m$1@.ss405.t-com.hr...
> problem was that administrators were not un SQL users list and apparently
> MSSearch service was not able to connect to server because of that
>
> "borko" <borko@.borko.co.co> wrote in message
> news:d81fbi$mmt$1@.ss405.t-com.hr...
catalog)[vbcol=seagreen]
>

Monitoring sql statement ran against a table

I need to know if there is a way to either record all queries ran again
a particular table or to fire off a trigger if a particualr row is
selected from that table in sql server 2005. The main issue I am
having is "select" statements. The reason I am attempting to do this is
its full fill part of some requirements for a project. I was hoping to
do this with sql server and not a third party solution if possible.
Thanks for any help,
Marty
--
>> www.techmentors.net <<<<<
A free community forum for resolving all of your high tech issues.maznblue@.gmail.com wrote:
> I need to know if there is a way to either record all queries ran again
> a particular table or to fire off a trigger if a particualr row is
> selected from that table in sql server 2005. The main issue I am
> having is "select" statements. The reason I am attempting to do this is
> its full fill part of some requirements for a project. I was hoping to
> do this with sql server and not a third party solution if possible.
> Thanks for any help,
> Marty
> --
> >> www.techmentors.net <<<<<
> A free community forum for resolving all of your high tech issues.
Use profiler
You can filter data as per your requirement.
use sp:stmtcompleted , sp:completed events and objecttype , objectname
column, which will show you details about triggers when event will be
triggered
Regards
Amish Shah|||Marty,
Try using SQL Profiler and put a filter on TextData column like
'SELECT%XXXX%' where XXXXis the table which you are looking for..
Jayesh
<maznblue@.gmail.com> wrote in message
news:1149817748.504429.74260@.i40g2000cwc.googlegroups.com...
>I need to know if there is a way to either record all queries ran again
> a particular table or to fire off a trigger if a particualr row is
> selected from that table in sql server 2005. The main issue I am
> having is "select" statements. The reason I am attempting to do this is
> its full fill part of some requirements for a project. I was hoping to
> do this with sql server and not a third party solution if possible.
> Thanks for any help,
> Marty
> --
>> www.techmentors.net <<<<<
> A free community forum for resolving all of your high tech issues.
>|||Jayesh -
Thanks for the info, it worked like a champ.
Marty
Jayesh Antony Jose wrote:
> Marty,
> Try using SQL Profiler and put a filter on TextData column like
> 'SELECT%XXXX%' where XXXXis the table which you are looking for..
> Jayesh
>
> <maznblue@.gmail.com> wrote in message
> news:1149817748.504429.74260@.i40g2000cwc.googlegroups.com...
> >I need to know if there is a way to either record all queries ran again
> > a particular table or to fire off a trigger if a particualr row is
> > selected from that table in sql server 2005. The main issue I am
> > having is "select" statements. The reason I am attempting to do this is
> > its full fill part of some requirements for a project. I was hoping to
> > do this with sql server and not a third party solution if possible.
> >
> > Thanks for any help,
> >
> > Marty
> >
> > --
> >> www.techmentors.net <<<<<
> > A free community forum for resolving all of your high tech issues.
> >

Monitoring Inserted data and comparing against selected data

I made ahuge load script in SQL Server 2000 as i load data from many
tables(select some of each one collumns) into one single table and i
want to test the loaded data against the selected data to make sure
that the loaded data is the same the selected data
is there a code or tool to make this test or monitoring ?? please
urgent ...tamatem wrote:

Quote:

Originally Posted by

I made ahuge load script in SQL Server 2000 as i load data from many
tables(select some of each one collumns) into one single table and i
want to test the loaded data against the selected data to make sure
that the loaded data is the same the selected data
is there a code or tool to make this test or monitoring ?? please
urgent ...

So you did a select ... into query? I'd be curious to know why exactly
you want to compare the two tables. Do you not trust the server to do
it correctly? It isn't really like a file copy or network transfer
where it's subject to errors.|||I agree.

You can trust SQL to do the job correctly or give an error. Just check
for @.@.ERROR to make sure that no error happened. I dont think you would
actually need to check whether the data got inserted properly.

ZeldorBlat wrote:

Quote:

Originally Posted by

tamatem wrote:

Quote:

Originally Posted by

I made ahuge load script in SQL Server 2000 as i load data from many
tables(select some of each one collumns) into one single table and i
want to test the loaded data against the selected data to make sure
that the loaded data is the same the selected data
is there a code or tool to make this test or monitoring ?? please
urgent ...

>
So you did a select ... into query? I'd be curious to know why exactly
you want to compare the two tables. Do you not trust the server to do
it correctly? It isn't really like a file copy or network transfer
where it's subject to errors.