Sql Profile

Apr 3, 2000

Hi,
This is Raj..could anyone pls explain the sql profile and how we will set the row-level locks as a dba.Sorry it is a silly question but sometimes these questions are bugging my mind.
Thnak u in advance.

--Raj

View 1 Replies


ADVERTISEMENT

SQL 2012 :: Find Profile Name In Stored Mail Profile That Already Exists

Jan 22, 2015

We have a previous SQL 2012 cluster that emails us when a new database is added. I am unable to figure out why we get this error any time we add a new database to it, and also it prevents us from adding a new availability group to this cluster because of this error.

I also am unable to figure out what profile it is talking about as this was setup before me and I am not a DBA.

View 9 Replies View Related

SELECT - Profile

Feb 17, 2007

I use the default database called "ASPNETDB.mdf" that is automatically created in Visual Studio Express 2005....
There is an table called "aspnet_Profile" that holds the profile-properties, UserID etc.
There is also another table called "aspnet_Users" that holds all usernames, UserID etc...
No to my problem:
I have a SqlDataSource-control and want to select all users that have the property profile.Color = "Blue"....
How can I write the SQL-part for that?  

View 2 Replies View Related

Profile GUID

Apr 13, 2007

I am using a SqlDatasource and need to set a SelectParamter to the ProviderUserKey (The GUID of the user when Profiles are enabled)
 Can anyone tell me whether it is possible and How?
I am currently using the session state to store it in and then using the session=... to get the value into the parameter.
Is there a direct way of passing this value into a SelectParameter when using a SqlDataSource?
Thanks in advance.

View 3 Replies View Related

SQL Mail Profile

May 27, 2001

Hi,
Is it necesarry that to run SQL Mail, you need MS Exchange Server as the mail server? Our mail server is MDaemon 2.8. Can anyone tell me what would be the mail profile for MDaemon?
TIA
Wilson

View 1 Replies View Related

MS SQL Profile Issue

Sep 16, 2003

I am using MS SQL 2000 profile function to monitor the a report process. (VB + Crystal+MS SQL)

I notice there are some actions named
as "object created "
what does it mean ?

View 3 Replies View Related

ASP.NET Profile Parameter In T-SQL

Feb 3, 2008

Hi

Is there any way that I can use an ASP.NET profile variable in a T-SQL parameter?
I need to base a query on the current ASP.NET profile variable for purposes of creating a report.
Thanks
Deon

View 3 Replies View Related

Profile, SQLDataSource And GridView

May 11, 2007

Hello.When I create a user at the ASP.NET database, I need to insert more fields than the defaults, and I do it like this:         Dim customProfile As ProfileCommon = ProfileCommon.Create(CreateUserWizard1.UserName, True)              
customProfile.telephone =
(CType(CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("TelephoneText"),
TextBox)).Text(telephone example)Those data are inserted at the DB at the aspnet_Profile table, in the fields PropertyNames & PropertyValuesString, but they are saved together (see image above)

I want to separate those properties in the GridView as long as each property appears in a column, is it possible? Thank you very much, i'm expecting your answers.

View 11 Replies View Related

Does The Profile Provider Uses Cache?

Feb 3, 2008

Hi,
I use the Table Profile Provider: http://www.asp.net/downloads/sandbox/table-profile-provider-samples/ 
When I call for example: Profile.FirstName does this access the DB every time this call appears in my code?
Or all the profile is loaded to the cache when the user first loggs on?
thanks

View 4 Replies View Related

Change Profile Field Name

May 28, 2008

 I had a profile element named "Country", however, I want it to be named "CountryId". I can change this in the web.config with no problems, but then I need to update the code manually any place Profile.Country is referenced. Also, it seems I would have to write some SQL to update all the values in the profile table from Country to CountryId. Is there an easier way to do this? I'm using Visual Studio 2005 and SQL Server Express 2005.Thanks,Wes 

View 5 Replies View Related

Profile / Stored Procedure

Feb 25, 2004

Hi,

I have created a Stored Procedure, under Stored procedures section under Enterprise Manager on SQL server 2000.

Could anybody tell me, how and what are the steps to follow to TRACE the procedure , using SQL PROFILER ?

Please advice me !

Nicol

View 5 Replies View Related

Profile Value + Sql Value, A Login Problem

Apr 11, 2006

Hi all.  Quick question.  I'm using VS2005, C#, aspx page.I'm creating a Profile to store login and password.  That part is working...  I can call the values (and display them) using this code  <%= Profile.login %> and <%=Profile.password %>Now I want to create a Grid View that will connect to the SQL db, see if the login and password value stored in the Profile match that of ones in the SQL db.  So if the profile is login: bob password: dog, the grid view will output all application ID numbers associated with the bob and dog.  Here is the SQL code...trying to use the <%=Profile.login %> as a filter on the login and password doesn't seem to work...Can anyone tell me what I'm doing wrong?  How can I reference a value in the Profile within an SQL statement?SELECT     ApplicationStatus.Description, Customer.CustomerName, Application.ApplicationDateFROM         Application INNER JOIN                      ApplicationStatus ON Application.ApplicationStatusID = ApplicationStatus.ApplicationStatusID INNER JOIN                      Customer ON Application.ApplicationID = Customer.ApplicationID INNER JOIN                      [User] ON Application.DealerId = [User].UserIdWHERE     ([User].LoginId = '<%= Profile.login %>') AND ([User].LoginPwd = '<%= Profile.password %>') AND (ApplicationStatus.Description = 'Pending')

View 2 Replies View Related

Using A Profile Object In A Query

Apr 24, 2006

I have created a profile object which is a list to store photoId into an array. (kinda like a shopping cart) which will persist in the list untill manually deleted by the user.I want to use the photo Ids stored in this object in my profile as a parameter for an sql select statement to be displayed into a data grid. What is the best way to go about this... and suggestions... I know you can use a profile property as a parametere in a sqldatasource but Im not sure how to do this for an array.HELP

View 1 Replies View Related

SQLMail, MAPI Profile

Aug 7, 2000

I created a new MAPI profile on the server, and it seems to work fine with Outlook. I also dropped the previous default MAPI profile.

Now, when I go to the EM SQLAgent Properties, the only MAP profile offered in the SQLMail drop-down is the old, deleted profile. Also, only the old profile comes up with xp_get_MAPI_profiles.

How can I get SQLAgent to recognize that I've set up a new mail profile?

View 1 Replies View Related

Create Profile Sql2000

May 2, 2008

how to create profile use mail in sql2000

View 1 Replies View Related

Set Statistics Profile On Into Table

Jul 23, 2014

How can I insert the results of "set statistics profile on" into a table?

View 2 Replies View Related

DB Engine :: What Is UpdateLoginStats In Profile

Oct 7, 2015

We have a delay between the login and the first statment after the login. I see in the profiler trace that this delay is due to an eventClass "SQLTransaction" and the only information I have about it is that the objectName is "UpdateLoginStats". It is very interesting but this event usually takes 0 time, but when run from one specific user, it takes 10-1000 MS.

View 10 Replies View Related

Filter Query On Profile Property

Nov 1, 2006

Hello All, Can someone please help me with this problem.  I have created additional profile properties for my users in the aspnet_profile table.  One of the properties is named 'Division'.  The division property is how I segregate users, for example, my company has multiple divisions and, the information that is displayed is dynamic according to which divison the user belongs to. Amost all of my stored proceedures are filtered by checking the value of Profile.Division of the logged in user. This system works great.  The problem is, now I am working on user management and I need to create a Gridview that will display all of the users for a particular division but, I have no idea how to filter a query against the aspnet database to get the results I am looking for.  Here is a small example:SELECT     aspnet_Users.UserName, aspnet_Profile.PropertyNames, aspnet_Profile.PropertyValuesStringFROM         aspnet_Profile INNER JOIN                      aspnet_Users ON aspnet_Profile.UserId = aspnet_Users.UserId********   Here is the part I need help with *********************WHERE  PROFILE.DIVISION = KOr, can it even be done? Can you filter a query on the value of a profile property?Anyone have any ideas?Thanks in adavance for your help

View 2 Replies View Related

How Can I Use Profile.UserName As A Parameter In A SqlDataSource

Dec 26, 2006

I have looked and tried with no luck on using the Profile.UserName in an SQLDataSource Update select statement. and anyone please help me with this?UpdateCommand="UPDATE tblDocuments SET DocumentTypeID = @DocumentTypeID, DocDescription = @DocDescription, DocLocation = @DocLocation, DocStartDate = @DocStartDate, DocEndDate = @DocEndDate, LastUpdate = GETDATE(), LastUpdateBy = @ProfileUser WHERE (DocumentID = @DocumentID)"   <UpdateParameters>
<asp:Parameter Name="DocumentID" />
<asp:Parameter Name="DocumentTypeID" />
<asp:Parameter Name="DocDescription" />
<asp:Parameter Name="DocLocation" />
<asp:Parameter Name="DocStartDate" />
<asp:Parameter Name="DocEndDate" />
<asp:Parameter Name="ClientID" />
<asp:Parameter Name="ProfileUser" />
</UpdateParameters> 

