Forum Replies Created

Viewing 5 posts - 46 through 51 (of 51 total)

  • RE: Dealing with foreign keys when copying data

    Provided you're not on a live production db, this may suffice, depending on structure of your db/constraints:

    -- Turn off refer integ on a table

    ALTER TABLE [TableName] NOCHECK CONSTRAINT ALL

    ALTER TABLE...

    -MarkO

    "You do not really understand something until you can explain it to your grandmother" - Albert Einstein

  • RE: Importing Cisco System Commander Text Dumps

    ...I beleive these are ragged right formatted files...

    To get this to work you really hafta know the structure of the file. What are the delimiters?; are there file headers...

    -MarkO

    "You do not really understand something until you can explain it to your grandmother" - Albert Einstein

  • RE: Cursor

    Here's a template for a generic cursor. See BOL for details.

    -----------------------------------------------------------

    -- to reduce traffic don't bother with display of row count

    set nocount on

    -- define the cursor --

    declare @object...

    -MarkO

    "You do not really understand something until you can explain it to your grandmother" - Albert Einstein

  • RE: Transfer of Data from one table to another table

    - Open Management Studio

    - In the Object Explorer pane, expand SQL Server Agent

    - Right Click 'Jobs': choose 'New Job...'

    - On General Page: fill in Name field: "Job Whatever"

    - On Steps...

    -MarkO

    "You do not really understand something until you can explain it to your grandmother" - Albert Einstein

  • RE: Text editor to copy n lines after occurence of search pattern

    UltraEdit

    http://www.ultraedit.com/

    -MarkO

    "You do not really understand something until you can explain it to your grandmother" - Albert Einstein

Viewing 5 posts - 46 through 51 (of 51 total)