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


Post New Web Links

Some allocation_unit_id values returned by sys.dm_os_buffer_descriptors do not have corresponding re

Posted By:      Posted Date: September 30, 2010    Points: 0   Category :Sql Server
 

Version: SQL Server 2005 Standard Edition with SP2 (new installation not upgraded)

Databases: Compatibility level: SQL Server 2005 (90) (new databases not restored)

Some allocation_unit_id values returned by sys.dm_os_buffer_descriptors do not have corresponding records in sys.allocation_units.  DBCC CHECKDB found 0 allocation errors and 0 consistency errors.  What are those unknown allocation_unit_id values?  One of the unknown allocation_unit_id values is 6488064 which occurs many times and exists in all databases.

 




View Complete Post


More Related Resource Links

How can I replace values in GridView returned from a Stored Procedure

  
I am working on creating a stored procedure that will output a pivot table.  In the pivot table will be either the string NULL or a number.  How can I reformat this in ASP.NET so the NULL value becomes a blank cell in the gridview and the number (whatever it is) becomes an 'X' ?

Desired rows not returned because of null values

  

I have a property table and an image table.
I want this query to return all distinct properties and a thumbnail image. However some properties don't have thumbnail images and they
don't get returned by the query. If the imgid is null I still want to return the property. Not sure of how to do this. Thanks

ALTER PROCEDURE dbo.procGetPropertiesSelect2
AS
SELECT        tblProperty.PropertyID, tblProperty.SubmitPersonKey, tblProperty.SubmitDate, tblProperty.Active, tblProperty.PropName, tblProperty.StreetAddress1, tblProperty.Storage,
           tblPropertyImages.ImgID
FROM            tblProperty INNER JOIN
                         tblPropertyImages ON tblProperty.PropertyID = tblPropertyImages.PropertyKey
