Query to find the domain and username

Hi experts,

 Any one pls tel  me the query to find the current working domain name with username in sql server.

Thanks

Abdul2010

Hello!

I have added a linq to sql layer in my MVC 2 application.

This is the code I am using:

using (ProductPortalDataContext ctx = new ProductPortalDataContext())
            {
                var Title = from aps in ProductPortal.Models.AppSettingsView
                            where aps.LanguageID = Lang
                            select aps.WebSiteTitle;
            }

It says to be unable to find a quey model for AppSettings view and then says "where not found".

Tried googling, nothing came up. Tried searching here(first two pages) and nothing that seemed relevant popped up.

But the best of all, created a new ASP.NET applicatio, imported the model using Linq to SQL and it compiled!

No idea what I am doing wrong... hints?

(some time later...)

Ok, I tried adding a button and a label to the asp.net application j

Hi,

we have a Sharepoint server 2010 running and at the top right of the website the username is showing like domain\username.

The same thing in documentlibraries and lists.

How can I change this to "surname givenname"?

I have configured a userprofilsync with our Domaincontroller and all of our users can be found in the Sharepoint Central Admin User Profils section with the correct Name.

Thanks

Bjoern

HI All,

I´m trying to write a query for a list view that should return all items if the current user belong to a group. If the user doesn´t belongs to this group, no items should be returned.

So far, I could find many equal examples about using the CAML Membership element in a comparison with an AssignetTo field. But not making a comparison between the current user and a specific Sharepoint Group.

Any suggestions, please?

Thanks

hi guys,

I have only username. and want to check and grab the password from the database. It is BEFORE LOGGING IN. so I don't think the build-in asp.net functions could be used, right?

thanks a lot!!

I'm bangin' my head against the wall here.  I'm not even sure what I want to do is possible.

I have developed an ASP.NET app that will only be run on my local network (which incorporates a Windows Domain).  It's running on IIS 7.5.

I want to do this:

Dim username as string = Httpcontext.Current.User.Identity.Name

My problem is this: If I don't turn off Anonymous Authentication and ASP.NET Impersonation, I don't get the results I'm looking for.  (if Anonymous is allowed, I get an empty string returned for username, and if ASP.NET impersonation is allowed, then "username" is always whatever account is associated with impersonation, like "Network Service").  If I turn those off and then turn Windows Authentication on, it works, but only after a dialog box presents itself asking for the Windows Credentials.

What I'm trying to do is NOT require the users to log in.  Since they've already logged into the domain when they signed on their computer, I'd like to just allow them access to the ASP.NET application I've written, and identify who they are (based on their previous Windows login) using the line of code above.  I don't need them to re-authenticate, because they're already a

Hello,

I have a SP which writes to a table all processes which are being executed when application decides to stop waiting for results of the query. It works very well but problem is that it does not dump all SPIDs but only some of them which are being executing for a long time. Common pattern that a lot of SPIDs will be blocked by single SPID which will not be part of the output which is being generated. How do I dump all SPIDs and what they are doing along with SP below?

SELECT 
 t1.resource_type,
 'database'=db_name(resource_database_id),
 'blk object' = t1.resource_associated_entity_id,
 t1.request_mode,
 t1.request_session_id,
 t2.blocking_session_id,
	 t2.wait_duration_ms,

 (SELECT SUBSTRING(text, t3.statement_start_offset/2 + 1,
 		(CASE WHEN t3.statement_end_offset = -1 
 			THEN LEN(CONVERT(nvarchar(
 how to add search for available domain name and find information about specific one ? 
  
Hello All , 
i have a task to add search for available domains and also to find some information about specific one
anyone has any background about how to do that or there is any web services that provide this functionality 
Thanks in advance