While supporting the website калькулятор на автокредит I encountered a problem when I use SQL Server Management Studio in SQL Server 2005 to connect to an instance of SQL Server 2008.
To solve this problem, I installed Microsoft SQL Server 2005 Service Pack 2. After that I also installed "Cumulative update package 12 for SQL Server 2005 Service Pack 2 (server and client)".
And, voila, it works!
Showing posts with label Server. Show all posts
Showing posts with label Server. Show all posts
Wednesday, May 6, 2009
Tuesday, January 6, 2009
How to reduce the size of the database in Microsoft SQL Server
On hosting server often exists database quota for MS SQL Server. Even if your database contains small amount of data, but there is goes intensive adding/modifacation of the data, in some point the size of the data could exceed quota and your account may be suspended.
This happens because of growth of the transaction log.
To clear transaction log you can execute the following command:
This happens because of growth of the transaction log.
To clear transaction log you can execute the following command:
Subscribe to:
Posts (Atom)
