Cloud Computing Basics - Achieving High Availability
Learn about high availability in the cloud at a conceptual level.
2022-03-28
112 reads
high availability
Cloud Computing Basics - Achieving High Availability
Learn about high availability in the cloud at a conceptual level.
2022-03-28
1,214 reads
RE: Connect to different servers thru stored procedure
Short answer (based on complexity) you can't. Why not use tried and true methods such as OSQL i.e (inside a BAT file)SET ChangeRecord=ABC123 SET LOGDIR="C:\Temp\%ChangeRecord%" IF NOT EXIST %LOGDIR% MKDIR %LOGDIR% SET LOG=%LOGDIR%\ProdInstall_%ChangeRecord%_runsql.log SET PREFIX=%LOGDIR%\prd. SET SRVNAME=YourServerNameHere SET DB=YourDBNameHere ECHO. > %LOG%osql -S%SRVNAME% -E -n -d%DB% -i "C:\Temp\PROD\Database\Stored Procedures\SPNAMEHERE.sql" -o %PREFIX%SPNAMEHERE.sql.err >> %LOG% OR a […]
2005-05-24
Blogs
So You Want to Deploy Power BI Project files (PBIPs)?
By Angela-Henry
Have you heard the news about the new Power BI Project files? Okay, maybe...
DBAs, Organizing Your SQL Scripts in Git
By Steve Jones
I wrote an article that was published on SQL Server Central on how to...
Only Capture Extended Events For a Given Time
It’s a great question. Let’s say you want to capture stored procedure completions. But,...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers