Query Viewer

Jun 28, 2007

Is there a log or some other tool available in SQL Server 2005 that allows you to see the queries that are being run against the server real-time?

View 5 Replies


ADVERTISEMENT

Reporting Services :: Report Viewer Export To Xlsx Query

Jun 25, 2015

I was wondering on a question that : exporting a report to xlsx is feature of SSRS server or of Report viewer control itself.I have multiple report servers (eg 2008 R2, 2012 and 2014) . I am using a windows application and reportviewer version 9.0.So when I use report server 2008 R2 its not showing the xlsx export option but working fine with other report servers.Again I changed the control to 11.0 (also 12.0) and checked the same scenario and same results with Reporting server 2008 R2 but working fine with 2012 and 2014. if its worth to change the Report Viewer control or just changing the server is okay to achieve the functionality of exporting to xlsx.

View 6 Replies View Related

Query Or Script To Get The Event Viewer Event Properties?

Nov 2, 2007



Hi all,


Can we get the event properties by using a query?
Are there any extended stored procuder to get the above?

Scenario:

>Desktop>Right Click on My Computer
>Go to Manage and click
>Expand System Tools
>Expand Event Viewer
>Application

click on one event.We can get the log info which is the manual procudure.

But now i want to get the event properties through the Query analyzer...

Any help would be great?


Thanks,

View 4 Replies View Related

Event Viewer

Feb 1, 2002

I tried to save an event viewer file as a .txt format file and when I open the saved file, it's not readable.

Can someone have an idea of what format should I save the event viewer file so I will be able to view it's contents?

Thanks in advance!!

View 2 Replies View Related

Dependency Net Viewer

Nov 29, 2006

Hi,

I've got a Decision Tree model and I'm trying to browse the dependency network. Apparently, there are too many nodes and they don't all show up in the view. I know that I can find hidden nodes, but is there a way to show all w/o having to add them one by one to view? How does the UI determine which ones to filter out?

Thanks,

Mike

View 1 Replies View Related

Custom Log Viewer

Jan 23, 2008



Hi all,

I would like to create my own log viewer to monitor package execution, on top of using regular logging features such as saving log events to an SQL Server 2005 database. My package is programatically generated and contains more than 100 control flows and I would like to see the progress using an "execution manager" client, that manages packages generation and execution.

What programmability interfaces does SSIS offer in terms of building a custom suscriber component and receiving log events from that component?

I come from the COM world and this would probably be done through ConnectionPoints by using COM directly. However, I am working with C# now and I am certain that there is a more modern way to do this !

Thanks





View 1 Replies View Related

Report Viewer

Aug 24, 2007



I am looking for capturing Report viewer events on the web form. Can anyone tell me how to fo this?
Thanks,
S Suresh

View 3 Replies View Related

Report Viewer In .DOT NET 3.5

Apr 22, 2008



Hi all,


is it possible to use ReportViewer control in project Windows Application (WPF) in msvs2008,which uses .DOT NET 3.5? I need to run ReportViewer component under xaml but I don't know how / or is it possible?

thanks for every helpful reply


sample:

<Window x:Class="WindowsApplication2.Window1"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
Title="WindowsApplication2" Height="329" Width="533"
>
<Grid>

</Grid>
</Window>

Thanks ,
ashok

View 3 Replies View Related

Event Viewer Errors

Jan 7, 2005

My boss has now decided that he doesnt want to see SQL errors in the event viewer, unless they are actual errors.

The two errors are:
A - When the DB log is truncated it goes into the event viewer as an error. This needs to either not go into the event viewer at all, or be classed as something other than an error.

B - "Sqllib error: Database x is not simple." This one I dont even know what causes it, but the same thing applies, either it shouldnt be logged, or it needs to be logged as something other than an error. Although what does cause this message?

Any help on these would be appresiated

Thanks :)

View 3 Replies View Related

Event Viewer Msg Thrown For Ms Sql

Apr 10, 2006

Hi guys

i am puzzled on how to decipher the below msg on my sql server
Had tried adjusting the settings but apparantly doesnt work

