Forum Replies Created

Viewing 15 posts - 4,696 through 4,710 (of 5,356 total)

  • RE: Sorting

    quote:


    I have a sort order column which contains nulls and values. When sorting ASC, is it possible to float the rows...

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • RE: SQL Newie needs help

    quote:


    - How do i create a new database in server so i can add tables and fields etc.


    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • RE: manage the auto number myself

    quote:


    I don't want to use auto number, so when I do the insert, I will need to get the next ID column...

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • RE: Option to see threads that I'm involved in?

    quote:


    Stop! There is a way to do this. In any thread you have posted, click on your User Name and...

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • RE: New security hole

    quote:


    I don't put a lot of trust in getting everything sent from any one source. So I sign up for multiple ones....

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • RE: New security hole

    quote:


    3 came from NTBugTraq. 2 of them I got from Microsoft as well.


    maybe you are...

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • RE: 'table could not be loaded' error in EM

    quote:


    Yes you are right a5, when you see the tables from the EM, it may not show the tables in the Task...

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • RE: New security hole

    Hi Brian,

    quote:


    There were 3 that came out yesterday. I'm on several different security lists. But here are two good ones:


    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • RE: 'table could not be loaded' error in EM

    quote:


    I am getting a 'table could not be loaded message' from Eneterprise Manager after a restore. Could someone tell me why this...

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • RE: Presentations/SQL queries

    quote:


    Is using VB and chart controls a big task? I have basic/intermediate skills in VB..is it easy to pick up and...

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • RE: New security hole

    quote:


    SP4 has a lot of security patches in it. Just look at the slew of advisories that flew from Microsoft yesterday.


    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • RE: Archiving Changed Data

    quote:


    Trued to write a trigger for this table basing it on the example you posted .Where am l going wrong ?

    audit_Deleted


    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • RE: outer-join request that is not permitted

    quote:


    I have problem in running a query which has left outer joins and right outer joins in sql server. The same query...

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • RE: Archiving Changed Data

    quote:


    we've implemented this many times - in both financial and medical tracking apps - and one big tip i can give you...

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • RE: New security hole

    I guess this should accelerate any evaluations of SP4!

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • Viewing 15 posts - 4,696 through 4,710 (of 5,356 total)