What is "ok"?

The data size grow because:

1. Someone increases it.

2. Data is added and autogrow is on.

That's it. It doesn't shrink because you don't have data. This isn't like a...

Nope, can't know it's the last row until you move past it.

First, please post in the appropriate forum and not just anywhere. Moved to Admin area.

Second, servers have a default collaction and sort order, databases can be set differently, as can...

Thanks for the update. When you delete replication, need to be sure the jobs are removed as well.

The IP address and port are not communicating. Can you check a netstat and see if that port is open on the server?

You either have an open transaction preventing it from shrinking or being cleared, or you are performing a large transaction that needs that space.

Log space is in no way related...

Look at sp_who2, and dbcc inputbuffer to see what work is being done. I might profile as well and see if anything is happening or if the connection is just...

I agree with what Brian has written on the technical side.

But, why do you want to block this? Think about that and honestly rather than creating issues with a one-off...

I'd disagree with the time length we have for rights. Most, meaning high 90-some %, of content produces it's value in the first 5-10 years, especially in the media and...

Matt has the right idea. You have to package and sell it, show them that value is being generated and it results in reduced costs.

Of course, at the end of...

Interesting debates and thanks for the comments. It's one of the reasons I do these updates as a break from the db stuff.

If you want to debate the personal liberty...

Very strange. I think you might want to investigate naming the transactions, being able to only rollback the nested one. OR, track that an error has occurred, and issue one...

The space monitoring in tempdb is the same as any other database. You have to track it over time specifically for tempdb to determine what the usage is.

So are you trying to back up 40-50 databases to one server? The rules for the standby server are the same as for production, allowing for some amount of slowness...

Ahhhhhh, don't write triggers that go back on themselves. I might be called by your company and don't want to deal with that.

show us some code, or explain what you...