Forum Replies Created

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

  • RE: Database mail error

    Sue_H - Tuesday, April 25, 2017 10:56 AM

    Is the service account for SQL Server Agent in the sysadmins role?
    Try running...

    April 25, 2017 at 11:02 am

    #1939798

  • RE: Database mail error

    Thom A - Tuesday, April 25, 2017 9:45 AM

    That would suggest you aren't a sysadmin, if you're getting write permissions. What does...

    April 25, 2017 at 9:49 am

    #1939787

  • RE: SQL server database engine account question

    I changed through the configuration manager.

    March 15, 2017 at 9:23 am

    #1933271

  • RE: SSIS project Deployment error

    bmg002 (1/10/2017)

    Sounds to me like the password is incorrect. The database master key is not the same thing as the sa password or anything like that normally unless you...

    January 10, 2017 at 1:35 pm

    #1921746

  • RE: Performance monitor counter question

    Igor Micev (10/25/2016)

    Guras (10/25/2016)

    Igor Micev (10/25/2016)

    Guras (10/25/2016)

    Counter_name : Counter_Value

    User Connections: 316

    Batch Requests/sec : 20

    SQL compilations/sec : 36

    SQL Recompilations/sec : 20

    Is this normal? Does the SQL compilations/sec seem high?

    Thanks

    It's...

    October 25, 2016 at 12:18 pm

    #1908728

  • RE: Performance monitor counter question

    Igor Micev (10/25/2016)

    Guras (10/25/2016)

    Counter_name : Counter_Value

    User Connections: 316

    Batch Requests/sec : 20

    SQL compilations/sec : 36

    SQL Recompilations/sec : 20

    Is this normal? Does the SQL compilations/sec seem high?

    Thanks

    It's just a very...

    October 25, 2016 at 10:01 am

    #1908669

  • RE: ALTER DATABASE permission error

    This returns 0 but it's strange that my username is the member of the server role sysadmin if I check it in the Security section through SSMS.

    October 19, 2016 at 1:04 pm

    #1907515

  • RE: ALTER DATABASE permission error

    Perry Whittle (10/19/2016)

    Guras (10/18/2016)

    ALTER DATABASE DB1

    SET SINGLE_USER WITH ROLLBACK IMMEDIATE

    This is giving me the following error and I am in the sysadmin server role...

    October 19, 2016 at 1:03 pm

    #1907514

  • RE: SQL help

    Luis Cazares (7/28/2016)

    So, are you good now?

    Yes, thanks for checking. When you mentioned Max it pointed me to the right direction.

    Thanks

    July 29, 2016 at 7:24 am

    #1892638

  • RE: SQL help

    Luis Cazares (7/28/2016)

    Why does record_id 2 ends up with value 'col1' for colname?

    Have you tried using MAX() and MIN() to aggregate rows?

    Sorry typo

    It's col2 for all.

    July 28, 2016 at 1:37 pm

    #1892545

  • RE: Tracing data movement through backend SQL stored procedures and functions

    What do you mean by data movement? Are you trying to see what was the before and after value of a field after an updation?

    July 28, 2016 at 10:15 am

    #1892518

  • RE: SSIS Question - multiple threading

    John Rowan (4/13/2016)

    If it's not a finite list, trying to run the load in parallel is going to be very difficult. Since you have to dynamically set the destination...

    April 13, 2016 at 2:02 pm

    #1871858

  • RE: SSIS Question - multiple threading

    John Rowan (4/13/2016)

    Where are the dynamic database names coming from? A table? Is it a finite list of destinations or will they need to be changed, added to?

    Running...

    April 13, 2016 at 12:53 pm

    #1871844

  • RE: SSIS Question - multiple threading

    John Rowan (4/13/2016)

    So then the Destination database is changing? What part of the connection string is changing?

    Data Source=serverA;Initial Catalog=database1;Provider=SQLNCLI11.1;Integrated Security=SSPI;Auto Translate=False

    The "database1" changes and I need to run the...

    April 13, 2016 at 11:19 am

    #1871810

  • RE: SSIS Question - multiple threading

    John Rowan (4/13/2016)

    How are you determining the Destination servers? Are they a set group of servers, or will the destinations be changing?

    The destination server remains the same only the...

    April 13, 2016 at 10:40 am

    #1871794

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