I totally agree, Louis! Once I had a coworker who hated naming anything like VoucherServiceCode. She insisted that all columns in tables had to be abbreviated, so in this...

Why are you duplicating this question? I don't see a link suggesting this is spam, but the answers to that almost identical question are going to be...

error message is very clear - a attempt was done to login to the server with a connection string that is a AD account, but trying to connect as if...

not sure if a TVF would solve this - still worth a try. but try both ways.

regarding the images - I use Plan Explorer from SQLSentry - https://www.sentryone.com/about-us/news/sql-sentry-plan-explorer-free-for-all-users

it is a...

so.. the plan you supplied does not have the MAD percentages / row counts - but it does show, very clearly in my opinion, the issues you have.

So your understanding...

those "mad" numbers show up frequently in certain plans - they should be ignored.

most of the times if you get a ACTUAL explain plan those numbers will be correct -...

regarding the temp folder you missed the point.

Assume a account named "SQLAccount" - your SQL instance runs under this account

this account will have a folder

c:\users\SQLACOUNT\AppData\Local\Temp

the account itself will obviously have...

• This reply was modified 2 years, 7 months ago by frederico_fonseca. Reason: add registry property name

Thanks for this response.  I'm only looking at it because it opens fine on my older server and not on the new one I am building.

I also have a...

you never answered the questions of how you loaded from their system onto SQL Server - neither on how you are extracting it and trying to save to a file...

smells like SPAM - but if not then you can look at this thread https://www.sqlservercentral.com/forums/topic/help-decoding-a-wait-resource-from-sysprocesses

and same questions asked there you can answer as well.

can you post the FULL entry of sysprocesses - all columns

@Grant Fritchey - pretty sure it is a cross database query (use db2, select from db1), so it should be using the same set of data and data structure,...

you should not be using that sysprocesses anymore and should instead be using one of the system views/functions. see https://learn.microsoft.com/en-us/sql/relational-databases/system-tables/mapping-system-tables-to-system-views-transact-sql?view=sql-server-2017

the format can vary depending on resourcetype - one of the...

ZIP files are binary files so will not save correctly as a string. Binary can be encoded as a string although the size will obviously be increased. One way...

where is the current data used by the Delphi system?

and how did you copy it into your new table (and as I said it should be varbinary(max))

and can you ask...