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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Status of CLR

Posted By:      Posted Date: October 12, 2010    Points: 0   Category :Sql Server
I want to check whether CLR is enabled or disabled. How can I accomplish this?

View Complete Post

More Related Resource Links

update user status in database when ever user logoff


actually i came across this senario for new project where userstatus must change to log off when ever he do fallowing activity.I have maintain user status when he log in to web based system.

Activities are


1.user click log off

2.or user click browser close button or close brwoser tab.

3.or Fource fully shut down his Pc

I am able to get first 2 but not the last one.I googled it but not get any satified ans for that.

I m looking for guidens for this. Any help is grate help for me as i want it.And also other suggesstion also welcomed.

thanks in advance


getting a email delivert status when sending email using msdb.dbo.sp_send_dbmail


Hi All,

Can some help me regarding following.

I have set a job in sql server 2008 to send reminder emails for product expiration.
Now I want a report which will specify the list of the emails sent with the email status details like queued ,sent,delivered, failed.

I can fetch the emails that are sent by querying the like following

select * from sysmail_mailitems SM inner join sysmail_profile SP on SM.Profile_Id = SP.Profile_Id
and SP.Name ='ReminderProfile'

The problem is only getting a perfect status of email whether it is delived or failed. How I can get those status ?
Please help.


How to make the Workflow Status remain "In Progress" when a task is "Rejected"


Hi Sir/Mam,

I have a work flow running on a list, when a task is Rejected at a stage then the Workflow status is set to "Completed". Instead of this I want the Status to remain as "In Progress", so that in future after the modification of the document the Approver may Approve it and then take it to the next stages. This is not possible if the Workflow is set to "Completed".

Can you please suggest an easy way to do this

Thanks in Advance


Change the Workflow Status through code


HI Folks,

I have a scenario where i need to develop a 6 stage approval workflow(sequential) using WWF and depoly it to sharepoint. Everythigns fine till here.

Now we look ahead to change the Status field on the documents library which actually has the Workflow Name as the column name and its value being In Progress, depending on the stage of approval. Like(Approved 1, Approved 2, Approved 3.)

And if rejected the status should be rejected than Completed. Any idea how can we update this column of the List item.

I have tried item[workflowProperties.Workflow.ParentAssociation.Name]="Approved 1";

But this throws an error saying input string is not in a correct format.

Any information would be of great help :)


Sreeharsha Alagani

Anonymous Web Site receives "The request failed with HTTP status 401: Unauthorized"


I set up a test website on my local box and was able to access sharepoint search using the querySearch web service from SP.  After I got it all working properly I transferred the code to the target website that is set up with anonymous access for all people on the fab floor.  However from this website I keep getting the 401 error.  It can't be SP because the same code worked from my local website "localhost".  Any suggestions?  we don't want to have to have the fab people log in so we can't not have the box anonymous.  I would appreciate any suggestions very much!!!

