|
|
-
I just learned from Jugal Shah's blog(sqldbpool.com) "How to check when SQL Server was installed". NT AUTHORITY\SYSTEM login gets created when we install SQL Server...
|
-
SET STATISTICS IO Causes SQL Server to display information regarding the amount of disk activity generated by Transact-SQL statements. When STATISTICS IO is ON, statistical information is displayed...
|
-
To remove the backup and restore history tables by deleting the entries for backup sets older than the specified date as follows...
|
-
How to get All User table names from database? Example 1...
|
-
You can use SELECT @@Version to find the Edition/Version of your SQL Server...
|
-
Some useful System Stored Procedures for Developers/DBAs Part-II...
|
-
When we try to insert some explicit data into an IDENTITY column the following error occurred...
|
-
Some useful System Stored Procedures for Developers/DBAs:
|
-
I have learned one new thing. How to enable Database mail XPs in SQL Server for sending e-mail messages from the SQL Server Database Engine...
|
-
I have learned one new thing, How to move database from one location to other location using with Attach/Detach function in SQL Server ...
|