|
|
-
Paul Hutagalung Liked 7 Months ago through Just Learned | 1 Point
Hello friends, one interviewer asked that suppose you have two tables
`Employee_Details`, `Employee_Details_History`
now I want to delete original table `Employee_details` and maintain it’s history to other table.
How can it’s possible with only ...
|
-
Paul Hutagalung Learned 7 Months ago through Just Learned | 1 Point
Hello friends, one interviewer asked that suppose you have two tables
`Employee_Details`, `Employee_Details_History`
now I want to delete original table `Employee_details` and maintain it’s history to other table.
How can it’s possible with only ...
|
-
Paul Hutagalung Liked 11 Months ago through Just Learned | 1 Point
This will change the stored procedure from the username schema to the dbo schema
ALTER SCHEMA dbo TRANSFER [username].[usp_MyProcedure]
...
|
-
Paul Hutagalung Learned 11 Months ago through Just Learned | 1 Point
This will change the stored procedure from the username schema to the dbo schema
ALTER SCHEMA dbo TRANSFER [username].[usp_MyProcedure]
...
|
-
Paul Hutagalung Liked 11 Months ago through Just Learned | 1 Point
This will change the stored procedure from the username schema to the dbo schema
ALTER SCHEMA dbo TRANSFER [username].[usp_MyProcedure]
...
|
-
Paul Hutagalung Learned 11 Months ago through Just Learned | 1 Point
This will change the stored procedure from the username schema to the dbo schema
ALTER SCHEMA dbo TRANSFER [username].[usp_MyProcedure]
...
|
-
Paul Hutagalung Liked 2 Years ago through Just Learned | 1 Point
SQL Server job history contains only last 100 records.
To change or to grow history log
Go to SQL server Agent's Property
Click on -> History
change 1) Maximum job history log
2) Maximum job history rows per job......
|
-
Paul Hutagalung knew 2 Years ago through Just Learned | 1 Point
SQL Server job history contains only last 100 records.
To change or to grow history log
Go to SQL server Agent's Property
Click on -> History
change 1) Maximum job history log
2) Maximum job history rows per job......
|
-
Paul Hutagalung Liked 2 Years ago through Just Learned | 1 Point
SQL Server job history contains only last 100 records.
To change or to grow history log
Go to SQL server Agent's Property
Click on -> History
change 1) Maximum job history log
2) Maximum job history rows per job......
|
-
Paul Hutagalung knew 2 Years ago through Just Learned | 1 Point
SQL Server job history contains only last 100 records.
To change or to grow history log
Go to SQL server Agent's Property
Click on -> History
change 1) Maximum job history log
2) Maximum job history rows per job......
|