|
|
-
I just learned today "How to enable SQL Server Agent XPs " from Paresh Prajapati's blog,www.paresh-sqldba.blogspot.com. Run following queries to enabl...
|
-
Today i have learned one more thing. How to Kill all open processes against SQL Server Database using with Activity Monitor. Steps are:
1. Go to A...
|
-
I have learned one new thing, How to move database from one location to other location using with Attach/Detach function in SQL Server.
Steps are:
1....
|
-
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.
#Example...
|
-
Some useful System Stored Procedures for Developers/DBAs:
1. sp_help( keyboard shortcut Alt + F1) - Reports information about a database object, a u...
|
-
When we try to insert some explicit data into an IDENTITY column the following error occurred.
Create Table test1
(
Id Int ...
|
-
Some useful System Stored Procedures for Developers/DBAs Part-II.
1. sp_spaceused
Displays the number of rows, disk space reserved, and disk spa...
|
-
You can use SELECT @@Version to find the Edition/Version of your SQL Server....
|
-
How to get All User table names from database?
Example 1:
[code]
select name from sys.objects where type='u' order by name asc
[/code]
Example ...
|
-
To remove the backup and restore history tables by deleting the entries for backup sets older than the specified date as follows:
[code]
use msdb
e...
|