Forum Replies Created

Viewing 15 posts - 76 through 90 (of 102 total)

  • RE: permission to view and edit to particular user job

    Sorry Small correction.

    User what to see only his jobs and he should not have any edit permission or modify permission of his jobs

    .He should have only read permission on...

  • RE: To create the sql server health check

    Thanks for reply,

    I am not having experience on development part.can you please help me out

  • RE: How to look the wait statistics SQL collects

    I have exectued the Below query which i found in the goolge

    "

    WITH Waits AS

    (SELECT wait_type, wait_time_ms / 1000. AS wait_time_s,

    100. * wait_time_ms / SUM(wait_time_ms) OVER() AS pct,

    ROW_NUMBER()...

  • RE: How to look the wait statistics SQL collects

    Thanks for providing the Script.

    I have executed the query but there was no out put displayed at present.

    Can you please tell me do i need to collect the data at...

  • RE: SSIS

    From JOb-properties-Steps- i could see the below path in the "command line "

    /FILE " F:\MSSQL10.MSSQLSERVER\MSSQL\SSIS_WMT\WMT_ Data Import.dtsx " /X86 /CHECKPOINTING OFF /REPORTING E

    Can you please clarify...

  • RE: SSIS

    Can you please tell me where to look in the jobs that packages are stored.

    I have checked in the job and package source is "FILE SYSTEM"

    I have connected the SSIS...

  • RE: SPN

    Hi have executed the command and i found the below information

    "

    C:\>setspn -L <SERVERNAME-A>

    Registered ServicePrincipalNames for CN=<SERVERNAME-A>,CN=Computers,DC=<Domain>,DC=

    com:

    tapinego/<SERVERNAME-A>

    ...

  • RE: SPN

    Even after restarting the server i am seeing same error in the error log.

    i am not understanding whether spn is registered or not.

  • RE: DB Mail

    when telnet smtpserver ie. telnet <smtpserver name > 25

    am getting below error

    " could not open connection to the host on port 25:connect failed "

  • RE: DB Mail

    Can you please tell me how to check the above diagnostics things .

  • RE: DB Mail

    i have checked and "mail session " in sqlagent is in enabled state.

  • RE: Application error

    sql server is 2008.

    Can you please tell which provider should be used as client is facing some connecting string error.

    The connection statement looks like this:

    conn.open "Provider=SQLNCLI10; Data Source='xxxxxx';Initial Catalog='yyyyyyyy';User...

  • RE: Application error

    Please let me know how to solve it.

  • RE: rebuild index

    I have checked the log i found the below information.I cound not see any error no 2725.Please see the below information and please help me.

    "

    Microsoft(R) Server Maintenance Utility (Unicode) Version...

  • RE: SQl Cluster

    It is win 2003 server.

Viewing 15 posts - 76 through 90 (of 102 total)