IUSR_ to run function, drop table..

Helo all,

i dont know if that is the right way, but i was wanted to make kind of sql profiler on a webpage :) and cool features would be to usa ajax to fire it async in some time secvence.. ok, ok, here goes my code and expla... i have sql2005 (express edition,, cose i think its so cool and for a lot of projects can be used for), attached startup procedure, whit>sp_procoption 'kreni_instanco_moja', startup, true,and kreni_insta... is like:

------
setANSI_NULLSON
setQUOTED_IDENTIFIERON
GO
ALTERPROCEDURE [dbo].[kreni_instanco_moja]
AS
BEGIN
exec kp.dbo.start_trace
END
------

ok and my start_trace is:

------
ALTERPROCEDURE [dbo].[start_trace]
AS
BEGIN
DECLARE
@.traceidnumINT,@.onBIT,@.file_pathNVARCHAR(50),@.maxsizebigint;
SET @.on= 1;SET @.maxsize=5;
SET @.file_path='O:\BU_DATABASE\'+convert(varchar,getdate(), 102);
EXEC sp_trace_create @.traceid= @.traceidnumOUTPUT, @.options= 2, @.tracefile= @.file_path, @.maxfilesize= @.maxsize, @.stoptime=null, @.filecount=0;
EXEC sp_trace_setevent 2, 12, 1, @.on-- ili 12 ili 13
EXEC sp_trace_setstatus 2, 1-- 1 = START, 0 = STOP
END
------

actual code that brings table and shows sql executed is:

------
use kp
droptable trace
select textdatainto tracefrom
fn_trace_gettable(N'O:\BU_DATABASE\'+convert(varchar,getdate(), 102)+'.trc',1)
select textdatafrom trace
go
------

and it works fine,, but when its fired from my local admin connection, and try that whit IUSR*?? not going... ok, i think that IUSR have to have privilage to open that O:\BU_DATABASE ... file, and to have priv to drop tabel and to fire that function..fn_trace_get ... ?? so, that is where i got stuck up... any help would be veryyyy apreciated... hey, we can put some kind of project if anybody is interested! :) to have admin page and to monitor sql code that is executed,,, and remotely

if i was not clear in some explaining, you can ask me and ill try better

thenx, kpendic

Yes, the connecting user needs all the privileges you stated (file, drop etc.), plus system wide ALTER TRACE permission.

|||

Yes Gunteman, and even ALTER TRC permission... but do you know how to achive this maybe??

thenx

sql

ITW says workload does not contain events or queries to use

Hi,
I'm having trouble getting the Index Tuning Wizard to analyze my workload.
I'm using SQL Server 2000. I've run the ITW against several different trace
files, and keep getting an error that says, "The workload does not contain
any events or queries that can be tuned against current database. Check to
see that the trace contains valid events or that the SQL script contains
valid queries and you are tuning against the right database."
In one case, as a test I ran the ITW against a trace file that I had run it
on about a month ago and gotten results from. Even with that file I still go
t
this error. In other cases when I try to run ITW on an older trace file, it
crashes. I've tried running ITW from another user's computer, with the same
result, so it doesn't seem to be my computer that's at fault.
I'm using the SqlProfilerTuning trace template. I've checked my trace
template against the same template on another computer to see if I had
changed something and broken it, but the only difference was that mine was
recording one additional data column, ApplicationName.
The events I'm recording are RPC:Completed and SQL:BatchCompleted.
There have definitely been data updates to at least some of the tables I'm
asking it to analyze. In some cases there have not been many updates (a doze
n
to a few dozen)--ITW documentation indicates that the ITW may fail if there
have not been enough changes to analyze, but it doesn't give any indication
as to what is enough.
Any suggestions what might be the problem, or how I could find out what the
problem is?
EachusDid you take a look at BOL Index: "Troubleshooting the Index Tuning Wizard"
?
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
"Eachus" <Eachus@.discussions.microsoft.com> wrote in message
news:42FB19DB-3631-4F02-A3BB-71A2B7EDFABD@.microsoft.com...
> Hi,
> I'm having trouble getting the Index Tuning Wizard to analyze my workload.
> I'm using SQL Server 2000. I've run the ITW against several different
trace
> files, and keep getting an error that says, "The workload does not contain
> any events or queries that can be tuned against current database. Check to
> see that the trace contains valid events or that the SQL script contains
> valid queries and you are tuning against the right database."
> In one case, as a test I ran the ITW against a trace file that I had run
it
> on about a month ago and gotten results from. Even with that file I still
got
> this error. In other cases when I try to run ITW on an older trace file,
it
> crashes. I've tried running ITW from another user's computer, with the
same
> result, so it doesn't seem to be my computer that's at fault.
> I'm using the SqlProfilerTuning trace template. I've checked my trace
> template against the same template on another computer to see if I had
> changed something and broken it, but the only difference was that mine was
> recording one additional data column, ApplicationName.
> The events I'm recording are RPC:Completed and SQL:BatchCompleted.
> There have definitely been data updates to at least some of the tables I'm
> asking it to analyze. In some cases there have not been many updates (a
dozen
> to a few dozen)--ITW documentation indicates that the ITW may fail if
there
> have not been enough changes to analyze, but it doesn't give any
indication
> as to what is enough.
> Any suggestions what might be the problem, or how I could find out what
the
> problem is?
> Eachus|||Thanks for the suggestion. Yes, I have read that page. It doesn't address
either of the messages that I'm receiving.
The messages I receive most often is:
"The workload does not contain any events or queries that can be tuned
against current database. Check to see that the trace contains valid events
or that the SQL script contains valid queries and you are tuning against the
right database."
Sometimes I get this message:
"There are no events in the workload. Either the trace file contained no SQL
batch or RPC events or the SQL script contained no SQL queries."
According to all the documentation I can find, the RPC:Completed and
SQL:BatchCompleted events that the trace is capturing are what ITW needs, so
that message doesn't make any sense.
Laura
"Vinod Kumar" wrote:

> Did you take a look at BOL Index: "Troubleshooting the Index Tuning Wizard
"
> ?
> --
> HTH,
> Vinod Kumar
> MCSE, DBA, MCAD, MCSD
> http://www.extremeexperts.com
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp
> "Eachus" <Eachus@.discussions.microsoft.com> wrote in message
> news:42FB19DB-3631-4F02-A3BB-71A2B7EDFABD@.microsoft.com...
> trace
> it
> got
> it
> same
> dozen
> there
> indication
> the
>
>

It's possibel run SSIS in SQL Server 2005 Express Edition

Hy,

I wont now if it's possible to run SSIS in my server client that have instaled SQL Server 2005 Express Edition?

Regards,

Filipe Silva

Hello,

SSIS comes only with Microsoft SQL Server, it's not part odf the Express Edition

Regards,
Ovidiu Burlacu

|||

No. SQL Server Express does not include SSIS.

-Jamie

Its Not Report Parameters (ITS REPORTING SERVICES I THINK)

i am trying to generate a report based on 3 parameters

age, location, ethnciity

every thing works fine in data and layout tab,

when i run the preview tab, it give me the option to input paramaters and then when i hit veiw report, it shows processing report.... (indefinite) time.

i tried executing the query in data tab, it takes less than a sec.

any ideas?

am i doing somethign wrong in parameters?

Raja,

I'm going on the assumption you are using SQL as your datasource, If so, you can start a SQL profiler on the database you're using.

In the profiler, you can watch the query statement from SQL reporting service being executed, It will reveal exactly what is being passed in your parameter. You can copy this statement and execute to a new query to help you debug your issue.

I hope that this helps.

Ham

|||

its some weard problem.

its hitting the dbase and i double checked it in the profiler.

i dont knows what happening. i deleted the data cache files in the folder and tried rerun again..

nothing works.

data tab works 1000 times fine.

|||

What happens when you take the statement from the profiler and run it in a new query window. Does that execution of the statement still takes a long time?

Ham

|||

Hi,

I once had sort of the same problem. I didn't set the datatype of the parameters correctly which caused problems when viewing the report.

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

Yes,

I checked it with the QAnalyzer, Profiler, ReportingServices Data Tab.

everything takes less than a sec to execute the 15000 records.

This is one thing i noticed now after some weird research.

when i hit the preview tab and input parameters its not showing anything (i mean it shows report processinng..... )

but now when i deploy it to the server and try to view it. ITS WORKING

Where the h... is the problem. ?

|||any one have an email id of any of the webcast instructors who have instructed for RS before...|||any help?

It's baaack

