Nice coding reduces misunderstandings and misreadings

IF NOT (@TempVal) IS NULL

Begin

   IF @TempVal < @RetVal

   begin

      SET @RetVal = @TempVal

     end

end

PRINT @RetVal

or

if isnull(@TempVal,...

Hey, Back online.

I hope everything went just as smooth as you planned it.

Seems good over here.

Nice...

Aaarch ... you've told her ...

.... Now you'r under pressure And you have a deadline .., or "suitcases at the door"-line .

Thanks for all the replies.

"Helas" all our central servers are already migrated to W2k or W2k3 .

indeed.

I guess there are other reg-keys which store the info in HEX and get a nice guid-like reg-key.

Thanks for the testing.

Can you clarify your scenario ?

( from pc A to pc B ?  &nbsp

I've tested export of regestry keys "registered servers x"  and "MSSQLserver" (with subkeys), but that did not do the trick

That only gives me...

so after the delete operation, did you perform dbcc updateusage for that db ?

With such mass operations, statistics often get out of date.

If...

You could generate your queries as you desire and store them in a file and then use osql to execute from the saved file(s).

this message occurs when sqlserver gets a timeout when trying to extend a file. In this case it's the logfile.

The is no need...

IMHO memberlists should be documented in a separate entity containing at least listID and memberID.

This way your queries will be easy and straightforward.

With the kind of list you are using...

Don't drop/recreate the clustered indexes !

use dbcc dbreindex (check BOL)

DECLARE @TableName nvarchar(261)

DECLARE @SQLStatement nvarchar(4000)

DECLARE TableList CURSOR LOCAL FAST_FORWARD READ_ONLY  FOR

SELECT

    QUOTENAME(TABLE_SCHEMA) +

    N'.' +

    QUOTENAME(TABLE_NAME)

FROM

    INFORMATION_SCHEMA.TABLES

WHERE EXISTS

    (

    SELECT *

   ...

How about this :

set nocount on

declare @Employees table (EmployeeID integer not null, ManagerID integer null, EmployeeName varchar(128))

insert into @Employees values (1, 2, 'Jane')

insert into @Employees values (2, 3, 'Joe')

insert into...

how about using temporary objects to explode your relationships and then count the temporary objects (@table, #table or ##table).

declare @tmpRelations table (HiarchyLevel integer not null, EmployeeID integer not null, ReportsTo...

if that group already has access to your sqlserver, sqlserver will have stored the "old" windows-group-name in the system-tables. This will not be refreshed by default.