Skip to main content
Share Your Experience: Take the 2024 Developer Survey

New answers tagged

-4 votes

Still wrong to start the name of a user stored procedure with sp_?

Create a simple stored procedure with the said naming prefix. Create the replica of this SP without naming prefix. Execute both the SPs in your server by calling them in a loop (say, 1000 times) - SQL ...
Tanjot's user avatar
  • 1
0 votes

Replicate Data from 2008R2 to 2012 for Reporting Purposes

Should I opt snapshot replication or transaction replication or log shipping? First of all exclude log shipping from your solution because you can either applying changes from primary or perform ...
SergeyA's user avatar
  • 690

Top 50 recent answers are included