is this due to my license or what other reasons?

Error msg:
17052 :
This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 30 queries and performance may be adversely affected.


sql server : MS SQL Enterprise 8.0

View 1 Replies View Related

Error In Event Viewer

Apr 14, 2004

Hi I am getting the following error:

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Date: 4/14/2004
Time: 09:32:05 AM
User: SYSTEM
Computer: BSEW2k01
Description:
Error: 50000, Severity: 5, State: 1
Error Calling StatusToStreet In DCS0 Code 7202

Please help.

Thanks

View 2 Replies View Related

Error With Report Viewer

Feb 15, 2008

Hi, I am getting the following error when I try to open up my web application now, after installing the report viewer add on and placing it onto one of my pages.


Parser Error Message: Could not load file or assembly 'Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=nutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system could not find the file specified.

Source Error:
Line 47: <add assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />

Source File: web.config


So far I have tried to fix this error by installing the reportviewer.exe on the server. I have also verified that the ReportViewer files are in the assembly folder on the server. I also found a site saying to run the reportviewer.exe from a specific location, here is the link

http://dotnetslackers.com/_NET/re-49414_Could_not_load_file_or_assembly_Microsoft_ReportViewer_WebForms.aspx

but when I try to browse to the folder it is talking about I found out that I don't even have a BootStrapper folder under Microsoft Visual Studio 8/SDK/v2.0

Does anyone have any ideas on how to fix this error?

View 1 Replies View Related

Favicon In Report Viewer?

Apr 26, 2007

I understand this may be Off Topic for this board, but has anyone figured out how to add a Favicon to the Report Viewer?

View 1 Replies View Related

Scroll Bar In Report Viewer

Oct 16, 2007



How can i show scroll bar in winform report viewer.?
I have set Auscroll = true..
But that didnt effect

View 1 Replies View Related

Tree Viewer Error

Sep 13, 2007



I have successfully created and processed a mining structure (decision tree). However, when I try to generate the tree graph, I am getting the following error:

TITLE: Microsoft Visual Studio
------------------------------
The tree graph cannot be created because of the following error:
'Object reference not set to an instance of an object.'.
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.762&EvtSrc=Microsoft.AnalysisServices.Viewers.SR&EvtID=ErrorCreateGraphFailed&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
Object reference not set to an instance of an object. (Microsoft.AnalysisServices.Viewers)
------------------------------
BUTTONS:
OK
------------------------------

...with the following technical details

===================================
The tree graph cannot be created because of the following error:
'Object reference not set to an instance of an object.'. (Microsoft Visual Studio)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.762&EvtSrc=Microsoft.AnalysisServices.Viewers.SR&EvtID=ErrorCreateGraphFailed&LinkId=20476
===================================
Object reference not set to an instance of an object. (Microsoft.AnalysisServices.Viewers)
------------------------------
Program Location:
at Microsoft.AnalysisServices.Viewers.TreeViewerBase.GetTooltipText(TreeGraphNode treeNode)
at Microsoft.AnalysisServices.Viewers.TreeViewerBase.predictionTreeComboBox_SelectedIndexAction()
Has anyone encountered this same error?

View 1 Replies View Related

Report Viewer 2008

Jan 13, 2008

Can anyone tell me what new functionality is introduced with the 2008 version of Report Viewer (download here). As usual, Microsoft have published the new version, but without any release notes - this is very frustrating.

Is it just for compatibility with SQL Server 2008, or does it actually fix bugs (of which there are many) or introduce new features?

I wish Microsoft would improve their introduction of updates, such that providing detailed release notes was standard practice.

Thanks,

Nick

View 3 Replies View Related

Version Of Report Viewer

Mar 10, 2008



Can anyone tell me whats the latest version of the Microsoft.ReportViewer.WebForms.dll for the ReportViewer redistributable sp?
How do we find the version of dll file which is already installed in my machine?

Thanks


View 1 Replies View Related

Report Viewer Not Available In VB Express?

Apr 14, 2006

