|
|
-
|
|
HI,
To know your Substring Function Understanding power give answer without use of Query builder and SSMS....
|
|
-
|
|
List out all the primary key from database...
|
|
-
|
|
Completed 4 Years in IT Profession...................................................
|
|
-
|
|
Search Objects (Table Name, Procedures, and View) from databases...
|
|
-
|
|
1)In SSMS Job is wonderful task for us.it's use for our work automated,for job you can remove your manual work.
2)In job you can scheduled your own task like Backup database,Rebuild index,Daily Send mail who's Employees are not login,Daily send SMS etc
...
|
|
-
|
|
How to recover a Database in suspect mode...
|
|
|
|
-
|
|
1)I have discussed previous post for Database Mail Configurations after this you can
Send mail thorough System Store procedure.
2)You can Create your own procedure and send mail Any alert or any attachment through this system store procedure.
...
|
|
-
|
|
Change Table Name Using sp_Rename Procedure...
|
|