Forum Replies Created

Viewing 15 posts - 31 through 45 (of 243 total)

  • RE: Recovery

    Ray Mond (3/6/2011)

    1. stopping the ms sql server services and restarting the windows machine.

    2. Restarting the windows machine without stopping the ms sql server .

    Option 1 is fine. ...

    March 6, 2011 at 4:37 am

    #1295081

  • RE: Recovery

    Thanks for your reply.

    Here my requirement is , i want to restart the windows machine in which ms sql server is running which one of the following would be best...

    March 6, 2011 at 2:08 am

    #1295074

  • RE: User does not have rights

    Thanks.

    February 27, 2011 at 3:01 pm

    #1292075

  • RE: Blocked Processes

    Adiga (1/22/2011)

    I am not sure how the monitoring tool that you are using the Blocking Process %. You may query sysprocesses, sys.dm_exec_requests to find more information about the blocking processes....

    January 23, 2011 at 10:19 am

    #1276985

  • RE: system assertion check has failed

    http://support.microsoft.com/kb/972511

    VSTS bug number | KB article number | Description

    308815 ...

    January 13, 2011 at 8:42 am

    #1273097

  • RE: "VS_ISBROKEN" error message

    brahma-324514 (10/1/2009)

    Hi,

    I got same kind of problem any help?

    me too got same issue. but i have resolved this issue by adding another one data flow on the ssis package,then copy...

    December 29, 2010 at 2:53 am

    #1267063

  • RE: Reporting service - Virtual Directory

    Hi,

    Yes, Thanks for your reply.

    December 15, 2010 at 10:11 pm

    #1263296

  • RE: Export/Import Task

    Jeff Moden (11/28/2010)

    sudhakara (11/25/2010)

    Hi,

    I am trying to copy the records from source server A to Destination server b by using the sql server task import/export wizard by using the query....

    November 28, 2010 at 7:05 pm

    #1256082

  • RE: Export/Import Task

    magasvs (11/27/2010)

    This will work if you use table variable instead of temp table:

    EXEC sp_executesql @statment = N' DECLARE @t1 TABLE

    (

    ID int

    )

    insert @t1

    select 1

    select * from @t1'

    Thanks for...

    November 27, 2010 at 9:38 pm

    #1255997

  • RE: Version of Services of MS SQL SERVER 2005

    Adiga (11/22/2010)

    You connect to SSIS, SSRS using SSMS. After connecting at the right side of the service, the version information is displayed as in this screenshot.

    Thanks for your reply...

    Is there...

    November 22, 2010 at 9:28 am

    #1253828

  • RE: SSIS ON SQL AGENT

    sqlbuddy123 (11/12/2010)

    Create a credential with the user account that created the package and then create an Agent SSIS proxy with that credential and then select the job step to run...

    November 14, 2010 at 4:15 pm

    #1250482

  • RE: SSIS ON SQL AGENT

    pavan_srirangam (11/12/2010)

    Did you check that you are not using sql server authentication?

    Yes i ensured that it using the windows authentication.

    November 14, 2010 at 4:13 pm

    #1250481

  • RE: SSIS ON SQL AGENT

    kyleheath33 (11/12/2010)

    Sounds like you are using the local system account to run the SQL agent but first lets check. Open the job from the SQL agent, rc properties, go to...

    November 14, 2010 at 4:12 pm

    #1250480

  • RE: SSIS ON SQL AGENT

    xparmanand (11/12/2010)

    Hi,

    Who is the Job owner?

    If it is not sa then change it to sa & try!

    Jobs runs under Sql Agent Service Account!

    Regards,

    Owner of the job has the sysadmin...

    November 14, 2010 at 4:07 pm

    #1250479

  • RE: SSIS ON SQL AGENT

    GSquared (11/11/2010)

    It's a multi-step AD authorization error.

    When you're running it, are you running it automatically, are you running it manually from a workstation, or are you running it while using...

    November 12, 2010 at 4:43 am

    #1249910

Viewing 15 posts - 31 through 45 (of 243 total)