Error: Back up the transaction log for the database to free up some log space. To recover from a full transaction log If the log is 100% full you cannot truncate it by backing it up, since the backup has to be recorded in the transaction log. For version 6.5, use: DUMP TRANSACTION dbName WITH […]
Category: SQL Server
Categories
sp_spaceused (Transact-SQL)
Displays the number of rows, disk space reserved, and disk space used by a table, indexed view, or SQL Server 2005 Service Broker queue in the current database, or displays the disk space reserved and used by the whole database.
Another way to go about changing the data type varchar to decimal is to change the varchar to money then convert the money data type to decimal. It may not be the best way to do it but it has work for me.
Categories
SQL Server Datatypes
Data Types sql_variant: Stores values of various SQL Server-supported data types, except text, ntext, and timestamp. timestamp: Stores a database-wide unique number that gets updated every time a row gets updated. uniqueidentifier: Stores a globally unique identifier (GUID). xml: Stores XML data. You can store xml instances in a column or a variable (SQL Server […]