So my question is Simply. I have an access database,  I want to export data from it to an Azure Sql Database and automate the process as it needs...

Kal hi!

Oracle port can be found in your local tnsnames.ora for appropriate db registered.

SAP application is database independent and runs on Oracle, DB2, SQL Server, SAP HANA, SAP Sybase, MySQL,...

See attached error message, we managed to get around the issue by copying the sqlcmd.exe, sqlcmd.rll and batchparser.dll from the server where SQL is into the folder with the...

also, procedure sp_describe_first_result_set can be useful in such case

link:

I've tried it today and got the same error as I'm getting on the new bat file. Has something been changed/updated in the last couple of years to...

I agree with Grant, it depends on the data in databases and even features/versions you use.

For example, TDE makes compression equal to 0% (zero) on versions before sql 2016.

Google knows a lot about locks and SQL server. The only reason not to use it first  only when you need personalized answer.

But in your case I would use sp_whoisactive...

SQL server uses memory to maintain a user connection, so, if there are many of them, it will cause memory consumption.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/4705d6cf-9b60-4a47-9ca2-800b299dd35c/connection-and-associated-memory-usage?forum=sqldatabaseengine

Also, there can be a problem of an application...

We had lots of these .bat files set up at my previous workplace and I know that another file was placed in the folders along side the .bat files...

You can't use AD group name , you can connect under AD account which is a member of AD group which does have access to SQL server.

https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/using-integrated-authentication?view=sql-server-2017

If you specify...

In case linked...

• This reply was modified 5 years, 6 months ago by  Andrey.

hi Guus

Utrecht here 🙂

Connection via CMS is the same connection as you do using sqlcmd, for example.

Servers registered in CMS are stored in two tables in msdb :

• dbo.sysmanagement_shared_registered_servers_internal
• dbo.sysmanagement_shared_server_groups_internal

Link:

let's go step-by-step:

1. does the query deliver expected result...

try this one:

SELECT id
,nm
,de
,yr
--,py   /*pay old ?*/
,CASE  /* pay new ?*/
WHEN st = 'OUT'
OR se < 1
OR ty = 3
OR yr = 0
THEN 0
ELSE...

Please, attach the query in TXT file .

Office files can be with viruses or macros .