Forum Replies Created

Viewing 15 posts - 526 through 540 (of 583 total)

  • RE: PBM Alert

    Excellent question. Thanks Jason!

    July 22, 2011 at 5:33 am

    #1356958

  • RE: Login Properties

    george sibbald (7/21/2011)

    The question does specifically say SQL208 and for sa.

    For any SQL authenticated account I get 1900-01-01, for windows accounts I get NULL

    That goes with what I've seen in...

    July 21, 2011 at 7:02 am

    #1356331

  • RE: Login Properties

    Ninja's_RGR'us (7/21/2011)

    Steve specifically says that the server is a new install in windows mode which would make me assume that SA has never,ever logged in.

    He also said the server was...

    July 21, 2011 at 6:48 am

    #1356308

  • RE: Login Properties

    cengland0 (7/21/2011)

    Did you change the security setting to mixed mode prior to running the code? I suspect that's the clue. When the security mode is changed, it converts...

    July 21, 2011 at 6:25 am

    #1356296

  • RE: Login Properties

    I tried it on a backup server (2008). Didn't want to cycle the server, so I chose a user that was set up, but for which I knew they had...

    July 21, 2011 at 6:06 am

    #1356278

  • RE: That case filter

    Ninja's_RGR'us (7/20/2011)

    You're welcomed. So when's the last time you faced a similar issue like I did?

    I make mistakes all the time. People that type like I do seldom go...

    July 20, 2011 at 6:19 am

    #1355514

  • RE: Retrives the subject wise highest marks list in a table

    Tell your teacher to stop showing you problems with poorly designed databases.

    July 20, 2011 at 5:55 am

    #1355496

  • RE: That case filter

    I missed it fair and square. I totally missed the extra UNION ALL.

    As to the spirit of the question, I have conflicting thoughts. I appreciate Ninja's_RGR'us's attempt to get...

    July 20, 2011 at 5:51 am

    #1355492

  • RE: DBF file with Thai Characters

    graham 47698 (7/17/2011)

    Hi

    I have been given a number of dbf files to import into sql tables..

    I am using SSIS 2008 to do the import and all works fine except...

    July 18, 2011 at 6:27 am

    #1354187

  • RE: Time Varing Numerical Quantity

    sqlTechie (7/11/2011)

    Hi All,

    I have a quick question,

    Kindly give an example of a real business situation where neither a star nor a snowflake schema can be used to represent that data.

    I...

    July 18, 2011 at 6:16 am

    #1354182

  • RE: TDE and Filegroups

    Being more of a DB programmer than an admin at the moment, this was a good excuse to learn something I ought to know, certainly in the near future. Thanks...

    July 18, 2011 at 6:06 am

    #1354177

  • RE: Database Snapshot

    stewartc-708166 (7/15/2011)

    To add a slighly different spin on things - I'm sure people learned something, as they will have done a bit of homework to make sure of their answers...

    July 15, 2011 at 6:04 am

    #1353356

  • RE: Can anybody tell a good site for learning Erwin data modeler

    Koen Verbeeck (7/13/2011)

    bob 38390 (7/13/2011)

    Koen Verbeeck (3/15/2011)

    A tutorial:

    You would be surprised what results you'll get when you search google with "erwin tutorial".

    .

    Why can't people just post a link without the...

    July 14, 2011 at 5:53 am

    #1352719

  • RE: Controlling I/O

    Thanks for the question. Your explanation improved on the BOL entry by explicitly mentioning the reason to separate I/O and processing masking.

    July 13, 2011 at 5:54 am

    #1352089

  • RE: SQL Server Browser

    Thanks for the question. Learned a few things.

    July 12, 2011 at 6:16 am

    #1351515

Viewing 15 posts - 526 through 540 (of 583 total)