SQL CMD needed for executing script on a server

Виконано Опубліковано %project.relative_time Оплачується при отриманні
Виконано Оплачується при отриманні

Hi, i need a simple SQL CMD script for deleting certain tables in a database so I can schedule this script on my windows server.

This is currently not possible via SQL server management studio since it does not have the SQL server agent (we are using SQL server 2008).

I can provide the path to SQL CMD but i do not know how to program the command itself. There i need help for.

Microsoft SQL Server

ID Проекту: #9391003

Про проект

5 заявок(-ки) Дистанційний проект Остання активність Jan 20, 2016

Доручено:

phiona06

Hi! You can create the following script located, for example, at C:\[login to view URL] : USE [DBName] DROP TABLE [SchemaName].[TableName] SELECT * FROM sysobjects WHERE type = 'U' And run this script like this: [path] Більше

$25 USD за 0 дні(-в)
(13 відгуків(-и))
4.0

5 фрілансерів(-и) готові виконати цю роботу у середньому за $25

vinaysinghh

A proposal has not yet been provided

$20 USD за 1 день
(10 відгуків(и))
3.7
hamzaadnanissa

Dear I have experience in SQL and i would like to understand better what are you looking for Do not hesitate to contact me Regards

$25 USD за 1 день
(0 відгуків(и))
0.0
RawadHaber

Hi, I think this project is fairly simple and I would deliver in a short period. Hope we can work together, Regards, Rawad

$25 USD за 1 день
(0 відгуків(и))
0.0