Forum Replies Created

Viewing 15 posts - 3,346 through 3,360 (of 7,164 total)

  • RE: Today's Random Word!

    ChrisM@Work (8/22/2012)

    SQLRNNR (8/21/2012)

    Warble

    Wobble

    Bobble

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

    August 22, 2012 at 3:55 am

    #1528534

  • RE: Today's Random Word!

    rhythmk (8/21/2012)

    bcsims 90437 (8/21/2012)

    crookj (8/21/2012)

    SQLRNNR (8/21/2012)

    Warble

    weeble

    Weevil

    WOTD: YUCK

    Reveal

    Divulge

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

    August 21, 2012 at 10:19 pm

    #1528439

  • RE: Problem migrating CLR Assembly from 32-bit to 64-bit environment SQL 2005/OLEDB/VFP

    I am not sure you can target the x86 platform and have it run within an x64 instance as it will be executing in an x64 thread. You could target...

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

    August 21, 2012 at 9:57 pm

    #1528433

  • RE: Get-WMIObject Win32_Volume fails on proxy account from Agent Job

    I doubt it, but if it makes you feel any better I can recreate your issue on Windows Server 2008 R2 and SQL Server 2008 R2. I created a Local...

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

    August 21, 2012 at 1:55 pm

    #1528357

  • RE: Sending remote attachments using sp_send_dbmail

    How is it going?

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

    August 21, 2012 at 11:55 am

    #1528297

  • RE: user mapped as dbo

    Excellent. Thanks for posting back that you were able to resolve the issue.

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

    August 21, 2012 at 11:54 am

    #1528295

  • RE: Using the WMI Event Watcher Task in SSIS to Process Data Files

    mtassin (8/21/2012)

    Thanks,

    The Konesans' task is just what I needed.

    Normally I'm pretty nervous about 3rd party plugins for SSIS, but this is the right tool for the right task in...

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

    August 21, 2012 at 11:45 am

    #1528289

  • RE: No blocking, queries running slowly, what to check next?

    You're welcome. If it stays in the realm of databases you're probably OK, i.e. in the same boat most of the rest of us have been at one time or...

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

    August 21, 2012 at 10:33 am

    #1528236

  • RE: No blocking, queries running slowly, what to check next?

    Good, at least someone set it. It's impossible for me to say if that number is appropriate because it will depend on what else runs on the database server.

    Chapter 4:

    Troubleshooting...

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

    August 21, 2012 at 10:18 am

    #1528226

  • RE: No blocking, queries running slowly, what to check next?

    I like the Read Committed Snapshot iso level and recently enabled it in a database supporting a vendor app that could not be modified and it worked wonders.

    One other angle,...

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

    August 21, 2012 at 8:53 am

    #1528164

  • RE: Using the Konesans File Watcher Task in SSIS to Process Data Files

    tonyclifton77 (8/21/2012)

    thanks for the explanation.

    I've tried setting up my project like your sample pic, but I only looped for 5 times. However I get an error when I put two...

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

    August 21, 2012 at 6:18 am

    #1528078

  • RE: OS 64 Bit, SQL 32 Bit

    In addition to Linked Servers (including adhoc uses via OPENQUERY, OPENDATASOURCE and OPENROWSET) calling an external app using xp_cmdshell can be affected if the called apps cannot run in a...

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

    August 20, 2012 at 2:49 pm

    #1527867

  • RE: Scripting out grants for 'sa', 'securityadmin' type rights

    JeremyE (8/20/2012)

    This should do it

    CREATE TABLE #srvroles(ServerRole VARCHAR(20), Membername VARCHAR(200), MEMBERSID VARBINARY(MAX))

    GO

    INSERT #srvroles EXEC sp_helpsrvrolemember

    SELECT 'EXEC master..sp_addsrvrolemember @loginame = N'+''''+MemberName+''''+','+'@rolename = N'+''''+ServerRole+''''

    FROM #srvroles

    GO

    DROP TABLE #srvroles

    That will give you Fixed...

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

    August 20, 2012 at 2:33 pm

    #1527863

  • RE: Giving users the right to execute a query w/o access to table

    Tom Van Harpen (8/17/2012)

    our general policy is to not provide direct data access to any user or group in the company for our data warehousing. Read access is generally controlled...

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

    August 20, 2012 at 1:34 pm

    #1527829

  • RE: user mapped as dbo

    sage8 (8/20/2012)

    This is not the database owner, another account is (but not sa).

    That does not add up.

    I will try to change ownership to sa.

    How did it go?

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

    August 20, 2012 at 1:03 pm

    #1527808

Viewing 15 posts - 3,346 through 3,360 (of 7,164 total)