Well, I did it. I stopped MSSQLSERVER and started it again. Tempdb has now shrunk to 8 Mb...

It doesnot explain why I could not shrink the db, it confirms the...

Newbie,I apreciate youtr willingness to think with me on solving the problem, but would ou read my initial mail, please?

Initially the tempdb is  about 2 Mb; currently it's over 8 Gb, of which 2 Mb is used...

Graps,

It's not the logfile, it's the datafile which is full of empty space.

Tnx for responding tho

Nope, still no dice.

I'll use the next scheduled off-time to drop the tempdb and see how things are going from there.

Tnx all.

Allas, no luck Andrew. Tnx for responding tho.

Shai,

I tried that, but same result: no shrink.

Tnx for responding

Tnx both of you. I started with asking for a trigger, 'cause that was the first thing I thought of. Never thought of using the formula property for this. I...

Jonathan,

According BOL they are not the same:

It is treated similarly to a fill factor value of 100 in that SQL Server creates clustered indexes with full data pages and nonclustered...

I'm not sure if I understand you correctly. I have a similar situation: Server A publishes a db, Server B is subscriber to A, and server B itself is a...

Tnx for the help, ppl. When I'm done I'll let you know. DOn't hold your breath untill then, tho, have to do this in the spare time I can squeesh...

1learns everyday. Tnx for the heads up.

Right, found out I had to qualify the reference to the table as 'owner.tablename'. The description in BOL did not make that clear to me, being loged in as SA...

Tnx Jay, found this out also, easy to do. Next thing I'm looking at is Reporting Services as a reporting tool. Drawback: here I have to use MXD to make...

No harm done.