Technical Article

FTP files using SQL stored procedure

This stored procedure takes four parameters1)file to ftp2)server name or IP3)ftp login4)ftp passwordSP will ensure that local file exists before continuing,it will create and execute a batch file in order to push the file to the remote FTP server.--exec exampleEXEC dbo.up_FTPPushFile 'c:\temp\test.txt', 'server', 'user', 'password'

5 (2)

2002-12-09

3,714 reads

Technical Article

Add Check Digit (LUHN)

If you ever need to create a credit card like number this stored procedure is for you.Most credit cards contain a check digit, which is the digit at the end of the credit card number. To generate the check digit, the LUHN formula is applied to the number. To validate the credit-card number, the check […]

2002-11-30

3,013 reads

Blogs

Daily Coping 29 Jun 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Daily Coping 28 Jun 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Creating a Database Audit Specification can create new users & schemas in the background

By

I love database audits. They are simple, easy to use, effective, not overly resource...

Read the latest Blogs

Forums

AOAG Listener Error:Kerberos Status is showing: Incorrect username and Password

By Shashihemanth

Hi, I am having error in creating AG Group Listener. We finally try to...

How to set up Replication Alerts in SQL MI

By DanielP

Hello, Since Operators are not supported in SQL MI, how do you set up...

Attempting to run PS / DBA tools script as a SQL Agent job

By Summer90

If I run my PS script with PS as an ADMIN interactively it runs...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers