FYI

in SQL2005 you have DMV's (e.g. sys.dm_os_memory_clerks) to followup this kind of info.

e.g. clr-info : http://blogs.msdn.com/sqlclr/archive/2006/03/24/560154.aspx

-- this one works on SQL7 and SQL2000

You may have to run this script a number of times, because of the reasons I mentioned in previous the post.

-- Shrink_TrxLog.SQL

--INF: How to...

thanks for the feedback.

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...

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

(just done a quick test)

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)...

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 \...

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...

Now this is a good parallel projection

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

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...

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...

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

use

your_db

go

declare

@StartLSN nvarchar(50)