Forum Replies Created

Viewing 15 posts - 121 through 135 (of 783 total)

  • RE: How to verify SA password is not blank

    Leo.Miller (11/15/2011)

    You need to use the PWDCOMPARE function:

    Reat this article: http://msdn.microsoft.com/en-us/library/dd822792.aspx

    Use it like this,

    SELECT name FROM sys.sql_logins

    WHERE PWDCOMPARE('', password_hash) = 1

    OR PWDCOMPARE('', password_hash, 1) = 1 ;

    Cheers

    Leo

    Leo....Doesn't...

    Regards
    Sushant Kumar

    November 18, 2011 at 6:04 am

    #1409828

  • RE: Use of DATETIME and BETWEEN - Part 2

    Oops...I thot correct answer should be 3,4,5

    Didn't understand why it will round off when datatype is datetime.??

    Regards,

    Skybvi

    Regards
    Sushant Kumar

    November 18, 2011 at 5:40 am

    #1409819

  • RE: How to verify SA password is not blank

    @leo-2 & mark

    The script provided by you not working.

    Can you confirm it is working on your side?

    Regards,

    SKYBVI

    Regards
    Sushant Kumar

    November 17, 2011 at 1:57 pm

    #1409525

  • RE: Table space usage 2

    I would surely be a scientist, If i could perform that much calculations 😛

    I sincerely hope that Rest of the QOD questions does'nt have calculations like this much...

    Regards,

    SKYBVI

    Regards
    Sushant Kumar

    November 16, 2011 at 6:02 am

    #1408419

  • RE: Job History

    You can look :-

    C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\LOG

    that's default location of it, if you haven't changed it

    Regards,

    Sushant

    Regards
    Sushant Kumar

    November 8, 2011 at 5:55 am

    #1404415

  • RE: sql script to get a column count for every column in a table

    ACinKC (10/26/2011)

    Still kinda vague what you're asking for. You mean that you want counts for EACH column in the table (and not "one column")? In your example, why...

    Regards
    Sushant Kumar

    October 26, 2011 at 7:27 am

    #1399594

  • RE: How to check last full backup status and size for over 300 databases in over 150 sql servers

    Hi,

    You can create a SSIS project with execute SQL task having the query to get the db name, last backup sizes, time, where it is backed up...

    Regards
    Sushant Kumar

    October 19, 2011 at 8:47 am

    #1396684

  • RE: case statement help

    Can you tell us the output you would like to get based on the sample data you provided?

    Regards
    Sushant Kumar

    October 18, 2011 at 2:38 pm

    #1396341

  • RE: case statement help

    Mad-Dog (10/18/2011)

    i want only if colb = 'c:\1' while cola is 'first' and cola 'second' do not show the 'second'.

    The first and second are actual values in your table or...

    Regards
    Sushant Kumar

    October 18, 2011 at 11:51 am

    #1396240

  • RE: case statement help

    Your explanation is unclear,

    If I get you right, you can add up constraint on your table.

    --> To add constraint in your table design, to not insert duplicate values

    you need to...

    Regards
    Sushant Kumar

    October 18, 2011 at 11:23 am

    #1396223

  • RE: Constraints

    I guess the answer is wrong

    It should be 1 and 2 only

    beacuse only the constraint is violated,

    the sql statement is terminated.

    it doesn't look for other statements...

    just goes out of loop.

    Just...

    Regards
    Sushant Kumar

    October 17, 2011 at 7:07 am

    #1395293

  • RE: Login failed for user 'NT AUTHORITY\SYSTEM'

    Did you recently changed the password for the login?

    This happens when you have an application running on hte system using the login credentials

    and you change the password for the...

    Regards
    Sushant Kumar

    October 11, 2011 at 6:57 am

    #1392822

  • RE: Linked Server

    can you ping the remote server

    and

    also try to telnet the remote server

    wat u get?

    Regards,

    Sushant

    Regards
    Sushant Kumar

    October 6, 2011 at 11:32 am

    #1391348

  • RE: Can't connect; Login failed.

    John Mitchell-245523 (10/6/2011)

    Connecting to the wrong server? Caps lock on? Fat fingers? You're really going to have to work this one out for yourself, since none of...

    Regards
    Sushant Kumar

    October 6, 2011 at 8:34 am

    #1391230

  • RE: Can't connect; Login failed.

    cindyaz (10/6/2011)

    check if you have a default database set for this login ID.

    Yes, the default database is master.

    Regards,

    Sushant

    Regards
    Sushant Kumar

    October 6, 2011 at 8:32 am

    #1391229

Viewing 15 posts - 121 through 135 (of 783 total)