WHERE        (tblProperty.PropNa

LookUp windows returned values

  

HI,

In a webform, I have a formview with respective InsertItemTemplate.  I have 2 Look Up buttons, one for Student which opens Student LookUp, and one for Mentor which opens the Mentor Look Up. 

First on the input screen sequence is allowing the user to choose Student first.  User clicks the Student LookUp button, The StudentLookUp Window is shown, user selects a student, the selected student information is returned and displayed on the calling screen.

The user then clicks on the Mentor LookUp button.  The Mentor LookUp window is shown.  As this is happening, the values for the Student information, which I have populated upon selecting a student from the Student LookUp goes blank.  Can anyone tell me why?

Calling window

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="StrikeActivityMemberInsert.aspx.cs" Inherits="GRIPS.StrikeActivityMemberInsert" %>

 

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

    <title>Add Member</title>

<script src="../../../jquery-1.4.2.min.js" type="text/javascript">

</script>

<script language="javascript">

    fun

Build ArrayList with the values from each column returned from 1 record

  

I have a procedure that is used to look up user permissions in our custom table, There is 1 record for each user and about 20 columns for each of the permissions.

How can i take the column values and place into an array?

All the column are bit type and 1 is int. Is it possible to take the values returned and add to an ArrayList?

And then once the values are in the array, how to loop thru it and go to certain index to check the value.

This is what i have now:

   public ArrayList getPermissions(string uid)
    {
        ArrayList list = new ArrayList();
        using (SqlConnection conn = new SqlConnection(this.connDB))
        using (SqlCommand cmd = new SqlCommand())
        {
            try
            {
                conn.Open();
                cmd.Connection = conn;
                cmd.CommandText = "Select_User_Perm";
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Clear();

                cmd.Parameters.AddWithValue("@id", uid);
                SqlDataAdapter a = new SqlDataAdapter(cmd);
                DataSet ds = new DataSet();
                a.Fill(ds);
//Starting here, not sure how to grap each column, I've used this before but the table contained multiple records for user, so the below wor

SSIS excel data source numeric values returned as null

  
Hello everyone, long time no see!, I have a problem and was hoping someone can help me:
I'm using SSIS 2005 Enterprise edition,  I'm creating a package that reads an excel (xls) file using the "excel source" component, and it dumps the data into an OLEDB destination (a sql server).
When I drag the excel source component and create the excel connection to my file the component automatically reads the columns and their datatypes.

The problem is that I have a column which has numeric data and the package uploads as NULL every number that starts with a zero. (note: in excel this column is formatted as "text", despite it has only numbers, because it's the only way excel maintains the left sided zeros).
So I checked the data types by right clicking the excel source component -> show advanced editor and my surprise is that this column's data type is detected as double-precision float, and it doesn't let me change it.

I tried the answer posted here: http://devselekta.blogspot.com/2007/09/ssis-excel-data-source-values-returned.html but it only works when the first row of data has a number beginning with zero on this column.
Someone knows how to get the data imported correctly? Thanks in advance.
Odin_Dark

How to Pass Values Between Web Pages ASP.NET

  
You can pass information between pages in various ways, some of which depend on how the redirection occurs. The following options are available even if the source page is in a different ASP.NET Web application from the target page, or if the source page is not an ASP.NET Web page:

Use a query string.

Get HTTP POST information from the source page.

The following options are available only when the source and target pages are in the same ASP.NET Web application.

Use session state.

Create public properties in the source page and access the property values in the target page.

Get control information in the target page from controls in the source page.

How to Pass Values Between ASP.NET Web Pages

  
You can pass information between pages in various ways, some of which depend on how the redirection occurs. The following options are available even if the source page is in a different ASP.NET Web application from the target page, or if the source page is not an ASP.NET Web page:

Use a query string.

Get HTTP POST information from the source page.

The following options are available only when the source and target pages are in the same ASP.NET Web application.

Use session state.

Create public properties in the source page and access the property values in the target page.

Get control information in the target page from controls in the source page.

jquery autocomplete multiple values

  

i got some samples and i did autocomplete using jquery , its working well for single input values

but i need to pass multiples values after one by one in the textbox. Is it possible to pass multiple

values in the textbox for autocomplete in jquery in asp.net?

 


JQGrid Loading deleted values

  

Hi,

This is quite strange. here is the issue:

Some Info:

1. I'm using a multi-select jqgrid.

2. I have my own delete button to delete multiple orders

The problem:

When i press the delete button on the pager of my jqgrid, the records are deleted from the database but JqGrid shows some records (4-5). On refreshing the grid, correct numbers of records are shown.


Here is the code:


function delorder() {
        var amg = $("#horder").getGridParam('selarrrow');
        var cont = amg.length;
        if (amg.length > 0) {

Where to Filter the companies returned by the EF?

  

Hi,

I am just starting with dynamic data. I have an enttity framework called UsersModel.edmx.

It returns a list of all companies in the tblCompany table. This list is really big.

I need to filter the list returned to all user controls on the client so that it only returns the company that have a CompanyTypeId= 2 or CompanyTypeId= 3 and company name != "".

1 - Is it possible to filter the company list returned on the server so that I can filter only once for all the controls that use that on the client?

My ideas was to do something like this using linq and lambda but I am not sure how:

return tblCompanys.Where(c => c.CompanyTypeId == 2 || c.CompanyTypeId == 3 && ).Where(c=>c.CompanyName != "").OrderBy(c => c.CompanyName).Distinct().OrderBy(c=>c.CompanyName);
 

2 - I have created a partial class and a metadata class and added the DisplayColumn attribute to use the company name and sort by company name ascending.

Could I use the code to filter the returned companies in this? where?

namespace MarsMedicalModel
{
    [DisplayColumn("CompanyName", "CompanyName")]
    [MetadataType(typeof(tblCompanyMetadata))]
    public partial class t

How to cast integer values as an array of enum values?

  

Hello all!

I'm working with VS2010 Beta2, ASP.NET and Dynamic Data. I'm using VB but will certainly be happy to receive a C# example if necessary. Laughing

I used a few of Steve's examples (Writing Attributes and Extension Methods for Dynamic Data and Dynamic Data - Hiding Columns in selected PageTemplates) to create a custom property attribute to be applied to a dynamic data column and want it to accept an array of enum values (each value will represent a dynamic data page template where this column should not be displayed).  My new attribute works fine when I hardcode it like this, meaning the HideColumnIn attribute is properly populated with the array of enum values:

<HideColumnIn(PageTemplate.List, PageTemplate.Edit)> _
Public Property My_DD_Column As Object

 

However, I want to store the values to be used for the HideColumnIn in the DB as integer values that correspond to the

Passing values in pages

  

Hi! Friends..

how to pass the value from one page to another page in asp.net  with out Using State Management Concepts?

Like 1. cookies

        2.Session

        3. QueryStrings

     With out using the above should pass the values...


how to bind Dropdownlist based on textbox values

  

hi

I have one drodownlist which show data based om textbox values...

Let us consider i have 

Select Name from table1 where Type IN(@typ)

here @typ is textbox values

here for example textbox will have some thing like this L1,L2,L3..

How to filter Name based and shown in drodownlist based on this L1,L2,L3(on textbox)..

Help me in this


Unable to get all the values from a field

  

Am reading an XML from web service and storing in  a dataset. 
then in write to a DataTable as follows

 DataTable dtResult1 = dsSearch.Tables["RESULTSET"];    
 DataTable dtHIT = dsSearch.Tables["HIT"];     
 DataTable dtField = dsSearch.Tables["FIELD"]; 

The issue  is  in the DataTable dtField i can only see 3 columns FieldID,Name,HIT_ID

The corresponding values in the dataTable looks like this for the corresponding fileds

0,rank,0
1,internalid,0
2,contentid,0
3,contentids,0
4,collection,0 

I am unable to get the Field Name values 1,8799f4646b6ed9acde142581a84f75a6 ,234B5F5F-F247-4EB6-9E39-A7B64C7FE1BD,Yes...etc

What would be the cause for this...Any Help

Below is the structure of the XML-


- <RESULTSET FIRSTHIT="1" LASTHIT="10" HITS="10" TOTALHITS="46" MAXRANK="3159" TIME="0.0040"> 
- <HIT NO="1" RANK="2955" SITEID="0" MOREHITS="0" FCOCOUNT="0"> 
<FIELD NAME="rank">1</FIELD> 
<FIELD NAME="internalid">8799f4646b6ed9acde142581a84f75a6 </FIELD> 
<FIELD NAME="contentid">234B5F5F-F247-4EB6-9E39-A7B64C7FE1BD</FIELD> 
<FIELD NAME="contentids" /> 
<FIELD NAME="collection&

Retreiving XML tag values

  

Hi,


I'm new to xml.


Currently I'm using the SOAP service and MSXML2.ServerXMLHTTP40  to get data from a website.

To retrieve data I'm using the "responseText" method of the MSXML2.ServerXMLHTTP40 class.


My XML tree looks like this. ( part of the tree)


<dataID>0</dataID>
<projectName>100208_FC3_BY_RO_rza</projectName>
<chunkSize>0</chunkSize>
<minLat>47.8512912</minLat>
<maxLat>48.2469535</maxLat>
<minLong>11.6839167</minLong>
<maxLong>12.4439732</maxLong>
<minTimestamp>2010-02-03T10:58:29</minTimestamp>
<maxTimestamp>2010-04-09T10:05:22</maxTimestamp>
<imageCount>154282</imageCount>
<audioCount>0</audioCount>
<gpsCount>84475</gpsCount>
<mcvCount>2475</mcvCount>
<fileCount>87</fileCount>
</JobInfo>


Just need to retrieve the value of the "projectName" & "dataID" from this.

Appreciate if somebody can help me to get the values of the above 2 fields with the relevant code.


Thanking you in advance.


reading values from config files in NUnit tests

  

One of my NUnit tests has to read in some values from config files.  In my main application this process works perfectly well, however when I run the unit test, the code that reads in the values from the config files doesnt read anything in.  Ive tried putting app.config in my unit test project (I even tried web.config) but nothing seems to work.  Are there any special steps involved when reading from config files in an nunit test ?


Passing HTML values from asp.net to asp

  

 We have a part of our website which is coded in classic asp. This takes the values of a login page (asp.net)  which uses 

<input type="text" /> to hold the values and then submit them to the asp page using the following line of code -

<input type="submit" value="Login" onClick="this.form.action='<%= SubmitURL() %>/login/login_user.asp?Type=Login&amp;this.form.encoding='application/x-www-form-urlencoded'; this.form.submit();" />

The asp page then retrieves the values using the code -

Value1 = Request.Form("Val1")

We now have a requirement to pre-populate the login values to provide an automated login process but don't want to change the older asp code. When we try to assign values to the input text in the asp.net page by assigning the value runat="server" the login fails as it does not seem to carry over when the page is submitted.

Is there a way where we can pre-populate the html textbox without making it unavailable to the asp page?

 


Categories: 
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