Forum Replies Created

Viewing 15 posts - 6,301 through 6,315 (of 7,501 total)

  • RE: SQL Server 2005 - Changing Port in Cluster Environment

    I have altered the IPAll port, and even enabled the instance's own ipaddress with another port, but connecting using the latter ipaddress/port did not work !

    Connecting using the ipaddress/"IPAll-port" worked...

  • RE: SQL Server 2005 - Changing Port in Cluster Environment

    altering the IPAll port, will have only that port active for connections when working with fixed ports.

    (just done a quick test)

     

  • RE: Shrinking the database file

    you databasesize has been shrunk.

    it will try to shrink to it's original size, unless specified other size.

    there is a procedure (which may need to be executed  a number of times)...

  • RE: SQL Server 2005 - Changing Port in Cluster Environment

    I cannot see your screenshot, but here's how it works with an active/active cluster (x64).

    I just testted it today.

    SQL server configuration manager \...

  • RE: Shrinking the database file

    this might occur when your database has autoshrink enabled.

    If this is a production db, disable autoshrink, unless you like to have no control regarding when the shrink will occur !

    alter...

  • RE: Ownership

    Now this is a good parallel projection

    As is the final solution ... bringing in another person can help you fix your problem in...

  • RE: Retrieving HD info from CLR SP?

    Wich permission set did you use when creating the assembly for SQLServer ?

    CREATE ASSEMBLY xxxx from 'c:\xxxx.dll' WITH PERMISSION_SET =  SAFE | EXTERNAL_ACCESS | UNSAFE 
    I guess for your...
  • RE: Problem starting SSAS 2005

    I've set the SQLBrowser service account to "LocalService" but that did not to the trick.

    After changing it to "Local System" SSAS was accessable, but the Server-browser (SSMS) did not show...

  • RE: ::FN_DBLOG - Problem in retreiving [row data]

    I didn't know the function, but sp_help fn_dblog gave some info.

    use

    your_db

    go

    declare

    @StartLSN nvarchar(50)

  • RE: Triggers to Execute in Pre Defined Order

    now that's where the cautions come in ...

    12 triggers on one object, may be a bit _to_ many

    Maybe there is a way to...

  • RE: Result into Table

    declare @sql as varchar(5000)

    set @sql = 'RESTORE FILELISTONLY FROM disk=''U:\MSSQL\backup\masterfull.bak'''

    create table #tmpFilelist ( LogicalName nvarchar(128)

     , PhysicalName nvarchar(260)

     , [Type] char(1)

     , FileGroupName nvarchar(128)

     , [Size] numeric(20)

     , [MaxSize] numeric(20)

    &nbsp

  • RE: Triggers

    First question that has to be asked : Does this all have to be in the same transaction-scope ? (on-line/realtime). Keep in mind, if the trigger fails, your sql-transaction also...

  • RE: RowGUIDCol

    Consider it as an extention to "Identity"

    from books online (BOL)

    If an application must generate an identifier column that is unique across the entire...

  • RE: Working With SqlParameter in .NET

    also keep in mind when defining your parameters, the better you allign with your sproc-parameter-datatype or column-datatype, the better your commandobject will be served.

    Tell the system what you know !

    you...

  • RE: Why is my Sproc sooo slooow .. and how will it be faster!

    - Can you try to execute the queries without the TOP-keyword (and order by) in the views ?

    - Like you can see, maybe you would be better off by altering...

Viewing 15 posts - 6,301 through 6,315 (of 7,501 total)