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...

I see the windows open, and wait for the previous window to finish.

JAG14, I am transferring with the standard javascript call in the OnClick event of hyperlink. jmeckley, I am using VS 2005. No, I haven't monitored the system using IIS. Is there anything particular you suggest I monitor? The box is having Quad CPU Q9550. Thanks for your replies, Sheila

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...

Thanks, markros. This article is really good at making me think. Thanks, Simon. I have now added C# code to log the state, and am waiting for the culprit. I'll update this thread when I settle this issue. Thanks again, Sheila

SimonSellick, No :( Unfortunately the failure occurs silently, and seldom. I made sure that the parameters being passed are formatted properly so the DB won't reject them. e.g. the float and date params are in format that the DB expects. Thanks, Sheila

No, there is no nested transaction involved in this case. The C# code calling this proc uses this call: command.ExecuteNonQuery(); Thanks again, Sheila

Hi Markos, >>If there is another transaction opened and that transaction is rollbacked... I didn't understand your comment. Do you mean some other stored proc is affecting this proc? >>Also,...why do you need to wrap it in transaction? I don't think I need to. This is old code, with this...

No, there are no triggers in the database. I also ran a profiler while the users were using the application, and saw the calls being made. The data being sent to the proc seemed perfectly normal and well formatted. Thanks, Sheila

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...

I am very sorry guys. There was actually no issue with this statement. The Stored proc is very long, so I couldn't post it here. The issue was with another statement in the Proc, that was resetting the value to null. Thank you all, and very sorry for the trouble. Sheila

There are no input params to the Stored Proc. The actual statement that does the update is this: Update Acc_Book Set Funding = convert(float, 0.00) WHERE Book = @Book and CloseDate = DateAdd(day, -1, DateAdd( month, DateDiff(month , 0, @CloseDate)+2 , 0) ) @Book is varchar(100)...

If the [Passed Scripts] is of Int type, I think SQL uses that type for the result. So if your result is a fraction, it gets a value of zero.

Guys, the application is NOT passing any values to the stored proc. The stored proc has this update statement, which gets called when certain condition is true. The SP runs correctly otherwise, but instead of replacing any other float value with zero, it replaces it with a NULL.

One more thing: If I call the Stored proc from Management Studio, it works fine, and saves zeros correctly. But when called from application it saves NULL.

Thanks for your replies guys. No, I don't have any triggers on that table. The calling program is not passing the zero value to the statement. The SQL statement is in a Stored procedure, updating the value for a single row and single float-type column. I also tried using this: Update...

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

>>Or has this got to be done quietly? That's correct. They are looking for a solution where that account is not used.

No, the mailbox of the person who has left the company hasn't been deleted.