Forum Replies Created

Viewing 15 posts - 181 through 195 (of 659 total)

  • RE: Permissions to EXEC SP

    Its the same same cod which you can see here

    http://technet.microsoft.com/en-us/library/bb838727.aspx

    Users got permissions error.

  • RE: List of Logins

    Have you tried exec above query.

    I get an error

    Msg 156, Level 15, State 1, Procedure sp_help_revlogin_specific_name, Line 23

    Incorrect syntax near the keyword 'ELSE'.

    when I clear that i get another errors.

  • RE: List of Logins

    What does this part do.

    --(change SQL_ACCOUNT_NAME, --NT_ACCOUNT_NAME, PASSSWORD)

    EXEC sp_addlinkedsrvlogin 'ADSI', False, 'SQL_ACCOUNT_NAME',

    'NT_ACCOUNT_NAME', 'PASSWORD'

    do i need to create sql login and also use my NT login there.

  • RE: List of Logins

    Yes, Please. Once if i can query that I can filter Logins used for sql server.

    thanks

  • RE: tempdb issue

    this query just pulls 3 million records but it runs for more than 2 hrs and then gives an error " temdb full" though i have 800GB free space.

  • RE: tempdb issue

    This is the query which is causing issue.

    select distinct e.code,startdate,enddate

    into #f

    from exams e

    inner join

    ...

  • RE: tempdb issue

    EXEC sp_spaceused gives me this result

    database_name= tempdb

    database_size= 318779.19 MB

    unallocated space= 317417.23 MB

    reserved= 1006096 KB

    data= 877584 KB

    index_size= 127944 KB

    unused=...

  • RE: Error running sql agent job

    But if i want to create a proxy for that non admin account, how wud i create a credential for that id unless i know that account pswd.

  • RE: Error running sql agent job

    What will be the windows id that is associated with proxy, can that be sysadmin or sql service account.

  • RE: Error running sql agent job

    Instead of doing this can i just change owner of the job to my login (sysadmin) and if i do it can they still run the job and also make...

  • RE: Error running sql agent job

    how do i do that?

  • RE: Backup Scripts

    Already i have files for each month and when i chek file groups from properties of database I see seperate file for each month. is there a way i can...

  • RE: Disk Space

    Thats a gud idea buti wud like to know something if tht is possible?

    Can select files something like

    " select files from the drive where not in temp table #t "...

  • RE: Setup Servers - Cost efective

    Can some one let me know if i can do this this kind of setup.

  • RE: Disk Space

    SQLBOT (1/9/2009)


    I don't think there's an easy way.

    My only suggestion is to use Windows search for .mdf and .ldf and cross reference it with your output from select physical_name from...

Viewing 15 posts - 181 through 195 (of 659 total)