View 2 Replies View Related

How To Save Enterprise Manager Profile

Dec 21, 2005

Hi everyone,

Do someone know how to save enterprise manager profile to save all the registered servers list -> to install on another computer ? (I have a big server list)

I've didn't find an *.ini file, and i've tried to export Windows Registry keys, but I cannot import them into the second computer.
config : SQL2k - sp4 on Windows 2K

Thanks a lot
asia

View 4 Replies View Related

User Profile Using Sql&#043; Getting Data From Cookie

Sep 24, 2007

does anyone know how i can make it so you can view all the users in the database on a page and there names are clickable with a link and then shows there profile page which is basicly a text box that all users can edit there own.

i have a "users" table and mysite stores there username in a cookie called user for the session.

any help will be very very grateful

View 1 Replies View Related

Limiting SQL Profile File Sizw

Apr 9, 2008

I am using sql 2000 SP4 and I am really struggling finding some dead locks. I can enable Startup Parameters T1204 and T3606 which gives me a partial picture.



But then I need to run a profile for deadlocks etc. This is where I have a problem what Events and Data columns do I need?

Also I have an extremely heavy loaded server; if I run a full profile I will grind the server to a halt.



I can get away with running a duration trace and setting duration > 3000. But I find that if I add more events and data columns the duration > 3000 no longer stops the flood.



This is because if the field you are filtering by has no value it will include it in the trace. Which is a real problem.



So has anyone got and advice on how I can set up a profile to help me find dead locking but wont cripple my server.



Many thanks

View 3 Replies View Related

Windows 2000 User Profile

Jan 6, 2007

Hi all,

Could somebody please help me out? I'm running Windows 2000 on my laptop. I opened a new user account and gave it administrative privilegies. I copied the administrative profile to the new account and everything seemed to work except when I tried to open any office application a dialogue appeared prompting me to place the Windows 2000 office CD rom in the drive. Why has this happened? How can rectify this problem since I don't have the CD rom.

Thanks in advance for any help.

View 1 Replies View Related

Profile Image Binary Blob Retrieval

Jan 13, 2008

 
Hi, All
Can you add a group of images into the aspnet_profile table as a serialized binary blob?
If so how do you retrieve the image from the blob?

View 1 Replies View Related

Store Procedure In Cutomer Profile Provider

Feb 14, 2008

In customer profile provider, I got the one of  store procedures  as belowquestion is that : I dont understand the character "N" and "case" used for?? help...1 ALTER PROCEDURE [dbo].[Profiles_Sel]2 (3 @userName nvarchar(50)=null,4 @inactivityDate datetime=null,5 @isAnonymous bit
6 )7 AS8 BEGIN9
10 Declare @select nvarchar(2000)11 Declare @where nvarchar(255)12 Declare @params nvarchar(255)13
14 /*Select profiles that meet the specified criteria.*/
15 Set @select=N'Select '
16
17 Set @select=@select+18 N'ProfileID,19 UserName,20 ApplicationName,21 IsAnonymous,22 LastActivity,23 LastUpdated24 From Profiles25 '
26
27 Set @where=N'';28 If(@userName Is Not Null) 29 Begin30 Set @where=@where+Case When @where='' Then N' Where ' Else N' And ' End + N'(Profiles.UserName Like @_userName+''%'')';31 End32 If(@inactivityDate Is Not Null) 33 Begin34 Set @where=@where+Case When @where='' Then N' Where ' Else N' And ' End + N'(Profiles.LastActivity <= @_inactivityDate)';35 End36 If(@isAnonymous=1) 37 Begin38 Set @where=@where+Case When @where='' Then N' Where ' Else N' And ' End + N'(Profiles.IsAnonymous = @_isAnonymous)';39 End40
41 Set @select=@select+@where;42
43 Set @params=N'@_userName nvarchar(50),@_inactivityDate nvarchar(50),@_isAnonymous bit';44
45 Execute sp_executesql @select,@params,@_userName=@userName,@_inactivityDate=@inactivityDate,@_isAnonymous=@isAnonymous;46
47 END
48
   

View 5 Replies View Related

How To Display A Loged In User's Profile From Database

