Forum Replies Created

Viewing 15 posts - 181 through 195 (of 345 total)

  • RE: Run VB in DTS

    Nothing run from the scheduler can have user interaction as it doen't have a display associated.

    You could have the app put things into a table and query that.

    Cursors never.

    DTS -...

  • RE: Recovery model from simple to full

    Is it the same databases that always change back to simple?

    Run a job to log the recovery model of all databases every few minutes so yo can find out when...

  • RE: pass a table as a sproc parameter

    You can create and populate a temp table then access it from within the SP.

    Cursors never.

    DTS - only when needed and never to control.

  • RE: Query a Sql Server LOG (LDF) File

    see dbcc log (dbname,4)

    or try the log explorer from lumigent.

    Cursors never.

    DTS - only when needed and never to control.

  • RE: Huge Transaction log

    Are you taking log backups? If not then you should set the recovery model to simple for the database.

    I would also recommend changing the recovery model for the model database...

  • RE: How indexs are used to locate data from table

    Get a copy of

    Inside sql server 2000 by Kalen Delaney.

    It tells you a lot about the internal structures in sql server.

    Cursors never.

    DTS - only when needed and never to...

  • RE: Query across different servers

    Easiest is probably to create a linked server - see security in enterprise manager or sp_addlinkedserever in bol. Then you can query it using the 4 part name as you...

  • RE: getting single records

    select *

    from tbl t1

    where grade = (select max(t2.grade) from tbl t2 where t1.student = t2.student)

    If it is possible to have multiple recs for a student with the same highest grade...

  • RE: DTS package failure

    Don't know db2 but try setting the source as a query and converting the datetimes to

    yyyymmdd hh:mm:ss

    Cursors never.

    DTS - only when needed and never to control.

  • RE: Table, Clustered and NonClustered index location

    You would have to try it and see.

    You could also try splittimg the table up and accessing through a partitioned view.

    Depends how it is used but for something this large...

  • RE: Collation SQL Challenge

    In a union the columns returned must contain data of a single datatype. This will be decided by the first statement in the union.

    If the server cannot implicitely convert all...

  • RE: Making "dbo" owner of stored procs

    Doesn't help if you want the developers to own their SPs during development and only change the owner later though.

    Cursors never.

    DTS - only when needed and never to control.

  • RE: Check constraint

    Why not

    create table

    (

    type varchar(1),

    i int

    }

    where type = a,b,c.

    Cursors never.

    DTS - only when needed and never to control.

  • RE: Stored Procedure Question

    >> there some rule that does not allow the datatype Text to be use as a variable datatype in a stored procedure?

    Yes.

    I can declare my variable as a larger varchar...

  • RE: for xml to file from trigger

    You can create a global temp table from inserted.

    select * into ##inserted from inserted then use that for the bcp.

    You can stop anothyer process from doing the same thijng by...

Viewing 15 posts - 181 through 195 (of 345 total)