I've been chasing a performance issue on and off for several ws. A stored
procedure in a custom application will run in under 30 seconds or it may tak
e
as long as 6 hours to run. I've got a stack of execution plans on this
procedure and sometimes the procedure uses a good plan complete with
parallelism and other times the optimizer decides to take the long way
through the data and use a serial plan and just crunch hundreds of millions
of records.
I got some help from this board several ws ago and learned about
parameter sniffing and found that local variables and defaults helped the
optimizer choose the good plan and incorporate parallelism. We thought we ha
d
it solved until last w, when the optimizer began choosing the bad plan
again. So, we reindexed, updated stats on key tables with full scans and tha
t
solved it.
It's now morphed again and doesn' respond to previous remedies. For whatever
reason, the optimizer insists on taking the long way. I really need to
rewrite this procedure but need a quick fix AND I'd like to understand what'
s
going on. The procedure includes views joined to views which include views
(it's ugly) as well as joins to base tables and I know the confusion is the
order in which tables get joined and processed. So, I reordered the join
syntax in the SP and used a force order option. Now I get the good plan agai
n
complete with parallelism... for now until it morphs again.
Do views prevent the optimizer from making the best use of statiscs? Why
doesn't the optimizer always use parallelism..the cost setting is set to 5-
default and I set it down to 1 and it still didn't use parallelism?
Thanks for any insight
MardyWhether the actual query uses parallelism is determined at run time each and
every time the query is run. This is based on several factors such as how
busy the cpu's are, the amount of available memory etc. A complex query
will usually generate a serial and parallel plan but that is only the
initial plan. At run time the engine decides which to run. So running a
query with a single proc or more than 1 proc can be different each time it
is run. With that said a very complex query with lots of views, joins etc
can be tough to crunch. There are times when the optimizer simply gives up
and says this plan will have to do even though there may be a more optimal
plan that can be generated. When you have lots of objects (tables, views,
indexes) to deal with the cost of trying out each and every possibility can
get too prohibitive. The more objects you have the choices become somewhat
exponential. I have seen very complex sp's take a long time to compile and
not even have the most optimal plan. The solution is to rewrite your
queries. Probably breaking it down into multiple individual sp's. That
way each sp can be optimized rather quickly and is usually easier to tune.
Hope that helps.
Andrew J. Kelly SQL MVP
"Mardy" <Mardy@.discussions.microsoft.com> wrote in message
news:37BD8EB7-2457-4742-B250-EE33CCE3DEA7@.microsoft.com...
> I've been chasing a performance issue on and off for several ws. A
> stored
> procedure in a custom application will run in under 30 seconds or it may
> take
> as long as 6 hours to run. I've got a stack of execution plans on this
> procedure and sometimes the procedure uses a good plan complete with
> parallelism and other times the optimizer decides to take the long way
> through the data and use a serial plan and just crunch hundreds of
> millions
> of records.
> I got some help from this board several ws ago and learned about
> parameter sniffing and found that local variables and defaults helped the
> optimizer choose the good plan and incorporate parallelism. We thought we
> had
> it solved until last w, when the optimizer began choosing the bad plan
> again. So, we reindexed, updated stats on key tables with full scans and
> that
> solved it.
> It's now morphed again and doesn' respond to previous remedies. For
> whatever
> reason, the optimizer insists on taking the long way. I really need to
> rewrite this procedure but need a quick fix AND I'd like to understand
> what's
> going on. The procedure includes views joined to views which include views
> (it's ugly) as well as joins to base tables and I know the confusion is
> the
> order in which tables get joined and processed. So, I reordered the join
> syntax in the SP and used a force order option. Now I get the good plan
> again
> complete with parallelism... for now until it morphs again.
> Do views prevent the optimizer from making the best use of statiscs? Why
> doesn't the optimizer always use parallelism..the cost setting is set to
> 5-
> default and I set it down to 1 and it still didn't use parallelism?
> Thanks for any insight
> Mardy|||If the query contains a lot of sub-queries, then consider inserting the
intermediate results into temporary tables.
Queries of the following style can trip up the optimizer at runtime:
select ... from ... where x in (select ... from ...)
Also, calling UDFs can impede the optimizer.
"Mardy" <Mardy@.discussions.microsoft.com> wrote in message
news:37BD8EB7-2457-4742-B250-EE33CCE3DEA7@.microsoft.com...
> I've been chasing a performance issue on and off for several ws. A
stored
> procedure in a custom application will run in under 30 seconds or it may
take
> as long as 6 hours to run. I've got a stack of execution plans on this
> procedure and sometimes the procedure uses a good plan complete with
> parallelism and other times the optimizer decides to take the long way
> through the data and use a serial plan and just crunch hundreds of
millions
> of records.
> I got some help from this board several ws ago and learned about
> parameter sniffing and found that local variables and defaults helped the
> optimizer choose the good plan and incorporate parallelism. We thought we
had
> it solved until last w, when the optimizer began choosing the bad plan
> again. So, we reindexed, updated stats on key tables with full scans and
that
> solved it.
> It's now morphed again and doesn' respond to previous remedies. For
whatever
> reason, the optimizer insists on taking the long way. I really need to
> rewrite this procedure but need a quick fix AND I'd like to understand
what's
> going on. The procedure includes views joined to views which include views
> (it's ugly) as well as joins to base tables and I know the confusion is
the
> order in which tables get joined and processed. So, I reordered the join
> syntax in the SP and used a force order option. Now I get the good plan
again
> complete with parallelism... for now until it morphs again.
> Do views prevent the optimizer from making the best use of statiscs? Why
> doesn't the optimizer always use parallelism..the cost setting is set to
5-
> default and I set it down to 1 and it still didn't use parallelism?
> Thanks for any insight
> Mardy

Issues with Report Manager on both a web server and the report server?

My reports have been run off of a combined IIS/SQL server. I have a new application, which is using the SQL server, but runs on its own web server. The developer would like to deploy his reports to the new IIS server. Are there any issues with just installing a copy of the Report Manager on the new IIS server and putting reports there while continuing to run the original application on the combined server?

TIA

Daniel

Hi,

From your description, it seems that you want to deploy your reporting service on other server than the server with SQLServer, right?

I'm afraid you have to install components for SQLServer reporting service on that new IIS. Only n this way, you can re-configure the settings in SQL Server Reporting Services Configuration, including Web Service Identity, report server and report manager virtual directory, also the new database server's information. After that , you can run your reporting service with other database servers.

For more information on each components of Reporting service, see:

http://msdn2.microsoft.com/en-us/library/ms155792.aspx

Thanks.

|||

Michael,

I want to deploy report manager on two servers, the SQL server itself and on another server running just as a web server. I have not found a definitive answer, but based on what I have found I am thinking you can only have one report manager set up.

Regards,

Daniel

|||

Hi,

the SQL server itself and on another server running just as a web server.

No matter how many machines you want to run your Report Manager, you should install the SQLServer client component to enable the SQL Report manager. (connecting a remote database).

sql

issues using MS Access with SQL Server 2005

I'm trying to help my clients configure MS Access to run queries against a
SQL Server 2005 on a hoste providers server.
I'm using Access 2002 (10.6771.6735) SP3. When I try and design a view I get
the following error:
"This version of Microsoft Access deosn't support design changes with the
version of MS SQL Server your Access project is connected to. Your design
changes will not be saved."
My client, using Access 2003 gets a similar message and cannot save the view
she designed.
Is there something we have to configure on the hosted server to allow use of
Access?
Thanks for any assistance with this.Dabbler wrote:
> I'm trying to help my clients configure MS Access to run queries against a
> SQL Server 2005 on a hoste providers server.
> I'm using Access 2002 (10.6771.6735) SP3. When I try and design a view I get
> the following error:
> "This version of Microsoft Access deosn't support design changes with the
> version of MS SQL Server your Access project is connected to. Your design
> changes will not be saved."
> My client, using Access 2003 gets a similar message and cannot save the view
> she designed.
> Is there something we have to configure on the hosted server to allow use of
> Access?
> Thanks for any assistance with this.
Access ADP doesn't support modifications to SQL Server 2005 objects.
The easiest way to modify views is to use SQL Server Management Studio.
It seems to be unclear at the moment what the future of ADP is:
http://www.databaseadvisors.com/gazette/sqlexpress.htm
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||Thanks for the lowdown on this. Not sure what MS is thinking with regard to
the primary market for Access end users, I don't think SQL Server Management
Studio is appropriate for end users.
"David Portas" wrote:
> Dabbler wrote:
> > I'm trying to help my clients configure MS Access to run queries against a
> > SQL Server 2005 on a hoste providers server.
> >
> > I'm using Access 2002 (10.6771.6735) SP3. When I try and design a view I get
> > the following error:
> > "This version of Microsoft Access deosn't support design changes with the
> > version of MS SQL Server your Access project is connected to. Your design
> > changes will not be saved."
> >
> > My client, using Access 2003 gets a similar message and cannot save the view
> > she designed.
> >
> > Is there something we have to configure on the hosted server to allow use of
> > Access?
> >
> > Thanks for any assistance with this.
> Access ADP doesn't support modifications to SQL Server 2005 objects.
> The easiest way to modify views is to use SQL Server Management Studio.
> It seems to be unclear at the moment what the future of ADP is:
> http://www.databaseadvisors.com/gazette/sqlexpress.htm
> --
> David Portas, SQL Server MVP
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
> SQL Server Books Online:
> http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
> --
>|||Microsoft is really screwing up by not supporting SQLS2005 design work within
ADPs. So now I'm going to purchase the older SQLS2000 instead of 2005 to
accomplish what my users require? Seems counter-advancement. At least this
will save about $4000 with std. edition. As Dabbler says, SQLS Management
Studio is not appropriate for end users.
"Dabbler" wrote:
> Thanks for the lowdown on this. Not sure what MS is thinking with regard to
> the primary market for Access end users, I don't think SQL Server Management
> Studio is appropriate for end users.
> "David Portas" wrote:
> > Dabbler wrote:
> > > I'm trying to help my clients configure MS Access to run queries against a
> > > SQL Server 2005 on a hoste providers server.
> > >
> > > I'm using Access 2002 (10.6771.6735) SP3. When I try and design a view I get
> > > the following error:
> > > "This version of Microsoft Access deosn't support design changes with the
> > > version of MS SQL Server your Access project is connected to. Your design
> > > changes will not be saved."
> > >
> > > My client, using Access 2003 gets a similar message and cannot save the view
> > > she designed.
> > >
> > > Is there something we have to configure on the hosted server to allow use of
> > > Access?
> > >
> > > Thanks for any assistance with this.
> >
> > Access ADP doesn't support modifications to SQL Server 2005 objects.
> > The easiest way to modify views is to use SQL Server Management Studio.
> >
> > It seems to be unclear at the moment what the future of ADP is:
> > http://www.databaseadvisors.com/gazette/sqlexpress.htm
> >
> > --
> > David Portas, SQL Server MVP
> >
> > Whenever possible please post enough code to reproduce your problem.
> > Including CREATE TABLE and INSERT statements usually helps.
> > State what version of SQL Server you are using and specify the content
> > of any error messages.
> >
> > SQL Server Books Online:
> > http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
> > --
> >
> >

issues using MS Access with SQL Server 2005

I'm trying to help my clients configure MS Access to run queries against a
SQL Server 2005 on a hoste providers server.
I'm using Access 2002 (10.6771.6735) SP3. When I try and design a view I get
the following error:
"This version of Microsoft Access deosn't support design changes with the
version of MS SQL Server your Access project is connected to. Your design
changes will not be saved."
My client, using Access 2003 gets a similar message and cannot save the view
she designed.
Is there something we have to configure on the hosted server to allow use of
Access?
Thanks for any assistance with this.Dabbler wrote:
> I'm trying to help my clients configure MS Access to run queries against a
> SQL Server 2005 on a hoste providers server.
> I'm using Access 2002 (10.6771.6735) SP3. When I try and design a view I g
et
> the following error:
> "This version of Microsoft Access deosn't support design changes with the
> version of MS SQL Server your Access project is connected to. Your design
> changes will not be saved."
> My client, using Access 2003 gets a similar message and cannot save the vi
ew
> she designed.
> Is there something we have to configure on the hosted server to allow use
of
> Access?
> Thanks for any assistance with this.
Access ADP doesn't support modifications to SQL Server 2005 objects.
The easiest way to modify views is to use SQL Server Management Studio.
It seems to be unclear at the moment what the future of ADP is:
http://www.databaseadvisors.com/gazette/sqlexpress.htm
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||Thanks for the lowdown on this. Not sure what MS is thinking with regard to
the primary market for Access end users, I don't think SQL Server Management
Studio is appropriate for end users.
"David Portas" wrote:

> Dabbler wrote:
> Access ADP doesn't support modifications to SQL Server 2005 objects.
> The easiest way to modify views is to use SQL Server Management Studio.
> It seems to be unclear at the moment what the future of ADP is:
> http://www.databaseadvisors.com/gazette/sqlexpress.htm
> --
> David Portas, SQL Server MVP
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
> SQL Server Books Online:
> http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
> --
>|||Microsoft is really screwing up by not supporting SQLS2005 design work withi
n
ADPs. So now I'm going to purchase the older SQLS2000 instead of 2005 to
accomplish what my users require? Seems counter-advancement. At least this
will save about $4000 with std. edition. As Dabbler says, SQLS Management
Studio is not appropriate for end users.
"Dabbler" wrote:
[vbcol=seagreen]
> Thanks for the lowdown on this. Not sure what MS is thinking with regard t
o
> the primary market for Access end users, I don't think SQL Server Manageme
nt
> Studio is appropriate for end users.
> "David Portas" wrote:
>

Issues setting up users to authenticate via NT group into MSSQL

I have a NT Group of users that need to connect to MSSQL db using integrated auth and run a stored proc. I have got this concept to work for individual windows users but not a group.

Does anyone have any ideas?

(Win XP, MSSQL 2000 SP3, Windows Group = "SQLUsers", member is "User2")

-- TSQL --

USE master
GO
sp_grantlogin 'pc\SQLUsers'
GO
sp_defaultdb 'pc\SQLUsers', 'theDB'
GO
USE theDB
GO
sp_grantdbaccess 'pc\SQLUsers', 'SQLUsers'
GO
GRANT EXECUTE ON [dbo].[uspThing] TO SQLUsers
GO

-- Trying to connect with OSQL.EXE:

> osql -d theDB -E
Login failed for user 'pc\User2'.

BUT....

runing it for the individual user:

--TSQL

USE master
GO
sp_grantlogin 'pc\User2'
GO
sp_defaultdb 'pc\User2', 'theDB'
GO
USE theDB
GO
sp_grantdbaccess 'pc\User2', 'SQLUsers'
GO
GRANT EXECUTE ON [dbo].[uspThing] TO SQLUsers
GO

-- now trying to connect with OSQL.EXE as User2:

>osql -d theDB -E
1> exec uspThing
2> go
3> data...

all is fine.....

I can't use the user method - to much admin... any ideas!?

PKOk, get this... because I was using "runas /user:User2 cmd.exe" sessions for testing the different users integrated security (osql -E -d dbName) etc the group changes I was making were not reflected until I logged out of the command session.

I have been officially driven mad by this one...

Issues running reports from browser vs RS SP2 Viewer

Some people can run reports via IE.
It seems that people running Server 2003 (a slight few) and IE with Enhanced
secutity can't run the reports via IE.
Running reports from our app using the report viewer worked fine at one
point.
Now we've changed something (not sure what) but now the report viewer is
putting up a login dialog box. (If I log in an administrator it does
generate the report.)
Can someone point us in the right direction.
Kyle!I figured it out...
I was a browser setting issue.
The report server must be listed in the Local Intranet and the security for
the Local Intranet must be set to the default level.
This causes the broswer to try to log in with the users credentials. RS is
set up to all all Domain Users to browse (or run programatically) reports.
Kyle!
"Kyle Jedrusiak" <kjedrusiak@.princetoninformation.com> wrote in message
news:%238EtvuGbFHA.1312@.TK2MSFTNGP09.phx.gbl...
> Some people can run reports via IE.
> It seems that people running Server 2003 (a slight few) and IE with
> Enhanced secutity can't run the reports via IE.
> Running reports from our app using the report viewer worked fine at one
> point.
> Now we've changed something (not sure what) but now the report viewer is
> putting up a login dialog box. (If I log in an administrator it does
> generate the report.)
> Can someone point us in the right direction.
> Kyle!
>

Issue with running reports on machine that does not have report services

I am trying to run reports from a web application. If I am on the machine
with reporting services then the report will pull up. If I try from a PC
that doesn't have reporting services I get a "Page cannot be displayed"
error. I have checked permissions on most everything I could think of.
Please help. I have been researching and trying to resolve this for over
two weeks. Thanks!
--
Message posted via http://www.sqlmonster.comDo you mean you can't get to http://servername/reports from a remote
machine? Or are you trying to embed a report viewer control in an asp.net
app that's on a different machine?
Mike G.
"JC via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:f491c9d8986847cbbd8e3872e85aabca@.SQLMonster.com...
>I am trying to run reports from a web application. If I am on the machine
> with reporting services then the report will pull up. If I try from a PC
> that doesn't have reporting services I get a "Page cannot be displayed"
> error. I have checked permissions on most everything I could think of.
> Please help. I have been researching and trying to resolve this for over
> two weeks. Thanks!
> --
> Message posted via http://www.sqlmonster.com|||I can get the http//servername/reportserver to pull up after logging in as
an administrator, but what I need I will explain below.
I have a reportviewer embedded in my asp.net webapplication, but when I
click on the link from a PC that does not have report services loaded it
gives me the page cannot be displayed error.
Thanks!
Jill
--
Message posted via http://www.sqlmonster.com|||The report control doesn't require anything to be installed with the
browser. It just renders an iframe that points to the reportserver. This
may sound silly, but just to be sure, perhaps did you specify localhost as
part of the serverurl property of the viewer? If you did, the iframe won't
be pointing at the remote report server, but would still be looking at
localhost a.k.a itself.
Even if you didn't use localhost, from the client, type in what's in the
serverurl property and make sure you can get to the server from the client.
Also, you can always do a view source on the page, look for the iframe and
take a look at the src property.
Mike G.
"JC via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:de02341f0922462dba9a2ec5cdcb3992@.SQLMonster.com...
>I can get the http//servername/reportserver to pull up after logging in as
> an administrator, but what I need I will explain below.
> I have a reportviewer embedded in my asp.net webapplication, but when I
> click on the link from a PC that does not have report services loaded it
> gives me the page cannot be displayed error.
> Thanks!
> Jill
> --
> Message posted via http://www.sqlmonster.com|||Whoops...(blushes). I found where I had the localhost in the url. I
thought I had taken it out, but I must have not saved it. Thanks for that
tip.
The report is trying to come up now, but it prompts the user for a username
and password. I don't want the user to have to do that. Is there a way
around this?
Thanks!
--
Message posted via http://www.sqlmonster.com|||What is IIS set to allow? For an intranet, you probably want just windows
integrated (not anonymous). Of course, that means giving giving the
users/groups the correct permissions to the reports in the report manager.
Mike G.
"JC via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:183115a982ba408a8600324cca74f560@.SQLMonster.com...
> Whoops...(blushes). I found where I had the localhost in the url. I
> thought I had taken it out, but I must have not saved it. Thanks for that
> tip.
> The report is trying to come up now, but it prompts the user for a
> username
> and password. I don't want the user to have to do that. Is there a way
> around this?
> Thanks!
> --
> Message posted via http://www.sqlmonster.com

Issue with job run setup in Enterprise Manager

Hello All,
I have a job that consist of over 120 steps. I was able to setup it in Enter
prise Manager and run it. However, the job history can only show display 100
job steps 20 other job steps were missing. Is there a limit set on sysjobhi
story table or am I looking
at the wrong table? Please advice.
Thanks.
DavidThat is very interesting, and I do not know if it is related to the number
of histories per job, but maybe worth a try...
In SEM right click SQL Agent and go to the tab with Job history setup and
try both checking unlimited, and/or max histories per job to something like
300... See if that helps..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"David" <anonymous@.discussions.microsoft.com> wrote in message
news:A58F9373-EFBA-4426-A2CB-2E14328B18B9@.microsoft.com...
> Hello All,
> I have a job that consist of over 120 steps. I was able to setup it in
Enterprise Manager and run it. However, the job history can only show
display 100 job steps 20 other job steps were missing. Is there a limit set
on sysjobhistory table or am I looking at the wrong table? Please advice.
> Thanks.
> David

Issue with job run setup in Enterprise Manager

Hello All,
I have a job that consist of over 120 steps. I was able to setup it in Enterprise Manager and run it. However, the job history can only show display 100 job steps 20 other job steps were missing. Is there a limit set on sysjobhistory table or am I looking
at the wrong table? Please advice.
Thanks.
David
That is very interesting, and I do not know if it is related to the number
of histories per job, but maybe worth a try...
In SEM right click SQL Agent and go to the tab with Job history setup and
try both checking unlimited, and/or max histories per job to something like
300... See if that helps..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"David" <anonymous@.discussions.microsoft.com> wrote in message
news:A58F9373-EFBA-4426-A2CB-2E14328B18B9@.microsoft.com...
> Hello All,
> I have a job that consist of over 120 steps. I was able to setup it in
Enterprise Manager and run it. However, the job history can only show
display 100 job steps 20 other job steps were missing. Is there a limit set
on sysjobhistory table or am I looking at the wrong table? Please advice.
> Thanks.
> David

Issue with job run setup in Enterprise Manager

Hello All
I have a job that consist of over 120 steps. I was able to setup it in Enterprise Manager and run it. However, the job history can only show display 100 job steps 20 other job steps were missing. Is there a limit set on sysjobhistory table or am I looking at the wrong table? Please advice
Thanks
DavidThat is very interesting, and I do not know if it is related to the number
of histories per job, but maybe worth a try...
In SEM right click SQL Agent and go to the tab with Job history setup and
try both checking unlimited, and/or max histories per job to something like
300... See if that helps..
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"David" <anonymous@.discussions.microsoft.com> wrote in message
news:A58F9373-EFBA-4426-A2CB-2E14328B18B9@.microsoft.com...
> Hello All,
> I have a job that consist of over 120 steps. I was able to setup it in
Enterprise Manager and run it. However, the job history can only show
display 100 job steps 20 other job steps were missing. Is there a limit set
on sysjobhistory table or am I looking at the wrong table? Please advice.
> Thanks.
> David

Issue with Index for Temp Table

Hi,
I have created a SP which uses # temp table.
i created Index for this temp table. The issue is first time when i run the sp it is slow and if i run seccond time the same sp with the same range as previous one the speed increases drastically.
has anybody encountered same problem.
can u pls help

TIAThe most likely answer is that on the first call the server has to load all of the requested data from the hard drives. on the 2nd call the data is most likely in the data cache for SQL server, in the drive array controller cache or some combination of both.

There is all so a procedure cach. If the proc hasn't been run recently SQL Server might have to load the code from the hard drives, on the 2nd call the proc is probably still in the procedure cache.

Issue with exporting to pdf

Hello,

I have a report that has some text with Chinese characters. When I run the report those Chinese characters are displayed perfectly on the screen. However, when I export the report to pdf instead of the Chinese characters question marks (?) are displayed. Any ideas what can I do so that the Chinese characters are displayed when exported to pdf?

Thank you.

Hi eleanagb80, may I ask how did you get the chinese characters displayed perfectly on screen?

What setting do you have in your SQL and reporting services?

Thanks

|||

This question has come up before.

I am not sure what the pdf settings are (when they generate the file, I mean). So I have to ask: when you look in the document properties in Adobe reader, under the File menu, do you see the font mappings you expect?

Also, were the fonts you used in the report True Type, or not? Were they Unicode, or not?

One thing: when they display on your screen, characters are displaying in your browser and some additional good stuff is going on client-side.

When they display in a PDF, the fonts are either embedded when the file is generated on the server or fonts are indicated but not embedded, or a subset of the characters in the font can be embedded. I really don't know how the RS generation process decides to do it, and if it's a subset how they decide what the subset is. I haven't done any tests with this.

IAC... if the fonts are embedded, then a lot depends on what was available on the server versus what fonts or font-mappings are available on the client, which is what matters to the browser/HTML presentation.

I know I'm not giving you a solution, just trying to help you see why there can be difference.

>L<

Issue with exporting to pdf

Hello,

I have a report that has some text with Chinese characters. When I run the report those Chinese characters are displayed perfectly on the screen. However, when I export the report to pdf instead of the Chinese characters question marks (?) are displayed. Any ideas what can I do so that the Chinese characters are displayed when exported to pdf?

Thank you.

Hi eleanagb80, may I ask how did you get the chinese characters displayed perfectly on screen?

What setting do you have in your SQL and reporting services?

Thanks

|||

This question has come up before.

I am not sure what the pdf settings are (when they generate the file, I mean). So I have to ask: when you look in the document properties in Adobe reader, under the File menu, do you see the font mappings you expect?

Also, were the fonts you used in the report True Type, or not? Were they Unicode, or not?

One thing: when they display on your screen, characters are displaying in your browser and some additional good stuff is going on client-side.

When they display in a PDF, the fonts are either embedded when the file is generated on the server or fonts are indicated but not embedded, or a subset of the characters in the font can be embedded. I really don't know how the RS generation process decides to do it, and if it's a subset how they decide what the subset is. I haven't done any tests with this.

IAC... if the fonts are embedded, then a lot depends on what was available on the server versus what fonts or font-mappings are available on the client, which is what matters to the browser/HTML presentation.

I know I'm not giving you a solution, just trying to help you see why there can be difference.

>L<

Issue programatically building oledbTransformation.

I get the following validation error when i run a package which contains an OledbTransformation.

The external metadata column collection is out of synchronization with the data source columns.
The column "Param_0" needs to be updated in the external metadata column collection.
The column "Param_1" needs to be updated in the external metadata column collection.

Please advice as to how to add the external columns of oledbTransformation to external meatadata and map them to the input columns programatically using C#.

Please stop starting new threads for the same issue.

Issue accessing RS from a VB.NET app using HTML

At or around December 16th, 2005 the RS Server began having "Internal
issues". In my VB.net application, when someone wants to run a report
they simply click on a button, choose their parameters for the report,
then generate the report by clicking on another button. This sends the
HTML to the RS Server (same box) with the parameters in a query string.
This process worked flawlessly from June until mid December.
My guess is that a Microsoft update tightened security and
inadvertently stopped my app and RS from talking to each other. I can
run the reports from Report Manager, but I can no longer send requests
via HTML.
ADDITIONALLY (different issue?), internal to my company we've had an
issue from December 16th or there about where subscriptions just
stopped sending RS reports out. Anyone have any ideas' Thanks.The error message I received is below:
Reporting Services Error
----
An unexpected error occurred in Report Processing. (rsInternalError)
Get Online Help
?
----
Microsoft Reporting Services|||what version of RS are you using? If its the eval version it expires
after a certain time period and I think you get this error in this
case, I have had it on my machine once or twice.
If you go to the RS server manager it should tell you if it has expired|||Not an evaluation edition problem.

Isqlw.exe

I am having an awfull time trying to get my code to run in ISQLW
This is the code

call isqlw -S scrbbususcnc01 -d master -U jdionne -P ttttttt -Q "Exec xp_sendmail 'eddens, david; dionne, jim', '(scrbbususcnc01) Success - JOC Loaded LineMkt Support Tables', @.subject = '(scrbbususcnc01) Success - JOC Loaded LineMkt Support Tables'" -o \\scrbbususcnc01\Maersk_DW\RKMS\logs\TestIncrement al.log -s "|"

Every time i run this I get a window listing all of the switches for isql and the -Q is not listed. Can someone please send me some insight on this.
JimSounds like you want OSQL, instead of ISQL. ISQLW is Query Analyzer. Bit too graphical a tool, I think to be commandline friendly. You may want to edit out your password, too.|||Originally posted by MCrowley
Sounds like you want OSQL, instead of ISQL. ISQLW is Query Analyzer. Bit too graphical a tool, I think to be commandline friendly. You may want to edit out your password, too.

using isql did the job
Thanx