Forum Replies Created

Viewing 15 posts - 2,506 through 2,520 (of 7,164 total)

  • RE: DBCC_CheckDB Error in Index

    https://connect.microsoft.com/SQLServer/feedback/details/775884

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 5, 2013 at 1:01 pm

    #1574077

  • RE: MSSQL Promotion Account Privilege

    jl-820778 (1/4/2013)

    Thank you for your clarification and link. It's very helpful.

    Now, I'm getting convinced that db_owner is the right one to give but still have some dilemma. From time to...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 4, 2013 at 2:03 pm

    #1573950

  • RE: Trying to analize a Deadlock Graph

    I was typing while you guys had two more responses, sorry if my last post seemed redundant.

    From the resource-list it looks like you might have things accessing resources in a...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 4, 2013 at 1:15 pm

    #1573933

  • RE: Trying to analize a Deadlock Graph

    Here is the prepared SQL from one of the processed shown in the graph (re-formatted by me). Does it look familiar?

    (@P1 DECIMAL(15, 6),

    ...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 4, 2013 at 12:50 pm

    #1573925

  • RE: MSSQL Promotion Account Privilege

    jl-820778 (1/4/2013)

    Thanks for your quick reply.

    So, DBO would have absolute power to change anything within specific database even schema, trigger and etc?

    Is there any limitation for dbo within database?

    dbo is...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 4, 2013 at 12:26 pm

    #1573912

  • RE: MSSQL Promotion Account Privilege

    What you want to do is add the Database User as a member of the db_owner Fixed Database Role:

    USE YourDatabase;

    EXEC sys.sp_addrolemember

    @rolename = N'db_owner',

    ...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 4, 2013 at 12:24 pm

    #1573911

  • RE: A SSIS Question

    Evil Kraig F (1/4/2013)

    opc.three (1/4/2013)

    The way I am viewing it is that SSIS will try to use a file regardless of whether it can gain exclusive access to it or...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 4, 2013 at 12:00 pm

    #1573901

  • RE: Script to know who is logged o to the server

    Get-TSCurrentSession | Get-Member

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 4, 2013 at 11:54 am

    #1573896

  • RE: Instant File Initialization

    Look at the SQL Server Error Log to see how long each step in the creation of a new database took. Post the messages here if you have doubts.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 4, 2013 at 11:23 am

    #1573885

  • RE: A SSIS Question

    Evil Kraig F (1/4/2013)

    opc.three (1/4/2013)

    Evil Kraig F (1/3/2013)

    Agreed. I was not saying the code you showed doesn't have a place, only that it is more prone to having a problem...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 4, 2013 at 11:08 am

    #1573881

  • RE: Instant File Initialization

    See the section "How to Check if Instant File Initialization is Enabled" here: http://www.johnsansom.com/sqlserver-instant-file-initialization/%5B/url%5D

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 4, 2013 at 9:05 am

    #1573810

  • RE: Instant File Initialization

    Perry Whittle (1/4/2013)

    During a restore the database engine is laying down the data pages from the backup to disk, this is not instant file initialisation!

    Instant file initialisation will be noticeable...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 4, 2013 at 8:58 am

    #1573803

  • RE: Let Users Execute DTS/SSIS Packages in Scripts ?

    Upgrade to SQL Server 2012? catalog.start_execution (SSISDB Database) Let me guess, not a likely option.

    You are right to deny access to xp_cmdshell, ideally disabled. SQLCLR is a recommended replacements for...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 4, 2013 at 8:49 am

    #1573791

  • RE: creating a linked server from sql 2005 to sql 2008

    I do not have an environment to test but I thought I would throw this out there. SQLNCLI is the SQL Native Client (i.e. the OLE DB driver) for SQL...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 4, 2013 at 8:44 am

    #1573788

  • RE: Using the Script Task in SSIS to Process Data Files When They Arrive

    msandbergen (1/4/2013)

    Seems like my problem has solved itself after I restarted Excel (using 2010). Now the file is processed properly as soon as I close Excel and even when I...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 4, 2013 at 8:39 am

    #1573785

Viewing 15 posts - 2,506 through 2,520 (of 7,164 total)