Forum Replies Created

Viewing 15 posts - 1 through 15 (of 51 total)

  • RE: INSERT MULTIPLE COLUMN DATA

    Thanks a lot 🙂

    March 11, 2014 at 5:29 am

    #1695903

  • RE: Find all the inactive Windows Logins

    Ok.

    Thank you for valuable time & coordination.

    February 7, 2014 at 4:54 am

    #1686978

  • RE: Find all the inactive Windows Logins

    John Mitchell-245523 (2/7/2014)

    So local Windows account instead of domain accounts? Exactly the same principle, except that the linked server process won't work. You'll have to search to find...

    February 7, 2014 at 4:46 am

    #1686975

  • RE: Find all the inactive Windows Logins

    One more thing which I want to ask again:-

    If the users(Windows Logins) are located in a single machine where the SQL Server exits then what should be the procedure.

    Kindly reply.

    February 7, 2014 at 4:31 am

    #1686971

  • RE: Find all the inactive Windows Logins

    Suresh B. (1/31/2014)

    Subrata Bauri (1/31/2014)

    Actually I want to list out all the inactive users(windows) which are not able to login into the OS & henceforth they are not able to...

    January 31, 2014 at 5:24 am

    #1685006

  • RE: Find all the inactive Windows Logins

    John Mitchell-245523 (1/31/2014)

    That information isn't stored in SQL Server. You'd need to set up a linked server pointing at your AD server, if your network admin will allow it.

    John

    I'm...

    January 31, 2014 at 5:03 am

    #1684997

  • RE: Find all the inactive Windows Logins

    Manoj Bhopale (1/31/2014)

    Use this query to find out disabled windows users/groups.

    SELECT name from sys.server_principals

    where is_disabled='1' and type_desc like '%WINDOWS%'

    This will work when users are disabled in SQL Level not...

    January 31, 2014 at 4:40 am

    #1684989

  • RE: Find all the inactive Windows Logins

    Thanks for your reply.

    I have few nos. of Windows Login Users in my Server System (OS & SQL Server Level) & One of them is blocked (Account is disabled in...

    January 31, 2014 at 3:09 am

    #1684964

  • RE: denylogin & hasaccess of syslogins

    Thank you Sir,

    Please clarify what is difference between Permission to connect to database engine and Login in the Login Properties windows ?

    January 30, 2014 at 10:05 pm

    #1684919

  • RE: Find all the inactive Windows Logins

    Thanks for your reply.

    Code executed in the SQL Server 2008 R2 Platform successfully But it does not give any result.

    January 30, 2014 at 9:54 pm

    #1684918

  • RE: How to create xml File in SQL

    <address>your mobile numbers</address>

    this will repeat on basis of how many Mobile number found.

    February 1, 2012 at 2:22 am

    #1441090

  • RE: Datetime

    drew.allen (9/13/2011)

    If you don't supply a time, it defaults to midnight (00:00:00.000). So the datetime that your comparing to is '2011-05-31 00:00:00.000' which is less than the datetime on...

    September 13, 2011 at 11:41 pm

    #1381048

  • RE: Datetime

    Thanks for instant reply.

    That is one I have in mind.

    September 13, 2011 at 6:49 am

    #1380575

  • RE: Database Migration

    Ignacio A. Salom Rangel (7/27/2011)

    Hi Subrata, Ninja's point is a very good one. If the application supports a newer version of SQL, it will be better to upgrade to a...

    July 27, 2011 at 11:22 pm

    #1359806

  • RE: Database Migration

    Ninja's_RGR'us (7/27/2011)

    I feel the need to point out that sql 2005 is about to go out of support.

    Any reason why you're not upgrading to 2008 R2? Or even Denali...

    July 27, 2011 at 11:18 pm

    #1359804

Viewing 15 posts - 1 through 15 (of 51 total)