Forum Replies Created

Viewing 15 posts - 2,521 through 2,535 (of 3,221 total)

  • RE: testing the database during development?

    Keil.asta

    I then plan to build an interface for it using visual basic

    Using VB6 or VB dot net -either way. Using VB6 here is an extract form my code which allows...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Need a simple starter SSAS tutorial

    Use Microsoft TECHNET link directly below

    http://technet.microsoft.com/en-us/default.aspx

    In the search box input SSAS tutorials ... in return you will be given a list of over 300 free tutorials from Microsoft ....

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: DBA job not busy enough

    So far all the suggestions are those items that are a DBAs responsibility. What I would suggest is for you to think out of the box. What...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Exporting Data To Excel

    To start you out on your project may I suggest reading the following: (Note the article includes a sample code download which should get you started)

    http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Are the posted questions getting worse?

    GilaMonster ..... Gail Shaw

    That type of attitude and replies makes me want to walk away and stop posting.

    Please don't stop posting you have helped not only myself but hundreds of...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Importing Data from EXCEL

    From Bools On Line (BOL):

    ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/f47eda43-33aa-454d-840a-bb15a031ca17.htm

    OPENROWSET does not accept variables for its arguments.

    If you wish to use OPENROWSET you will have to construct a dynamic T-SQL statement and then Execute...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Are the posted questions getting worse?

    RbarryYoung

    The article link

    http://www.sqlmag.com/Articles/ArticleID/101736/101736.html

    but note:

    This article is subscriber-only access

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: cursor issue in sql 2005 sp3

    You might want to look at this article

    FIX: You may receive error messages when you use the sp_cursoropen statement to open a cursor on a user-defined stored procedure in...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Are the posted questions getting worse?

    Bob Hovious

    That is an impressive number of views. I always felt that The Thread is a large part of what makes SSC seem more like a community, rather than just...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Are the posted questions getting worse?

    An off the wall question and defintely NOT related to SQL Server in any way manner shape or form ..... but for the unappreciated DBA's / Developers who frequent this...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Rename objects

    Edited after post by

    beezell

    If you create a view and use the sp_rename stored proc you can rename it. This might be an error in BOL.

    Must be so, did...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Rename objects

    Reference: sys.objects: (BOL)

    ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/f8d6163a-2474-410c-a794-997639f31b3b.htm[/url

    O.K. someone explain to me where I went wrong. From sys.objects, type column appears:

    type char(2) Object type:

    . . . . . .....

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Are you a Military Vet?

    RBarryYoung (5/22/2009)


    bitbucket (5/22/2009)


    For those old enough to remember Korean Peace Keeping otherwise known as the Korean War

    !!!

    bitbucket, You're 75???

    Nope not 75 ... born April 1932 ... which according...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Nested Trigger Not working...

    Have you checked BOL to determine the setting for Nested Triggers?

    http://msdn.microsoft.com/en-us/library/ms191520.aspx It could have been set by someone so as to not allow nested triggers ... if it is...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Are you a Military Vet?

    For those old enough to remember Korean Peace Keeping otherwise known as the Korean War

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

Viewing 15 posts - 2,521 through 2,535 (of 3,221 total)