Contents tagged with XML

• Audit Users logging in using "sa" or service accounts

  Tags: SQL Server, audit, login, logon, xml, email, mail

  Thursday, July 4, 2019 11:58:47 PM

  No Comments

  source: https://www.sqlservercentral.com/scripts/audit-users-logging-in-using-sa-or-service-accountsIF OBJECT_ID ('AuditSqlLogins') IS NOT NULL DROP TABLE AuditSqlLogins

  GO

  CREATE TABLE … more

• Creating Native Web Services in SQL Server (Now Deprecated)

  Tags: SQL Server, Native, web service, XML, Endpoints, SOAP

  Tuesday, June 19, 2018 5:46:54 AM

  No Comments

  https://www.codeproject.com/Articles/195508/Consuming-a-Web-Service-created-through-Sql-Server

  https://dba.stackexchange.com/questions/159755/how-to-create-soap-endpoint-in-sql-server-2016

  https:// … more

• Web Service Testing

  Tags: Webservice, wireshark, Postman, Webservicestudio, XML, SOAP

  Tuesday, June 12, 2018 10:41:00 AM

  No Comments

  https://www.getpostman.com/

  https://www.wireshark.org/

  https://archive.codeplex.com/?p=webservicestudio

  http://blog.getpostman.com/2014/03/07/writing-automated-tests-for-apis-using-postman/

  https: … more

• Importing XML into SQL Server

  Tags: SQL Server, XML

  Monday, October 2, 2017 6:36:36 PM

  No Comments

  https://www.mssqltips.com/sqlservertip/2899/importing-and-processing-data-from-xml-files-into-sql-server-tables/

  https://docs.microsoft.com/en-us/sql/relational-databases/import-export/examples-of- … more