May 25, 2008

 after i login, i should be able to see the login person's profile, and edit it. anyone know how to do this?currently i am using grid view to display the profile, and created a store procedure in database ALTER PROCEDURE [dbo].[select_customer_by_login]     -- Add the parameters for the stored procedure here(@Username nvarchar(50))AS    SELECT C.CustomerName, C.TFN, C.Address, C.City, C.State, C.PostCode, C.Phone    From dbo.Login L, dbo.Customer C    Where L.CustomerID = C.CustomerID and L.UserID=@Username; @Username is the login account when people login. the error output is Procedure or Function 'select_customer_by_login' expects parameter
'@Username', which was not supplied.  

View 9 Replies View Related

How To Setup Profile, Roles, Etc In My Hosted Sqlserver?

Jan 11, 2006

I've been working with godaddy.com, and when I setup there the sqlserver databases it tells me if I want to create the tables and stored procedures that conform the typical profile, roles and users features... the same as if I execute the aspnet_regsql.exeNow I'm working with anotherhoster (aruba) and I've setup the database OK, but i didn't found any way to setup the profile, roles, users, etc features.Aruba uses the mssql server web admin.How can I setup this features? Of course, aruba doesn't let me to execute the aspnet_regsql.exe...thanks

View 7 Replies View Related

Notes Mail: Exchange Profile Not Found!! HELP PLEASE!!

Feb 3, 2000

I saw from SWYNK that you were able to set up SQL Mail using Lotus
Notes. I tried following the post by Edward Alexander but got into some trouble:

We were using MAPI to get to Notes Mail.

1. We know that MAPI works because we were able to send mail by
a. using the exchange client (Windows Messaging client)
b. using VB script to send a message with MAPI.Session


The problem is that SQL server cannot see the Exchange Profile that was defined on the SQL box.

View 2 Replies View Related

SQL Agent Mail Profile On Cluster Fail Over

Apr 25, 2007

I have sql 2000 sp4 running on a cluster, we had to fail over to other cluster, and now the sql agent choice to use a mail profile is grayed out. I can go to sql mail and test the profile and it works, but I can't change it for the sql agent? Anyone seen this before

View 3 Replies View Related

Profile Logical Reads Versus STATISTICS IO

May 5, 2015

Why is there often such a dramatic discrepancy between the logical reads recorded in the trace file versus the output of STATISTICS IO?

In the server-side trace I have running I found a reporting procedure that shows having 136,949,501 reads (yes, in hundreds of millions), and it's taking 13,508 seconds to complete.

So I pull the code from the trace and execute it via SSMS - it runs < 1 second, and only generates about 4,000 reads (using various different parameters I get the same result)

The execution plan shows nothing unusual

View 5 Replies View Related

Question On Distinct Cluster Profile Description

Jul 11, 2007

Hi, all,

I really need some advices on distinct cluster profile description as when we do the profile clustering with clustering algorithm, some clusters can be at the same time as several profiles. E.g. when I cluster the data into different clusters, select value 1 for attribute a, then cluster 1 is the darkest cluster there which can be cluster of value 1 of attribute a. Then when I select value 2 of attribute b, again, cluster 1 is the darkest one there, then it can also be called as cluster of value 2 of attribute b. Therefore I am really confused. In this case, what are really the best way to descibe this cluster 1? Is there any way to best combine all the common chraracters of these two clusters and then define cluster 1? Or any other good ideas?

I am really looking forward to hearing from you guys who are veteran of data mining and its applications and give me some advices on this.



Thanks a lot in advance.



With best regards,



Yours sincerely,

View 3 Replies View Related

CLR Profile A Managed Stored Procedure In SQL Server

Apr 20, 2008



Can someone give me a heads up on how to do this--what tools, a how-to or the like?

Thanks
Michael Isbell

View 2 Replies View Related

Find 5 Random Users, Where Profile.Gender = Female

Dec 30, 2007

Hello there,I'm a new one to asp.net, so I need some help, and hope someone out there wanna take the time to help me, with my problem..I had set up a Custom "Membership", you know click on a file, and it create a database ASPNETDB...There I need to find 5 random users where they are e.g. females..Right now I can find 5 random users, but I dont know how to put in there Where statement, because I need to read something from thier profile?This is my code so far: SELECT TOP 5 [UserName] FROM [aspnet_Users] ORDER BY NEWID() 
Then I have to put in WHERE (profile.Gender = female)<--- But how do I do that?Hope you wanna, and can help me,Regards Jeppe RichardtPS,Im using the language vb.net

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved