Thank you, so it seems like you can never be sure how SQL server will treat errors inside a transaction.

If you look at the code in the following example, its...

Okay thank you. There seems to be an essential, yet so vague distinction between the initial size and default size of a database.

Conclusions by this thread:

- ALTER DATABASE ... MODIFY...

Hi, thanks for your input. If this is the expected behavior of the shrink command, then the documentation is wrong or misleading:

http://msdn.microsoft.com/en-us/library/ms190488(v=SQL.90).aspx

The database cannot be made smaller than...

I must have encountered a bug in SQL Server 2005:

When you increase the initial size of a database using ALTER DATABASE, the DBCC shrinking commands ignores that size.

The following code...

Thanks, I know I shouldn't be shrinking my database. I'm just trying to figure out how shrinking works and how it relates to the initial/default file size.

I argue that DBCC...

Thanks for your inputs.

philcart (10/1/2009)

---

Firstly, you're using SQL Server Express which has a hard wired limit of 4GB for the maximum database size. Individually, not that big really, but you...

Omg, I just solved the case after 10 hours of googling!

Client and server are not joined to a domain/AD (seems overkill for just two machines).

Hence they were unable to use...