Search results for query: *

Hi All, I have a WCF service hosted in windows and a thick client communicating with it. I have been experiencing timeouts on certain calls as well as the following Warning in the event viewer: Error invoking subscriber. Method = <Method Name> Error details =...

Hello Everyone, I have a winforms application (barebones) that I developed using VS2008/.Net2.0/WinXP. This is intended to be a prototype. The application also uses interop to communicate with a couple of legacy COM components. Everything works fine. When I copy the files over to...

Hi All, I am trying to resolve some memory issues for some workstations in my company and using Process Explorer(tool from SysInternals). I am trying to understand some of the numbers that the tool uses: 1) Physical Usage - this is a number which is shown in the the status bar(bottom of the...

Is there any way to recover a deleted stored procedure in SQL Server? Unfortunately I do not have any back up of this particular database. Thanks so much everyone. R

Hi All, This might not be the most appropriate forum for this post but I am still giving it a shot. We are a mid sized development shop and will be working with multiple clients having different requirements for the same software. As a result, it is very important for us to maintain different...

Hi Guys, Either with mirroring or replication, is it possible to have different file structures in the primary and secondary servers? By this I mean, there might be 2 filegroups in the first server with tables allocated amongst those groups and possibly 4 filegroups in the secondary server...

Hi Guys, We are trying to decrease the downtime for our enterprise applications. I would welcome ideas from all of you on how you do database upgrades(application upgrades not system upgrades like service packs etc.) while minimizing downtimes. Is there any way you can have your users using...

Hi All, I was doing a select from dm_db_index_physical_stats view from our production server. Each entry has an object_id but when I try to convert them to object_name then I see the values as null. Any ideas? Thanks A Example Object Name Object ID Index Id index desctipion NULL...

Hi All, I am having a weird issue. I have overnite database optimization jobs which do re-indexing(we do reorgs as opposed to rebuilds). What I have seen lately is that the fragmentation does not decrease to the extent it should in case of a set of tables. For eg. if before the job...

Hi Guys, We have a SQL 2005 server hosting multiple databases and serving number of web applications(located on a separate web server) as well as windows applications. At any moment of time, there are normally 100-200 users. We see the number of user connections rise as time passes(from the...

Hi Guys, I have a stored procedure that runs as a job. It is complex and calls multiple SPs from within it. I have been facing the above error from about couple of days back when it executes. It hangs as it tries to select records from a table before trying to do a row processing. The...

Hi All, Any idea what this error is about : "The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction." Thanks A

Hi Guys, Any idea of what this error might mean:: ---------------------------------------------------------- Server: Msg 6522, Level 16, State 1, Procedure [S. proc name], Line 0 A .NET Framework error occurred during execution of user-defined routine or aggregate "[S. Proc Name]"...

Hi Guys, Here is a problem I am trying to solve and keep running into roadblocks: I need to access information from two SQL Servers(physically separate servers), merge the results and send them to the client. I would prefer to code this as a SQL Server process if possible. I am allowed to...

Hi Guys, I recently installed SQL Server 2005 but cannot access it from the network. All help is appreciated. R Following is the text of the error message. Unable to connect to server Server Msg 11,Level 16, State 1 [Microsoft][ODBC SQL SERVER Driver][DBNET]General Network Error. Check...

Hi Everybody, I am getting a weird error - "Unable to deallocate a kept page!" when executing Stored Procedures on a SQL 2005 box. This happens randomly. I have looked around and could not find any information on this. If anyone has any information on this issue, it will be great if you can...

Hi Guys, I have a general performance question. We are in the process of building an application which requires a lot of SQL Server processing on incoming data before clients can use it. Incoming data is actually stored in a table. This data can be processed in two ways - 1) have a trigger...

Hi, In winform control, we have code to execute both on the Mouse_Click and Mouse_DoubleClick events but Mouse_Click event fires when user does a double click. Has anyone come across this issue and how it can be solved? All help, as always, is appreciated. A

Hi Guys, Not sure if I should put this in the C# forum. Was looking for ADO.Net or .Net2.0 but could not find any. Anyways, here is my problem: Desired Effect: I have a database table with some data and a win-client app which uses SQLDependency to subscribe to changes in the database...

Hi Guys, I have a question and am not sure if this is the right forum. I am going to post it anyways and let you respond. Problem:: We are developing an application that almost works on the concept of an Email Inbox. A user has a Windows Client which displays a worklist. The worklist is...