Forum Replies Created

Viewing 15 posts - 3,136 through 3,150 (of 9,725 total)

  • RE: Sleeping Log Reader Agent blocking Distribution clean up job

    Are you not replicating index changes over to the subscriber?

    Let us know if your fix doesn't fix and we'll take it from there.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Manually failing over a mirror without access to Primary Server

    Thanks, Perry. I appreciate the assist.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: How to Check SQl Driver for MS ACCESS

    Check your connection strings (scroll down to find 2007 and on) compared to this document[/url].

    Have you verified the drivers on your pc and the server via the method I mentioned...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Compare two columns

    My problem is that he still hasn't explained in English what he expects the result to be. I told him specifically NOT to explain it in code and that's what...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: SQL Server US Contracting Rates

    lptech (8/18/2014)


    Try looking on Indeed.com or Dice.com and see what rates companies are offering in their postings in your target area.

    Usually those companies' websites lead back to salary.com for the...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: How to Check SQl Driver for MS ACCESS

    Shaun2012 (8/18/2014)


    The error im getting is "Test connection failed because of an error in intializing provider. Unrecognized database format "C:\ABC\MYFILE.accdb"

    I've never seen "accdb" as an extension to an Access Database....

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: How to Check SQl Driver for MS ACCESS

    Shaun,

    What is the exact error you are receiving?

    Going into Control Panel -> Admin tools -> ODBC and starting the steps of creating an ODBC will list what drivers you have...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: sql question

    FYI: He said to group by the count of actors, not by the title.

    EDIT: Look up the HAVING clause.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Script Generator in table designer?

    If I'm not mistaken, the script generator is including that in the ALTER statements because the FK was created without the "WITH CHECK" option. I am fairly certain any FK...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Prevent RENAME of a database

    Try as I might, I can't seem to get this to work. What really annoys me is those ALTER DATABASE and sp_renamedb messages. Looking at the text of sp_renamedb, it...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Prevent RENAME of a database

    Igor Micev (8/15/2014)


    ...this is the code

    ALTER TRIGGER ddl_trig_REname

    ON ALL SERVER

    FOR RENAME

    AS

    BEGIN

    DECLARE @data XML;

    DECLARE @database nvarchar(100);

    DECLARE @eventType varchar(50);

    ...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Add a total column

    M Joomun (8/18/2014)


    Hello both,

    Thanks for your replies.

    As to the table schema, tblPerson - tblManagementOfBleeding is a 1 ~ 1. I've attached screenshots which give more detail. Do you need anything...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: System Tables for Database Mirroring

    Beatrix Kiddo (8/18/2014)


    Ah, you beat me to it! I finally knew something, too :-D.

    I appreciate the thought. @=)

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Add a total column

    Without DDL and sample data, here's my first thought:

    SELECT YearRecruited, Hospital, Jan, Feb, Mar, Apr, May,

    Jun, Jul, Aug, Sep, Oct, Nov, Dec, MyCounter,

    (Jan + Feb + Mar +...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Backup SQL settings?

    Copied is good. Let us know if you need any additional fodder to help with your case for a more robust solution.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 15 posts - 3,136 through 3,150 (of 9,725 total)