-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
To display compatibility levels that can be set, 60 – 6.0, 65 – 6.5, 70 – 7.0, 80 – SQL… READ MORE
In SQL Server snapshot can be created which creates a point in time read-only copy of any database. The amount… READ MORE
Using the steps below one can change the location of the datafiles in SQLServer for user databases and tempdb. 1)… READ MORE
DBCC CHECKDB requires some amount of temporary space, to find the amount of space required in advance using ESTIMATEONLY option… READ MORE
Note: Along with user mode the following termination option can be specified ROLLBACK AFTER integer, ROLLBACK IMMEDIATE, NO_WAIT when changing… READ MORE
DECLARE @dbName VARCHAR(100) SET @dbName = 'AdventureWorks' DECLARE @sql VARCHAR(50) DECLARE @spid SMALLINT DECLARE @loginame NVARCHAR(256) DECLARE @hostname NVARCHAR(256) DECLARE… READ MORE
In SQLServer 2005 one can change the user mode of a database to multi, single or restricted. MULTI_USER – This… READ MORE
To find sessions that are blocking a session and blocked session, one can run the following SQL which works on… READ MORE
http://support.microsoft.com/kb/319942 READ MORE
To start SQL Server services (default instance) c:> net start mssqlserver Output: The SQL Server (MSSQLSERVER) service is starting. The… READ MORE
In SQL Server 2005 using the SQL below one can make the database read-only/read-write. — set database to read only… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 