.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

manual trace using sp_trace_create shows nothing .Shows all the events captured only when SQL Server

Posted By:      Posted Date: October 11, 2010    Points: 0   Category :Sql Server

has anyone faced this .I am creating manual trace for login failed events in SQL Server 2000 SP4 x86 :

-- Create a Queue
declare @rc int
declare @TraceID int
declare @maxfilesize bigint
set @maxfilesize = 5
exec @rc = sp_trace_create @TraceID output, 2, N'C:\temp\Failed_Logins', @maxfilesize, NULL
if (@rc != 0) goto error

-- Client side File and Table cannot be scripted

-- Set the events
declare @on bit
set @on = 1
exec sp_trace_setevent @TraceID, 20, 7, @on
exec sp_trace_setevent @TraceID, 20, 23, @on
exec sp_trace_setevent @TraceID, 20, 31, @on
exec sp_trace_setevent @TraceID, 20, 8, @on
exec sp_trace_setevent @TraceID, 20, 12, @on
exec sp_trace_setevent @TraceID, 20, 60, @on
exec sp_trace_setevent @TraceID, 20, 64, @on
exec sp_trace_setevent @TraceID, 20, 1, @on
exec sp_trace_setevent @TraceID, 20, 9, @on
exec sp_trace_setevent @TraceID, 20, 21, @on
exec sp_trace_setevent @TraceID, 20, 49, @on
exec sp_trace_setevent @TraceID, 20, 6, @on
exec sp_trace_setevent @TraceID, 20, 10, @on
exec sp_trace_setevent @TraceID, 20, 14, @on
exec sp_trace_setevent @TraceID, 20, 26, @on
exec sp_trace_setevent @TraceID, 20, 3, @on
exec sp_trace_setevent @TraceID, 20, 11, @on
exec sp_trace_setevent @TraceID, 20, 35, @on
exec sp_trace_

View Complete Post

More Related Resource Links

Sharepoint Designer 2007 shows Server timed out



When i try to open a sharepoint site (WSS 3.0) in Sharepoint Designer 2007. It shows a message "Server Timed out". Does anybody know why is it happening. Please help me.

Thanks in advance.

Calendar does not print events, Print preview shows blank calendar


We are running SharePoint 2010 and when I do a print preview of a Calendar web part the preview shows a blank Calendar with no events, when I print there are no events printed either.  This is from a PC running Windows XP SP3 and IE7.  When I preview and print from the same computer using FireFox 3.6.10 the events are visible and print.

Since not all of our users have FireFox I need to find a way to get calendar printing to work from IE7.

Report shows correctly when viewed from report server, but not at all when viewed from DB server



I've set up SQL Server 2008 R2 on a Windows 2008 server ("SQLDB").  It includes the Reporting Services databases from the SSRS 2008 R2 files-only installation, also on Windows 2008 server ("SQLRS").  The problem I'm having is that reports are rendering when viewed on the report server SQLRS, but not when viewed on the SQL Server SQLDB via the same URL.  The error message is:

"An error has occurred during reporting processing. (rsProcessingAborted)  Cannot create a connection to data source 'SourceDB'. (rsErrorOpeningConnection)  For more information about this error navigate to the report server on the local server machine, or enable remote errors"

In Report Services Manager, I've added my login in "Site Settings" and assigned my login System Administrator and System User roles.  In Report Services Home folder, I've assigned all roles to my user account: Browser, Content Manager, My Reports, Publisher, and Report Builder.  In SQL Server, I've given my login execute permissions to all report stored procedures.

Assuming I'm logged into SQLDB with my regular login, shouldn't I be able to run the report server app and view the reports as if I were running the report server app as myself on SQLRS?


Job executes unsuccessfully but SQL server 2005 shows execution successful....


I have a job which imports txt file in table. I get following error when it executes bulk insert. The file doesn't get imported but SQL server job history shows the successful execution?

"The OLE DB provider "BULK" for linked server "(null)" reported an error. The  provider did not give any information about the error. Msg 7330, Level 16, State 2, Server "

Please advice me on this?


Problem deploying custom report item. Items shows in preview screen in VS, but not in server deploye


I have developed a custom report item that works fine in design and preview mode while in Visual Studio. I cannot get it to show up on my deployed reports. Here's what I have done so far:

1. Deployed the report using Visual Studio

2. updated the rsreportserver.config file with the following entry:

      <ReportItem Name="PedigreeChart" Type="Uabr.Rap.PedigreeChart.PedigreeChartRenderer, Uabr.Rap.PedigreeChart" />

3. Updated the rssrvpolicy.config file with the following entry.

                    Description="This code group grants Uabr.Rap.PedigreeChart.dll FUllTrust permission. ">
                                Url="C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin\Uabr.Rap.PedigreeChart.dll" />

I've also tried using the StrongNameMembershipCondition

Date picker shows "Server Error"

Out of the blue, the standard date picker in default SP forms (not InfoPath) show a server error instead of the current date in a month view. Anyone seen this before?

Linked server config shows no Oracle provider



In a process to config linked server on MSSQLServer2008 on WS2008R2.

Installed Oracle client 11.2, configured the variables TNS_ADMIN, ORACLE_HOME;

configured Data Sources (ODBC)- System DNS ->Oracle with Driver SQORA32.dll and have all Oracle databases in the drop down menu.


New linked server - Under provider -> there is no Oracle provider listed!?

What I'm missing here?



Build succeeded but still shows as failed.


 I am able to run a build successfully on just the web site, but when i add the deployment project it shows failed (see below) but in the details it says build succeeded for the WDP build portion...so I am stumped as to by I am getting a failure. any ideas? I have set the build output to "Diagnostic" and dont see any failures or errors...so is there anything else i can do to find the problem?


Build succeeded.

Time Elapsed 00:00:21.71
------ Skipped Rebuild All: Project: AdminToolHelp, Configuration: Debug Any CPU ------
Project not selected to build for this solution configuration
========== Rebuild All: 1 succeeded, 1 failed, 1 skipped ==========

Sharepoint site shows Service Unavailable


Hello everyon,

I am working sith WSS 3.0.

I have one webapplication with one sitecollection.Later i wanted to provide it HTTPS URL, so i extended the WebApplication with option-Yes in SSl field.

And in the virtlay directory properties -> Directory Security -> Secure communications -> Edit

selected Required Secure Chanel.

Thats it. I didn't do anything in that.


Then because of some problems , i deleted the iis website of extended webapplication from central admin.

After that when ever i try to open the site, it shows service unavailable.  And the application pool is getting disabled.

Please help me to get the site working.


Thanks in advance.


Visual Studio 2010 Shows Blank Page during web development


I just upgraded a web project from VS2008 to VS2010 Ultimate (Windows7 64bit, IE8/Google Chrome. When I run the web project in the development server (by hitting F5) everything acts like it is supposed to except everything comes up blank. Even the directory structure page is blank, just an empty HTML open and close shell. I get no errors no indications of failure, nothing. When I try to use google chrome I get the same blank page no matter where I navigate to, even if I try to navigate to a non-existant location on the dev server. I know the code compiles and acts correctly because I can deploy it to our QA servers without issue. Any ideas? 

"Only their own" allows users to edit, then shows access denied page

I am managing a WSS 3.0 portal.  I have created custom lists where a group has contribute permissions.  Under List Settings|Advanced Settings, when I set Edit Access to "Only their own" or "None", my test users can see the Edit Icon and the Edit Item menu option, and bring up the Edit Form.  When they click "OK", they get the Access Denied page.  My experience in that past is that they should not even been shown the option to edit, and they should get Access Denied if they somehow navigate to the EditForm.aspx page.  I even tested this on a brand new site, with three Links lists, each with different Edit Access Levels (All, None, Only their own).  I added one user with contribute permissions.  He had the same result: He could get all the way to EditForm.aspx, but got "Access Denied" when he submitted his changes.  What can I do to fix this?Christopher W. Douglas

TextBox shows binding source text when window load, so why not with the ComboBox?

How can I get a ComboBox to show the binding source value when my window opens?  I have been searching all day for a solution to this, but cannot find anything.  So I have created a sample project to demonstrate my problem.  Below is a Vehicle class, very simple, two members Category and Make.  Category is an enumeration, Make is a string. namespace ComboExample { public class Vehicle { // Constants and enumerations public enum eCategory { Road, Air, Sea } // Attributes public eCategory Category { get; set; } public String Make { get; set; } // Construction public Vehicle(eCategory Category, String strMake) { this.Category = Category; this.Make = strMake; } } } Here is the C# for the MainWindow.  A new Vehicle object is created as a member.  In the constructor I set a data-provider in the XAML to this Vehicle object.  There is a button event for showing the values of the controls and objects so I can check the binding. namespace ComboExample { // Interaction logic for MainWindow.xaml public partial class MainWindow : Window { // Attributes Vehicle m_Car = new Vehicle(Vehicle.eCategory.Road, "BMW"); // Construction public MainWindow() { InitializeComponent(); // link data-p

SSMS 2008 - Shows Service Status as Stopped Though Service is started

Hi, I have a SQL Server 2008 - Active/Passive Cluster. The issue I am facing here is that, when I do a Failover from Node A to Node B, All the Cluster Services come online and the SQL Services are running (checked using the SQL Configuration Manager and Services console). However when I open the management studio, The Service status Indicator shows a Red Block mark against the ServerName and the SQL Server Agent. When I try connecting to the server remotely from another server, the status is displayed correctly in the SSMS(i.e the green sign with the arrow) .  This issue happens when I locally login to the server and connect using ssms. I am an Admin on both the boxes and even the service account with which the services run also has admin privileges. Any pointers? Thanks,

"Server Objects and Events" missing

Using in-line code in VS 2010 RC and I can't get the "server objects and Events" drop down to show up.Not sure if this is a bug or what...in VS 2005 / 2008 it would just appear at the top of in-line code files.  I've checked the options/settings menus and haven't found any way to enable it.

Excel Services XLSX shows different results when accessed via Sharepoint UX vs REST

I have an Excel services report that connects to Project Server 2010 data via an ODC.  Looks great when I view the XLSX through the browser via the Sharepoint doc library; everything refreshes, no warnings, all is good.    But when I access this same file via the Excel Services REST call: https://myserver/_vti_bin/ExcelRest.aspx/ProjectBICenter/My%20Reports/Initiative%20Status%20Report.xlsx/model/PivotTables('InitiativeStatusSummary')?$format=html I get an older version of the report -- not refreshed with the latest data.   I have the file set to "refresh data when opening the file" in the data connectioon properties.     What am I missing?

Firexfox and SharePoint Forum - a reply shows html code

When users use Firefox to view SharePoint and are replying to a post of the forum\discussion board the reply box and view box already has the HTML code in. For instance the body field contains:- <div><br/><br/><hr/> <b>From: </b>Kevin Shilling<br/> <b>Posted: </b>03 August 2010 15:17<br/> <b>Subject: </b>CHRISTMAS IS COMING...<br/><br/> <div>Yes, I know it is only August but thinking ahead what do you think about hosting our annual Open Evening for local neighbours, suppliers and friends and family. Do you think it is a good idea or not? Let me have your thoughts before the end of September when planning usually starts.</div></div> Anyone come across this and found a fix? Regards Mike
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend