Forum Replies Created

Viewing 15 posts - 46 through 60 (of 119 total)

  • RE: Merge Replication with SQL CE

    ok i also have the issue

    you talk about file permissions..on the IIS or the SQL replication data directory?

    my replication data looks fine as does the iis directory...

    could it have something...


    ------------------------------
    Life is far too important to be taken seriously

  • RE: Employee Retention

    would it be a fair call to say that loyalty and hence retention is more important in a small company than in a fortune 500 or large compaies?

    i...


    ------------------------------
    Life is far too important to be taken seriously

  • RE: Employee Retention

    I agree with mostly what you have written..loyalty is or should be a great strength that companies should have in their employees and vice versa...

    i do think that both are...


    ------------------------------
    Life is far too important to be taken seriously

  • RE: Delete System views in Replication

    Thanks for responses and i agree with you remi, however the publications were deleted and views etc left behind as the process didnt complete properly, this causes issues further down...


    ------------------------------
    Life is far too important to be taken seriously

  • RE: Informational Thoughts

    Interesting article,

    i think there are two types of values for a house, the value of a house (eg bricks and mortar) plus the land its on (position, location, shape...


    ------------------------------
    Life is far too important to be taken seriously

  • RE: Is it possible to restore a SQL Server 7.0 database backup to MSDE?

    yes you can restore SQL server backups to MSDE

    sql server7.0 can only have one locale/collation, you may be able to install msde7.0 with a specific collation...

    maybe also think about UPGrading...


    ------------------------------
    Life is far too important to be taken seriously

  • RE: More Visas

    yeah i agree too...but i would jump at the chance to work with microsoft or any other multinational/big corporation...even if they are based in America, or europe etc....and im in...


    ------------------------------
    Life is far too important to be taken seriously

  • RE: modify replicated table

    Because you are altering the actual articles (tables) I think you would have to reinitialize the subscribers

    Adding articles check BOL for these

    sp_addmergearticle

    sp_repladdcolumn

    sp_rename

    eg you can rename indexes etc

    sp_rename '[dbo].[TblGblBlahLevels].[111TblBlahImprLevels_PK]', 'a111TblBlahImprLevels_PK',...


    ------------------------------
    Life is far too important to be taken seriously

  • RE: Showing list of changes made to subscriber or publisher

    Thanks for the reply, I omitted to say what type of replication may be required., Im actually looking for merge which based on the link provided looks very useful

    will let...


    ------------------------------
    Life is far too important to be taken seriously

  • RE: How Was Your Weekend?

    sounds like a typical melbourne weekend down here in australia....!!

    except we just get bucket loads of rain instead of snow.....!

     

    good to see Sqlservercentral going 2005....will be a good way to...


    ------------------------------
    Life is far too important to be taken seriously

  • RE: VBscript

    Hi James

    did a quick search for vbscripts and array and found the following information which might help you.

    Also isnt the recordset a sort of array anyway ?

    http://www.winguides.com/scripting/reference.php?id=1

    Finally wouldnt sorting...


    ------------------------------
    Life is far too important to be taken seriously

  • RE: Application Error (SQL Server Error: 10048 )

    In resposne to Beni STS question,

    Has this just started happening, any other info you can provide may help

    is it a new report, new piece of code?

    finally i suppose...


    ------------------------------
    Life is far too important to be taken seriously

  • RE: Application Error (SQL Server Error: 10048 )

    HI,

    Ive seen the error from jimmy crackcorn before, you are right it does occur when running a large time consuming function, ive found it happens because of time outs that...


    ------------------------------
    Life is far too important to be taken seriously

  • RE: Congratulations Frank

    Congrats on the MVP recognition Frank, i think we all at SQl server central already knew this, good to see microsoft recognising this too

    yay !!

     

    Cheers

    Adam


    ------------------------------
    Life is far too important to be taken seriously

  • RE: Replication issue with Views

    hi

    Thanks for the reply

    im actually having a problem with merge replication

    a developer at our office has actually come across the solution, well actually identification of the problem,

    running the script...


    ------------------------------
    Life is far too important to be taken seriously

Viewing 15 posts - 46 through 60 (of 119 total)