Forum Replies Created

Viewing 15 posts - 376 through 390 (of 790 total)

  • RE: INNER JOINS

    Ok, why don't you see how many rows participate in original query. Change it to:

     

    select count(*)

    FROM transaction_new

    INNER JOIN departments on transaction_new.rec_dept = departments.rec_dept

    INNER...

    August 21, 2003 at 5:11 am

    #470732

  • RE: Triggers across servers.

    Triggers will work. But maybe replication will do it for you too? Anyhow, here's some sample trigger code...

     

    SET XACT_ABORT ON

    GO

    CREATE TRIGGER EMP_Update

    ON test.dbo.EMP

    FOR...

    August 20, 2003 at 11:05 pm

    #470694

  • RE: Storing files in SQL Server

    quote:

    Would I be able to use full text search on the column containing the file contents?

    August 20, 2003 at 10:22 pm

    #470692

  • RE: How to run Profiler Trace from another Server

    There's no reason why a server/workstation can't run OSQL to run the same SQL script on multiple SQL Servers, initiating an identical Profiler session on each.

    The script will...

    August 20, 2003 at 6:43 am

    #470577

  • RE: Backups looked after by shift operators

    You might try adding opsTeam as a db_backupoperator for all existing databases (including model). Change backup jobs so they're owned by opsTeam. To manipulate and rerun backup jobs...

    August 20, 2003 at 6:35 am

    #470573

  • RE: Rollback in Sql query window

    yep!

    Sometimes, I will even cover my rear further by doing something before the transaction, such as:

    select * into tempdb..orders from orders

    Sometime I'll take a prior full backup of the database.

    It...

    August 20, 2003 at 6:27 am

    #470572

  • RE: Rollback in Sql query window

    Not that I've ever made a mistake myself , but in QA I tend to precede statements/batches that affect live data with a BEGIN TRANSACTION. It's...

    August 20, 2003 at 6:14 am

    #470568

  • RE: QOD 8/20/03

    Are you running SQL 2000 or SQL 7?

    Cheers,

    - Mark

    August 20, 2003 at 6:09 am

    #470565

  • RE: Time in a conditional

    you can prefix your code with:

    set showplan_text on

    go

    BTW: in the 2nd INSERT did you mean to have different source and destination tables than in the first one?

    Cheers,

    - Mark

    August 19, 2003 at 3:28 pm

    #470485

  • RE: BCP: how to determine success or failure

    Is the controlling script a T-SQL script (running xp_cmdshell), a windows batch script, or something else?

    You can check for the "n rows copied." output from bcp.

    Cheers,

    - Mark

    August 19, 2003 at 3:17 pm

    #470484

  • RE: Time Conversion

    I wish I could claim it as my own idea. Just something I once pocketed from someone else's code.

    Cheers,

    - Mark

    August 19, 2003 at 2:57 pm

    #470478

  • RE: updates on new tables

    ...and the value of @@rowcount after the update should be 100.

    is it?

    What is the value of @@trancount?

    From (another) QA window, can you:

    select count(*) from genderpercentage where percentagefemale = 1

    or:

    select count(*)...

    August 19, 2003 at 4:57 am

    #470387

  • RE: updates on new tables

    How many rows are in the table?

    Cheers,

    - Mark

    August 19, 2003 at 4:40 am

    #470381

  • RE: updates on new tables

    What's the error message you're getting?

    Cheers,

    - Mark

    August 19, 2003 at 4:37 am

    #470378

  • RE: Backup with SQL Srv 2000 on Windows Server 2003

    That 'C:\Intec'looks strange. Mine contains the default SQL backup location.

    Cheers,

    - Mark

    August 19, 2003 at 3:51 am

    #470377

Viewing 15 posts - 376 through 390 (of 790 total)