there's one exception - your log file grows stupidly big and you...

off the top of my head... are you using an ODBC DSN for connection (either a file or system DSN)? - maybe that's not configured correctly on live

I use this script to kill all connections to a database - modify it to your hearts content

DECLARE @spid int
DECLARE @strsql NVARCHAR(100)
DECLARE curs1 CURSOR FOR SELECT spid...

sounds like maybe a dns error - these tend to happen occasionally

try running from the dos prompt "IPCONFIG /Flushdns"

if not then try adding a static record in you local hosts...

I think the clue might be in "login timeout expired" - normally you get that when a firewall or DNS issue stops you from resolving the server name… not normally...

https://www.cbtnuggets.com/blog/career/career-progression/how-long-do-it-certifications-last

I have a script

ALTER PROC [dbo].[p_copylatestbackup] @user VARCHAR(100)=NULL, @expireson DATE=NULL, @database VARCHAR(100)=NULL
AS
SET NOCOUNT ON

DECLARE @db VARCHAR(100)
DECLARE @filename VARCHAR(400)
DECLARE @str VARCHAR(1000)
DECLARE curs1 CURSOR FOR

SELECT x.database_name,x.physical_device_name FROM (
SELECT ...

I did think that was unusual, and it occurred to me that it doesn't fit well with enumerating files from NTFS - perhaps just save your backup as accounting.bak 🙂

does the sql service account (or sql agent if you are doing it via a job) have permissions to that folder?

I've been one twice - once for a major rail disaster caused by a failing in the design of track inspection software (by...

there should be dozens of examples on codeproject

but I did find this

https://www.databasejournal.com/features/mssql/article.php/3589021/Executing-SQL-Stored-Procedures-from-inside-a-Web-Application-Part-1.htm

depending on what framework you are using the parameter bit will look a bit like (pseudo code here)

create connection

create...

I use Redgate - it's not not very invasive on your server and it has a few really cool features , my favourite is that it looks at patterns of...

I haven't heard of this problem! Can you post more about web apps getting compromised on an intranet?

edit: I would think if you had attackers get past the firewall...

the only thing that I can advise is to check all indexes are in place on both servers (maybe one is missing) - then look at your server settings -look...

if you delete data from a heap, the space might not be released and the pages remain allocated to the table, but unused

the problem gets worse, the more times you...