Forum Replies Created

Viewing 7 posts - 1 through 7 (of 7 total)

  • RE: Archiving tables

    I use BCP to export AND Import data to flat files because I can generate the scripts and save them to a .bat file and run them with a scheduled...

  • RE: Microsoft - Love 'em or Hate 'em?

    quote:


    If it all worked - how many of us would not have a job


  • RE: What is a DBA???

    I agree with Antares686, this is diferent for every company. I've been working with SQL Server Databases for +- 3 years now and still don't see the letters DBA anywhere...

  • RE: Search a DB

    OK, now this is a script I wrote to find a value in DB without knowing where it might be. It is NOT optimized in any sense and because it...

  • RE: Tables Last Accessed...

    I'd be interested in knowing this too.

    My thoughts are maybe the statistics (if auto-generated) will have a last accessed date for a table. I guess if a table doesn't have...

  • RE: Microsoft - Love 'em or Hate 'em?

    Every OS Sucks!!!

    Hey, even good ol' DOS had limits and bugs. It seems as though people have forgotten that computers are just machines. What you put in is what you...

  • RE: Help with "table data type"

    Hey there,

    I don't know if this will help but have you heard of / tried this:

    EXEC sp_serveroption [<servername>] , 'data access', 'true'

    SELECT * INTO #<tablename> FROM OPENQUERY([<servername>], 'exec sp_who')

    SELECT...

Viewing 7 posts - 1 through 7 (of 7 total)