Forum Replies Created

Viewing 15 posts - 4,156 through 4,170 (of 9,722 total)

  • RE: Developer Edition

    Lynn Pettis (7/23/2012)

    SQLRNNR (7/23/2012)

    Just grant them access to the Dev instance on the server rather than RDP. Then install management tools on their desktops and allow them to use...

    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.

    July 23, 2012 at 12:00 pm

    #1516393

  • RE: import data problem in SQL server 2008

    If this webhosting needs database restores, you really need to contact your DBA team. Obviously they didn't set up the correct permissions and they need to if you want to...

    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.

    July 23, 2012 at 8:39 am

    #1516277

  • RE: Weird Error

    Stefan Krzywicki (7/23/2012)

    Trace is likely my only hope.

    "Help me, Obi-Wan Tracenobi. You're my only hope!"

    Running away now. @=)

    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.

    July 23, 2012 at 8:34 am

    #1516272

  • RE: My DOUBT ..Please clarify

    Thank you, Lokesh. @=) Much appreciated.

    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.

    July 23, 2012 at 8:33 am

    #1516271

  • RE: Weird Error

    Wow. Okay. That is odd.

    I honestly don't know what to advise that hasn't already been suggestion. Sorry.

    EDIT: Except to ask... Are you positive that the job steps are calling against...

    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.

    July 23, 2012 at 8:18 am

    #1516254

  • RE: import data problem in SQL server 2008

    ali.mahmoud.habib (7/23/2012)

    PaulB-TheOneAndOnly (7/23/2012)

    Do not use export/import wizard, script your data load - first do your parent tables then your child tables as defined by Referential Integrity constraints.

    An alternative would be...

    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.

    July 23, 2012 at 8:17 am

    #1516253

  • RE: Starting SQL services - Best practise

    GilaMonster (7/23/2012)

    Only time there is a recommended route to stop/start is when it's a clustered instance and in that case you should use cluster admin.

    And if you don't, Bad Things...

    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.

    July 23, 2012 at 8:11 am

    #1516248

  • RE: Weird Error

    Stefan,

    If I'm understanding this correctly, the job exists on server A and the work is done on server B, yes?

    If this is true, the linked server login needs read execute...

    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.

    July 23, 2012 at 8:08 am

    #1516245

  • RE: My DOUBT ..Please clarify

    Now I'm curious. What is the "ed" command?

    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.

    July 23, 2012 at 8:06 am

    #1516241

  • RE: Are the posted questions getting worse?

    Hey, guys. I am getting absolutely no response on the fundraising for the wildfire & flood victims. Any suggestions on how I can sweeten the pot to get people to...

    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.

    July 23, 2012 at 4:13 am

    #1516128

  • RE: Are the posted questions getting worse?

    Networking is also a good topic to speak about. A lot of people want to know how to do 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.

    July 20, 2012 at 5:57 am

    #1515463

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (7/20/2012)

    Crap! My session on SQL Server HA for a conference was just rejected because another speaker already submitted a session on the same topic. Grrrr!

    I'm out of ideas...

    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.

    July 20, 2012 at 4:18 am

    #1515398

  • RE: Are the posted questions getting worse?

    Speaking of reading material... A few other SFWA members have offered some free books (some print, some ebooks) as part of the "Donate to the American Red Cross Disaster Relief...

    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.

    July 19, 2012 at 11:01 am

    #1515017

  • RE: SSIS Data Conversion

    Will it scan all the records or just the first 10-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.

    July 19, 2012 at 5:00 am

    #1514743

  • RE: Get Column name & table name from value

    lokeshvij (7/18/2012)

    both catalog view(sys schema) and information_schema views can be used.

    That works for the database. If I remember correctly, the OP is talking about a label box on a form...

    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.

    July 18, 2012 at 11:43 am

    #1514397

Viewing 15 posts - 4,156 through 4,170 (of 9,722 total)