I'm trying to use report viewer controls, but the controls do not appear in the toolbox. The file reportviewer.exe was not in the location specified in the help files, but I have downloaded it, and when I try to add it to the toolbox, I get the message 'ReportViewer.exe' is not a .Net module. Should there be a .dll somewhere? Is it not possible to use this control w/ VB Express / SQLExpress?

View 1 Replies View Related

RS Viewer Not Showing Font

Feb 6, 2008



Hi all,

We are currently using reporting services to display reports in our application.
Amongst the reports there is one that shows barcodes (using an idautomation font).

We've installed the font on every pc that uses the software, and it works on all but 4.

Now we've checked the following:

The user signs in on another pc and it works. So not user related
The user uses the font in a word document. So nothing wrong with the font itself.

Does anyone have any other ideas?

I would appreciate it.
Tobias

View 4 Replies View Related

Do We Have DataMining Viewer As Web Control??

Feb 1, 2008



The mining model viewer which comes with DM-Add in's works fine with Excel and also in Windows applications with the following code.

MIningModelViewerControl viewer = null;
MiningModel model=null;
MiningService service=null;

conn.ConnectionString = ConnectionString;
conn.Open();

model = conn.MiningModels[modelName];
service=conn.MiningServices[model.Algorithm];

if (services.ViewerType == "Microsoft_Cluster_Viewer")
viewer = new ClusterViewer();
else if (services.ViewerType =="Microsoft_Tree_Viewer")
viewer = new TreeViewer();
else if (services.ViewerType == "Microsoft_TimeSeries_Viewer")
viewer = new TimeSeriesViewer();

viewer.connectionString=ConnectionString;
viewer.miningmodelname=modename;
viewer.Dock = DockStyle.Fill;
panel.controls.add(viewer);
viewer.LoadViewerData(null);


But i need that as a web contorl to integrate with our existing web application but the viewer control is not working.
So is there another web control for viewing data mining models.

Regards,
Swarna

View 3 Replies View Related

Report Viewer Redistribution

May 14, 2007

I am creating a .NET WinForm app and would like to include the files required for the ReportViewer component (SP1). Can someone tell me where I can find these files? Also, can I simply drop these files in the folder where the rest of my app is going to reside, or does an installation have to take place?



Thanks - Amos.

View 7 Replies View Related

Can I Have A Checkbox In My Report Viewer

Jan 15, 2008

Hi,
I have a order form and i want to take it to the next level.. So i have a report in my reportserver is exceuted using a sproc. I am using an Report viewer to view the report in my web application.
So is it possible to have 2 - 3 check boxes that will populate thru the webapplication, in my report viewer and still use the report from the report server.. For eg.
The data in my report will looks like this


OrderNo PlanId PlanName ... ETc
chkbox 45 15 ABD
chkbox 46 75 BDA


any help will be appreciated.

Regards
Karen

View 4 Replies View Related

Specify Two Different Servers/databases For SQL Report Viewer

Apr 25, 2008

I'm working with the SQL Report Viewer in VS2k5. In the Data tab, where the Dataset drop down list is, I click the "..." to edit the dataset. I am currently using the following for the datasource...
   Data Source=ServerName;Initial Catalog=DatabaseName
In one database, I store an employee ID number. I need to access a different database on a different server to reference the employee ID and pull the employee's name. Is there a way to specify two different databases on two different servers in the connection string above?
Thanks!

View 1 Replies View Related

Write To Windows NT Event Viewer

Mar 19, 2001

Hi for everyone!
I need any example to use raise error that write into event Viewer I use WITH LOG directive
but it's no success.
Sincerely.
FAin Boris

View 2 Replies View Related

Warning Message In The Event Viewer

Jun 7, 2001

Hi

Can anyone tell me what this warning message in the Quotes below...
I get this on one of our servers every 15 minutes in the event Viewer..

Here is the message in the event Viewer..
"Replication of license information failed because the License Logging Service on server PSNJRPDC could not be contacted."

Thanks All,
Venu

View 1 Replies View Related

SQL 6.5 Vs. SQL 7 - Username Missing In Event Viewer

