Forum Replies Created

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

  • RE: Shrink DB Log File

    yup, but what about the blanks in between...?

  • RE: Database Archiving

    Are we talking backing up the data here or actually archiving the data out of the database, (removing from main production environment)?

    If it is the removal option, I don't know...

  • RE: Shrink DB Log File

    Sure.

    Transaction logs basically wrap around. If the log has space, but that space is not at the end, but in the middle, then it cannot be shrunk with the conventional...

  • RE: Shrink DB Log File

    I had a look at the path, and it no longer exists.

    Here's the script:

    ---************************************---

    /*

    Shrink a named transaction log file belonging to a database

    Originally found at;

  • RE: Shrink DB Log File

    There are sometimes problems with shrinking a database log file due to the fact that it hasn't ever been completely filled. ( I remember seeing this somewhere.)

    There was a script...

  • RE: Logic to determine Gender based on FirstName

    There are products by a company called DataFlux that can provide what you are looking for. DF Power Studio being the main contender. It is basically a data analysis tool,...

  • RE: parameter in four-partname tables

    This should do what you want:

    CREATE PROCEDURE sp_inventering_lista

    @RESENH varchar(255), @TableParam varchar(100)

    AS

    declare

    @sql varchar(8000)

    select @sql =

    'SELECT

    subquery.Resultatenhet,

    subquery.ARTNR,

    subquery.BENAEMN,

    subquery.ILAGER,

    subquery.RESANT,

    subquery.DISPONIBELT,

    SUM(subquery.SALDO)+DISPONIBELT AS SALDO,

    SUM(subquery.SALDO)+SUM(inventering.dbo.hagfors.antal) as...

  • RE: SP_WHO2

    dbcc inputbuffer (), where is the spid from sp_who2. You could write a procedure to use a view of the sysprocesses table and wrap a cursor around each spid...

  • RE: Collation conflict problem with Stored Proc

    Note that adding collation comments into your SQL code could invariably increase the execution time of the code/procedure. It is best to keep the Server Collation the same between your...

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