I don't think anyone can give you a good answer unless we have your table definition and a copy of the query that you think needs these indexes . even...

i'm not sure if this helps - but it does give you links for DB2 ODBC drivers

https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.apdv.cli.doc/doc/t0023867.html

I've seen this on the owner column when a user account has been removed - so have you upgraded recently (or restored from a different version) - maybe sp_helpdb doesn't...

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

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...