Mar 24, 1999

Hello Everyone:

I'm in the process of verifying that all functionality in a version 6.5 database is still there in SQL 7.0. After the upgrade, one issue seems different.

When I attach to a SQL 6.5 database, the full username used in the connection is displayed in the Windows NT Event Viewer. But when I attach to the same database in SQL 7, the username shows up in the Event Viewer as 'N/A'. I've verified that audit permissions are set the same on both boxes both under SQL and in User Manager. Any ideas??

View 1 Replies View Related

Event VIEWER ---ERROR Message

Mar 6, 2001

Hi All,

I see this error message on one of my servers Event Viewer..Can anyon tell me what it means and how to resolve it..

The library file "C:WINNTSystem32BEPerfDll.dll" specified for the "Backup Exec" service could not be opened. Performance data for this service will not be available. Status code is data DWORD 0.

Thanks,
Venu

View 1 Replies View Related

Exporting Event Viewer Logs To Db..

Jul 14, 2004

l am trying to see how to export event veiwer log to database(mssql) and incremental updates.

sql MS server and with window 2000
if anyone knows how to do this in .net or third party software pls let me know.

View 1 Replies View Related

EXCEPTION_ACCESS_VIOLATION: Odd Error In Event Viewer

Jul 23, 2005

I have a stored procedure that I use for call a aspx page from within SQL. The stored procedure itself runs finewith no errors but I keep getting errors in the event viewer everytimeit runs (with .vbs, .NET, .vb6 client) outside Enterprise manager or SQL Query Analyzer.....This is error:Error: 0, Severity: 19, State: 0SqlDumpExceptionHandler: Process 52 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.I think that this is the same problem seen inhttp://www.sqlmonster.com/Uwe/Forum...in-Event-ViewerI've test with XP sp2, W2003 server, SQL 2000 sp3a......on the same machine.ANY SUGGESTIONS??????Thanks--Message posted via http://www.sqlmonster.com

View 3 Replies View Related

Report Viewer Drilldown Oddity

May 22, 2007

I have two servers running the same report server project with the same webapplication front end.



Both instances of SQL are on SP2.



When I drilldown in the report viewer on server A, and click next page it returns to the parent report. (which obviously it should go to the next page of the current report) Sometimes this odd behavior happens and sometimes it doesn't.



However on server B, everything works fine.



Note: the installation on server A went a littly crazy. Am I missing a service pack that would have fixed this?

View 1 Replies View Related

Report Viewer Webpart Did Not Work In Wss 3.0

Dec 28, 2006

Hi,

I just installed a fresh lab machine with WSS 3.0 and SQL 2005. I registered the RS web parts.

In the home page I added the Reports Explorer and the Report viewer web parts. I set up the Reports Explorer and the list of reports are showed.

When I connect the Report Viewer Web part to get report from the Report Explorer web part I get the maintenance WSS page. I have to delete the Report Viewer web part to have the page working again.

If I use only the Reports Viewer with a report (not connected to Reports Explorer) is working just fine.

Any ideas what could be the problem? Any hints on how to investigate this is also much appreciated.

Thanks,

Dan

View 4 Replies View Related

Problem When Viewing Reports With The Viewer

Dec 20, 2006

I've made some reports using the Report Designer. When i run them in the Report Designer everything is correct. Then in my webpage i have links to launch the same reports. The viewer is launching the report using the HTML4.0 format parameter in the URL.
In the viewer my report is so ugly. Some textbox doesn't have the same height, other are not align correctly. What i don't understand is if i tried to print the report or export it in PDF or in TIFF everything is ok. I only have the problem when i tried to view the report using the viewer with the HTML4.0 parameter.

So is this a problem with the viewer ? Is there something i can do to correct this problem ?

Thanks !

View 1 Replies View Related

Export Data To PDF From Report Viewer!

May 24, 2007

Hi,



I use the export option from the report viewer, I have problem that when it export, the width is too long and it wrap to next page. Is there anyway that i can set it to lanscape format before it export to pdf file?



Thanks



Ddee

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved