Search results for query: *

Hi all, In my workplace, we very frequently tale backup of the SQL Server Error Logs. As a result, the only messages visible in 'SQL Server Logs' window are the messages indicating where the .trn files are saved. I suppose there is no easy way to view the .trn files. Is it true that the...

Hi all, I am using SharePoint 2010. I used the Project Tracking template to create a site. It has a Projects list and a Tasks list. I created a KPI that uses Hours as actual and PlannedHours as Target. These two columns belong to Tasks list. I created a Filter with Tasks as datasource...

Hi All, I have an HTML table with Book-Name in first column and a link in the last column. The link opens a new window, which displays a report on the book. The report is prepared by an asp.net page called Report.aspx When user clicks on a link, the widow opens, and works fine. If user clicks...

Hi all, I have a very simple stored proc: SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER procedure MyProc as Begin Tran Insert into myTbl(....) Values(....) Commit Tran This is called repeatedly from a multi-user application to insert over a thousand rows at one go. Sometimes (once in...

Hi all, I have a simple Update statement that goes like this: Update <Tablename> Set <Columnname> = 0.00 Where .... The Column is of Float type, and is set to Null, instead of zero when I call this statement from my application. Why does that happen? How do I set it to zero? TIA, Sheila

Hi all, I have this situation. One employee had sent out meeting-invites to a group of employees, and the sender has now left the company. I need to write an application that can delete the meeting invites from the Calendars of each employee of that group. Can I use EWS to accomplish this...

Hi all, I have an Asp.Net site that uses out of the box Ajax functionality (Script Manager, Update Panel and a few simple server-controls.) This site has been working fine. Now I need to open this site in a browser that is embebed in another desktop application's form, and when I click on a...

Hi all, I want to use JavaScript in my OutlookToday page (which gets shown inside Outlook explorer). In the document's load event I call the javascript function: <script language="javascript" type="text/javascript"> function InvokeJS() { var outlookApp = new...

Hi all, I am trying to run a Visual Studio 2005 Web-project on my machine (Win-7) that is working well on all other developers' machines. The application fetches data and displays a report. It has a class that extends this class: CrystalDecisions.CrystalReports.Engine.ReportDocument On my...

Hi all, I am adding an extra row into the header using following code: GridViewRow row = new GridViewRow(-1, -1, DataControlRowType.Header, DataControlRowState.Normal ); TableCell cel = new TableHeaderCell(); cel.ColumnSpan = 2; row.Cells.Add(cel); System.Web.UI.WebControls.Table t =...

Hi all, C# now has nullables. If I have declared a nullable variable, and its value is null, then what is stored in it? int? x; I was asked this question in an interview, and I am puzzled. TIA, Sheila

Hi all, The article here shows a 'bad' example of code that breaks the LSP: http://davidhayden.com/blog/dave/archive/2005/06/10/1226.aspx The code is: public class Rectangle { protected int _width; protected int _height; public int Width { get { return _width; }...

Hi all, I have a Stored Procedure that runs in less than a second when there is no load on the database. But when just a few queries are fired, this Procedure takes as much as 30 seconds. The procedure queries three tables. It's a CLR Procedure and uses Regex. I use (NOLOCK) in all my queries...

Hi All, My Stored Proc is returning results in about 20 milliseconds. Should I be placing an Index on the table that this SP is querying? What is the duration that I can use as a benchmark, beyond which I should start adding Indexes to tables? TIA, Sheila

Hi All, I have a Stored Procedure that takes 15 seconds when I run it the first time in Management Studio. Then onwards it takes only a fraction of a second each time it is called. What could be the reason for this? Is there a way to find out where the time was spent by the Stored Proc during...

Hi All, I have been creating a database for an application. Now that it's ready, I need to create SQL Server Management studio solution for it, and add to TFS. Can anyone please send me some pointers on how this is done? TIA, Sheila

Hi All, I am new to Database admin work. I have a database by name [TestDB] on my development machine, and am trying to move it to Staging machine. I took its backup, copied it to Staging machine, and ran this command. RESTORE DATABASE [AcmeDB] FROM DISK = 'C:\TestDB_4_14.bak' I notice that...

Hi All, I am new to Database admin work. I have a database by name [TestDB] on my development machine, and am trying to move it to Staging machine. I took its backup, copied it to Staging machine, and ran this command. RESTORE DATABASE [AcmeDB] FROM DISK = 'C:\TestDB_4_14.bak' I notice that...

Hi all, I have to write Data Access Layer, with methods that will invoke stored procedures. I am thinking that if I write a method that accepts variable number of parameters and the procedure name, it will be able to call any stored proc. Something like this: public DataSet...

Hi All, I am generating a Word document from contents in an XML file. An XSLT converts the XML to WordML and saves as a Word HTML file, and then I open that HTML file with Word, and save it as a Doc file. It works fine except when the content includes special characters that are not in...