Forum Replies Created

Viewing 15 posts - 4,996 through 5,010 (of 5,356 total)

  • RE: IMPORTING AN ASCII TEXT FILE DAILY

    Hello sbuckby,

    quote:


    We had exactly this same problem. Our client provides a work order system that we HAVE to use. We can extract...

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

  • RE: Decimal versus Money and division

    Ever been around with actuaries or top management?

    quote:


    This may be slightly off topic, but may be of some use. I spent...

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

  • RE: how to call stored procedures of SQLServer

    Hello darshit_99,

    quote:


    my problem is that I have a dynamic stored procedure which has 10 parameters such as @param1.....@param10. I have a asp...

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

  • RE: How to corrupt a db

    Hello Markus,

    quote:


    Here you have a script which corrupts the IAM of a table. Note that after running the script the table in...

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

  • RE: Transaction log backup failing

    Hello tmp,

    quote:


    Maybe you have the select into/bulk copy option checked in your db, and operations like bulk insert, bulk copies, truncate tables...

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

  • RE: Transaction log backup failing

    Hello Michael,

    quote:


    select into's


    are you sure about this?

    quote:


    See...

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

  • RE: Transaction log backup failing

    It is happening again!

    Again there are non-logged transactions where rollforward cannot be applied.

    What are non-logged transaction? I've read through BOL, but don't know much more as before. Is this...

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

  • RE: File Batch Rename

    Hello wongj5,

    quote:


    Let's say I have 6 Word documents (Worddoc1.doc, Worddoc2.doc, Worddoc3.doc........) that have been uploaded into a SQL Server 2000 table. The...

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

  • RE: Stored Procedures

    Hello Flavio,

    quote:


    SELECT * FROM [dbname].dbo.table_name_2

    work

    SELECT * FROM [serverName].[dbname].dbo.table_name_2

    not work ??


    see BOL, syntax conventions, Transact-SQL for...

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

  • RE: How to corrupt a db

    It seems that if you can't trust your DBA's, you'll have a problem...

    quote:


    Interesting!

    Hope there aren't any unscrupulous DBA's with a company grudge...

    --
    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,996 through 5,010 (of 5,356 total)