|
|
-
kingkong0924 Liked 1 Years ago through Just Learned | 1 Point
Sometimes when SQL Server is configured to use some port other than default port number (1433), then you may not be able to connect directly in SSMS just by specifying the name of the server in the **Server Name** field in **Connection to Server** di...
|
-
kingkong0924 Learned 1 Years ago through Just Learned | 1 Point
Sometimes when SQL Server is configured to use some port other than default port number (1433), then you may not be able to connect directly in SSMS just by specifying the name of the server in the **Server Name** field in **Connection to Server** di...
|
-
kingkong0924 Liked 1 Years ago through Just Learned | 1 Point
Till Date I have been using Red Gate SQL compare tool for Schema comparison for databases.
Just came to know Microsoft Visual Studio2010 also provides an inbuilt tool for Data comparison & Schema Comparison for two databases.
Below are the steps for...
|
-
kingkong0924 Learned 1 Years ago through Just Learned | 1 Point
Till Date I have been using Red Gate SQL compare tool for Schema comparison for databases.
Just came to know Microsoft Visual Studio2010 also provides an inbuilt tool for Data comparison & Schema Comparison for two databases.
Below are the steps for...
|
-
kingkong0924 Liked 1 Years ago through Just Learned | 1 Point
Till Date I have been using Red Gate SQL compare tool for Schema comparison for databases.
Just came to know Microsoft Visual Studio2010 also provides an inbuilt tool for Data comparison & Schema Comparison for two databases.
Below are the steps for...
|
-
kingkong0924 Learned 1 Years ago through Just Learned | 1 Point
Till Date I have been using Red Gate SQL compare tool for Schema comparison for databases.
Just came to know Microsoft Visual Studio2010 also provides an inbuilt tool for Data comparison & Schema Comparison for two databases.
Below are the steps for...
|
-
kingkong0924 Liked 1 Years ago through Just Learned | 1 Point
I just learn from [Nakul''s Blog][1] That sp_dboption store procedure is “discontinued” SQl Server 2012
Replacement is the ALTER DATABASE statement, for existing sp_dboption
ALTER DATABASE TestDB SET READ_ONLY
Thank You
[1]: http://beyo...
|
-
kingkong0924 knew 1 Years ago through Just Learned | 1 Point
I just learn from [Nakul''s Blog][1] That sp_dboption store procedure is “discontinued” SQl Server 2012
Replacement is the ALTER DATABASE statement, for existing sp_dboption
ALTER DATABASE TestDB SET READ_ONLY
Thank You
[1]: http://beyo...
|
-
kingkong0924 Liked 1 Years ago through Just Learned | 1 Point
I just learn from [Nakul''s Blog][1] That sp_dboption store procedure is “discontinued” SQl Server 2012
Replacement is the ALTER DATABASE statement, for existing sp_dboption
ALTER DATABASE TestDB SET READ_ONLY
Thank You
[1]: http://beyo...
|
-
kingkong0924 knew 1 Years ago through Just Learned | 1 Point
I just learn from [Nakul''s Blog][1] That sp_dboption store procedure is “discontinued” SQl Server 2012
Replacement is the ALTER DATABASE statement, for existing sp_dboption
ALTER DATABASE TestDB SET READ_ONLY
Thank You
[1]: http://beyo...
|