And I don't see a service that using my own account.

There is no SQL agent job runs in my account.

Thanks

Thank you,

It is from my local machine:

Date8/17/2015 5:34:19 AM

LogSQL Server (Current - 8/17/2015 8:21:00 AM)

SourceLogon

Message

Login succeeded for user 'mydomain\myname'. Connection made using Windows authentication. [CLIENT: <local machine>]

Same thing happened to...

I tried to reboot the server multiple times.

I ended up clean up all the oracle client, including registry. And then start over to install something different. ODAC.

It finally works.

I uninstalled both Oracle 32 bit and 64 bits client ( I only installed the OLEDB driver and ODBC driver) totally from my windows machine, clean up the directories. reboot...

or use windows provider: this is the vb code,

could you help to convert it to c# code?

Const ADS_UF_PASSWD_CANT_CHANGE = &H40

Function UserCannotChangePassword(strDomain As String, strUser As String, strUserCred As String,...

I am trying use the first part of the code as solution,

but found out com object does not work well in SSIS code.

http://devblog.rayonnant.net/2011/04/ad-net-toggle-users-cant-change.html

Any way to convert the code and...

Sorry, that is not what I am asking.

I know login is at instance level, user is in the database level.

Let us remove the code about checking exists of the user.

If...

Thanks,

Yes, I do need to check if the user exists before I create the user for the login.

Even so, I think the create user statement should error out, because...

The developer got that error when calling from web application,

We are not using linked server. It works when it is using SQL 2000, after I migrate this database to SQL...

Yes, I rarely do that too, but if it is a very simple change, I do that to save time.

Just curious if SQL server have ability to do that -...

Do you mean manually enter getdate(), and hit tab, it will show the datetime, that does not work for me, it says invalid value for cell.

This table has no default...

Thanks, if no default set, there is really no way to enter a function or something in the cell to get today's date, but just manually type one digit by...

We used to have a codeSmith tool that generate procedures for tables for some existing databases, but it is very old version.

I am wondering in SQL server if we can...

Thank you, yes you are right they are updating all non-primary key of the table.

Your answer is very helpful, thanks.

I will check into index fragmentation. and contact vendor if there...

Thank you, yes the session is blocked by other sessions doing the same query with different parameters

The query is:

(@p0 datetime,@p1 datetime,@p2 bigint,@p3 datetime,@p4 datetime,@p5 bigint,@p6...