Since morning I am not able to access my database. It is marked as Suspect. The server was down in the morning and when it was on , I tried to access my database. However, now I am not able to access it. I even tried searching for the .mdf file. But, I am not able to find it. The size of .mdf is in MBs. I've no latest backup of my database. Now, if I dettach the database from the server or run sp_resetStatus commnad then, the database might not get recovered. So, please help. I need to fix it asap so that I could start my work.

Since morning I am not able to access my database. It is marked as Suspect. The server was down in the morning and when it was on , I tried to access my database. However, now I am not able to access it. I even tried searching for the .mdf file. But, I am not able to find it. I've no latest backup of my database. Now, if I dettach the database from the server or run sp_resetStatus commnad then, the database might not get recovered. So, please help. I need to fix it asap so that I could start my work.

Since morning I am not able to access my database. It is marked as Suspect. The server was down in the morning and when it was on , I tried to access my database. However, now I am not able to access it. I even tried searching for the .mdf file.the size of .mdf is in MBs. But, I am not able to find it. I've no latest backup of my database. Now, if I dettach the database from the server or run sp_resetStatus commnad then, the database might not get recovered. So, please help. I need to fix it asap so that I could start my work.

Situation: There is a page where left side has a menu which is static and right side has screens according to the menu selected. If I change something on the page and without saving the content I click on the other menu. Requirment: A popup should popup- "Do you want to save the content of the page", before it redirects to the page of the menu selected. Conditions: If I have saved the changes then,if I click on some other menu, the message should not popup. If I save the changes made then again I change something on that page, then, the message should popup.

kindly, tell me how to handle Data Purging of previous month... I want the data of current month only...

kindly tel me how to handle Data Purging of previous month... We want to have the data of current month only...

can u plz explain step by step...

plz help me...

I have a web application which has its solution in VSS. The VSS is on a server e.g. 10.x.xxx.xx/ABC. Now, I want to work on that project.Kindly, tell me how to get the solution from this servers folder. plz help...its urgent.

I want an output of 2nd highest salary without using a subquery in sql server 2005.I'm writting the following query: select empno, ename, job, sal, deptno from (select t.*, row_number() over(order by t.sal desc) seq from emp t) y where y.seq = 2 But when I run this query, I get an error: 'ROW_NUMBER' is not a recognized function name.

I'm getting an array with the valid data... there are 2 rows in the dataset... m getting this exception whem I'm binding the datagrid with the arraylist...

"Specified argument was out of the range of valid values.\r\nParameter name: index" plz somebody tell me that why m getting this error

I have to pass user name and password for the LDAP authentication but during this process password is getting saved into the local machine RAM and which can be retrived later... So how I can use MD5 hash code for preventing this.

I'm writing the query given below which should give 5 rows which has ParentFragmentId as NULL but I'm not getting any row. SELECT TOP (5) FragmentId, FragmentTitle FROM Fragments WHERE (ParentFragmentId = NULL) ORDER BY CreatedOn DESC

what are private classes in .net

I am trying to add controls to a web part dynamically.The controls are getting added but their values are not getting populated.Eg: If i try adding a textbox with some text specified, then the textbox is getting added but the text is not getting populated. But the same control is getting rendered with all the appropriate text on the form.

[Message Deleted]

[Message Deleted]

U can also do it using a stored procedure. e.g. CREATE PROCEDURE [dbo].[USP_GetName] @i_strSearchName VARCHAR(50) AS BEGIN SELECT NAME FROM USER Where NAME Like @i_strSearchName+'%' END

what abt non .net dll's