|
|
-
SQL Server - Query To find Identity columns in Database with Table name, How to find Identity columns in Database with Table name...
|
-
How to find Schedule job histories like Job name, job run date,job run time and job status...
|
-
I just learned "How to Drop Constraint from table" ...
|
-
I just learned "How to Verify backup file is valid or not " . I use RESTORE VERIFYONLY option...
|
-
Today i learned "How to change password of SQL Server login" Example 1 ...
|
-
I just learned,when i take backup in SQL Azure Database, it gives me a following error...
|
-
I just learned today "How to find when Stored procedures was created and modified" with using sys.procedures...
|
-
I just learned today "How to find Primarykey and Foreignkey column and table names" with using sp_pkeys and sp_fkeys. 1. sp_pkeys - Returns primary key information for a single table in the current environment.
|
-
How to rename Databasename,Tablename and Columnname. Rename Database Name:
|
-
I just learned today Open SSMS with Ssms.exe without navigate to Start-->.Program-->SQL Server 2008 R2-->SSMS. Steps are:...
|