Forum Replies Created

Viewing 15 posts - 4,891 through 4,905 (of 9,722 total)

  • RE: Access to SQL Server

    SQLKnowItAll (1/12/2012)

    I'm just saying that if this is a new install and you are the DBA you may HAVE to use sa at least once to set up domain logins...

    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.

    January 12, 2012 at 9:39 am

    #1432692

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (1/12/2012)

    I don't have the time I'd like to answer more questions, so I tend to answer in batches, but I learn every time I do.

    That's me. Too...

    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.

    January 12, 2012 at 9:36 am

    #1432689

  • RE: Access to SQL Server

    SQLKnowItAll (1/12/2012)

    Brandie Tarvin (1/12/2012)

    SQLKnowItAll (1/12/2012)

    Your domain account needs to be added to SQL Server as a user. You should log in as sa or have someone do that and add...

    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.

    January 12, 2012 at 9:30 am

    #1432678

  • RE: How to move a large table with images to another SQL database and link it.

    Dev (1/12/2012)

    Query on view will hit main database every time. Will it not consume the bandwidth? I believe that’s the main issues here.

    Bandwidth is network. I don't believe...

    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.

    January 12, 2012 at 9:12 am

    #1432640

  • RE: Can a computed column be made to read data from a stored procedure

    Paul,

    The rest of the discussion is happening here: http://www.sqlservercentral.com/Forums/Topic1234678-391-1.aspx

    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.

    January 12, 2012 at 9:05 am

    #1432628

  • RE: How to move a large table with images to another SQL database and link it.

    All,

    This is not quite a double post. There is other advice happening in a different thread on this same topic.

    http://www.sqlservercentral.com/Forums/Topic1234687-391-1.aspx#bm1234904

    I think Paul has it right that the OP should consider...

    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.

    January 12, 2012 at 9:04 am

    #1432623

  • RE: Powershell scripts fails when run through jobs

    I'm glad you figured it out. Thank you for posting the solution so others can find 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.

    January 12, 2012 at 7:22 am

    #1432498

  • RE: 2012 RC0 Failure

    This is what stands out to me.

    Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens...

    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.

    January 12, 2012 at 7:15 am

    #1432486

  • RE: Access to SQL Server

    SQLKnowItAll (1/12/2012)

    Your domain account needs to be added to SQL Server as a user. You should log in as sa or have someone do that and add you. DO NOT...

    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.

    January 12, 2012 at 6:58 am

    #1432470

  • RE: Can a computed column be made to read data from a stored procedure

    What you want to do is not the definition of a computed column. Computed columns aggregate data from other columns. What you're wanting to do is insert data into a...

    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.

    January 12, 2012 at 6:53 am

    #1432462

  • RE: How to move a large table with images to another SQL database and link it.

    kevin.smith-1067125 (1/12/2012)

    Hmmmm, separate filegroup and partial backup. Will look into that too. Do you think this preferable to the 'view' solution mentioned earlier? Thanks.

    You cannot restore a single filegroup or...

    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.

    January 12, 2012 at 6:49 am

    #1432458

  • RE: 2012 RC0 Failure

    What does the install log say?

    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.

    January 12, 2012 at 6:47 am

    #1432451

  • RE: Are the posted questions getting worse?

    GilaMonster (1/12/2012)

    Bex (1/12/2012)

    From someone who is a lurker on this site, I take the attitude that if I ask for free help and I don't like the reponses I am...

    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.

    January 12, 2012 at 6:46 am

    #1432449

  • RE: Powershell scripts fails when run through jobs

    I've never used Powershell, so I can't give you much help. Have you tried googling your error or parts of the error?

    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.

    January 12, 2012 at 6:39 am

    #1432439

  • RE: Can a computed column be made to read data from a stored procedure

    What exactly are you trying to accomplish here?

    If you give us more details and examples, we may be able to suggest an alternative.

    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.

    January 12, 2012 at 6:37 am

    #1432436

Viewing 15 posts - 4,891 through 4,905 (of 9,722 total)