Using WSS 2007 with MOSS.


  private void GetDefaultCredentials()
      m_where = "get configuration data for credentials";
      string userid = ConfigurationManager.AppSettings[ "userid" ];
      string password = ConfigurationManager.AppSettings[ "password" ];
      string domain = ConfigurationManager.AppSettings[ "domain" ];

      m_where = "set search query credentials";
      m_query.Credentials = new NetworkCredential ( userid, password

Status "Installing" keeps stuck

Hi All..

I have a problem about status that is stucked.. I've read many forums that related to my problem, but still can't solved it yet :(

Here is my problem...

After 3 months I keep on uploading, removing, and uploading form, I have no problem.. Until today, when I want to upload my form, the status keeps on "Installing", instead of "Ready".
Then I removed my form using Timer Job Definitions, and I delete form.wsp. It works.
Afterwards, I try to upload form again, I have the same problem with stuck status. And then I delete again using same way.
I've tried more than 10 times, and the result still the same one.

Things that I've tried are:
- Reset IIS.
- Reset Application Pool.
- Check the services (e.g: Windows Sharepoint Services Administration, Search, Timer, Tracing) -- all are already started.
- Use "stsadm -o execadmsvcjobs"
- Reset Infopath Form ID
- Publish and change Infopath Form Name
- Command "net start SPTimerV3" and "net start SPAdmin"

Tried all things above, but still can't work. Status is still stuck.

Then, I try to upload other forms, but still have the same problem.

Please help me. I'm stuck already... :((

Is there anything I can do again?


SSIS Text was truncated with status value 4

I am developing a SSIS package, trying to update an existing SQL table from a CSV flat file. All of the columns are successfully updating except for one column. If I ignore this column on truncate, my package completes successfully. So I know this is a truncate problem and not error. This column is empty for almost every row. However, there are a few rows where this field is 200-300 characters. My data conversion task identified this field as a DT_WSTR, but from what I've read elsewhere maybe this should be DT_NTEXT. I've tried both and I even set the DT_WSTR to 500. But none of this fixed my problem. How can I fix? What data type should this column be in my SQL table? Error: 0xC02020A1 at Data Flow Task 1, Source - Berkeley812_csv [1]: Data conversion failed. The data conversion for column "Reason for Delay in Transition" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.". Error: 0xC020902A at Data Flow Task 1, Source - Berkeley812_csv [1]: The "output column "Reason for Delay in Transition" (110)" failed because truncation occurred, and the truncation row disposition on "output column "Reason for Delay in Transition" (110)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component. Error

Determining the status os the Batch job that process SSAS Cubes

Hi All, I have a cube and that is processed through a batch job. The problem I am facing is there are many packages which are calling this Batch job to process the cube. Is there a way to determine the state of the job before the packages call this batch job to process the cube. And in which database can I find all the information about the jobs on the server. Thanks for your help. Vineeshvineesh1701

The subscription status of the object could not be changed

Good day to all.. I have a problem. There are two sql servers with transactional replication Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64) Mar 29 2009 10:11:52 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 <X64> (Build 3790: Service Pack 2) There was a table function without parameters, included in articles of publication. Then I had to change it with adding one parameter. I've changed it via alter function on the publisher. And then replication stopped with error message about invalid argument count in this function. I've decided to reinitialise subscribtion with new snapshot, but new snapshot can't be created ("The subscription status of the object could not be changed"). Then I've decided to drop this subscription and recreate it, but I can't drop it (same error - "The subscription status of the object could not be changed").. Dropping publication also was unsuccesfull. How I can repair replication now?

How do i resize teh status bar items?

hi friends, i have the following status bar and i have added a color scheme so the it's clear what im asking of:     here what i want: 1. How do i set the statusstrip item colored in black to change it's length when teh form resizes and and i want all the other statusstrip items to have fixed size (that doesnt change) when form resizes? 2. How do i set the status strip item colored with pink and blue to fixed length but all others changes its lenght when form resizes? thanks

While calling Web service gets exception "The request failed with HTTP status 401: Unauthorized"

Hi All, I created a ASP.NET web service, which was hosted on default visual studioserver, and on excecution of webservice it run .exe file which in turn update xml file. Now i hosted this webservice on IIS 6.0 server, and when i run the service, itfails to execute the exe.When i run it on debug mode, i never get any exception.Code...public string HelloWorld()    {        Process myProcess = new Process();        try        {            myProcess.StartInfo.UseShellExecute = false;            // You can start any process,             myProcess.StartInfo.FileName = @"E:\Projects\some.exe";            myProcess.StartInfo.CreateNoWindow = true;            myProcess.Start();            myProcess.Close();            myProcess.Dispose();            return "Suceess";         }&n

SQL Server VSS Writer "Status"

Hello, I have an HP Server running Win 2008 R2 Ent. X64 SP2 with Hyper-V and been having issues with Windows Server Backup. My original post can viewed here http://social.technet.microsoft.com/Forums/en-US/winserverhyperv/thread/6a20c2e9-499e-4ae3-9c21-f6a6971d9e5f/#676611f6-1d1f-4c1c-84f8-84f6bae9187b I have read a lot of forums and article and done windows update, but could not get the Windows Server Backup to work manually or on scheduled time. The above link shows the list of errors when the backup runs. When I opened the Service list I noticed that SQL Server VSS Writer had a status of "Starting" and startup type "Automatic". When I stopped the service I managed to get the backup to work manually and on it scheduled time. Should this service be stopped and set to automatic or should be started and automatic? Thanks..

Send alerts based on approval status

Hello, I have a list of posts on blog site and set alerts on this list. The problem is that every time I post a new blog entry an alert is sent to the users despite the approval status of this post. So every edit attempt causes a new alert. The users does have only read permission set on this Post list. Is it possible to configure the alerts so the alert is being sent only when the post status is set to approved? BR, Tomek

Visual Studio asp C#.NEt web application publishing tweet/status on Twitter/Facebook

Hi guysIf you could give me some guidelines It would mean a lot to me. what type of authentication I use, how to do  id from localhost, how to modify web.config file etc 
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