PowerShell Scripts for SQL 2.0

Version: 2.0
PowerShell Scripts for SQL

Downloads:0

Hits:2335

SourceYES

Link Broken:Report It!

Package:Without source

Price:$0

Package:Source included

Price:$0

More info Download

Description


* Create a job, job step and schedule it
* Get a list of failed jobs
* Get query results using a T-SQL script in a file
* Create a SQL Server table
* Restore an Analysis Services database

Create and Connect

* Create a SQL Server database
* Create a job, job step and schedule it
* Create a SQL Server table
* Connect to SQL Server with IP address and SQL Authentication
* Connect to SQL Server with IP address and Windows Authentication

Perform Daily Tasks

* Get last backup
* Get a list of failed jobs
* Run a DBCC CheckDB
* Script out a database or table
* Create job to recycle error logs

Get Information and Settings

* Get available SQL Servers
* Get/Set default data or log file locations
* Get server version and attributes
* Get database file sizes
* Get query results using a T-SQL script in a file

Work with Services

* Start or stop Services
* Get Analysis Services catalogs and databases
* Restore an Analysis Services database
* Get Integration Services package information
* Get a list of running Integration Services packages

Related:

Powershell Srictps - Sql

User Reviews:

Write Review *
Your name *
Email *
(Your comments will be reviewed by our staff before they are posted)
Rate this product *
Captcha Image
Enter code from image *

 

Related:

xSQL Object 2.5.2.7

xSQL Object is a professional SQL tool for comparing and synchronizing SQL Server databases. It allows the developers and database administrators...

By: xSQL Software Homepage

Freeware

DataRoamer 1.0

DataRoamer is a simple, fast, powerful GUI database viewer. Visually navigate the structure and content of SQL Server, Oracle, MySQL, PostgreSQL,...

By: Pieter Branderhorst Homepage

Shareware

e-SoftEasy Business Analytics 2.0

Create HTML/PDF Reports/Charts from multiple Database Servers. Filter, sort and group your data in any way ,create queries using your SQL...

By: Joaquin Menendez Homepage

Freeware

SQL Populator 1.0

Script your Microsoft SQL Server tables data into a valid SQL script. Setup script generator for your personal needs to clear tables before...

By: Dmitri Kaptsov Homepage

Demo

FlySpeed DB Migrate to SQL Server 1.5

FlySpeed DB Migrate to SQL Server enables rapid migration of MS SQL db structure and data to another database server, or transfer the data to the...

By: Alexander Smirnov Homepage

Shareware

SQL Server Comparison Tool 1.2

SQL Server Comparison Tool is a Windows program for analyzing, comparing and documenting SQL Server databases. It's an ideal tool for Database...

By: AlfaAlfa Software

Freeware

TUTI - Table Utilities 3.30

TUTI - TABLE UTILITIES is a useful general-purpose tool applicable to any accessible database for Borland BDE or Microsoft ODBC. It is a powerful...

By: David Simon P. Homepage

Shareware

ApexSQL Audit 2.12.99

ApexSQL Audit proves a comprehensive, enterprise level active data auditing tool for Microsoft« SQL Servere 7 or 2000 Database auditing unmatched...

By: Apex SQL tools

Freeware

Orbital's SQL Decryptor 1.0.0

Orbital's SQL Decryptor is the first product to decrypt SQL triggers, views and stored procedures in an easy to use Enterprise Manager-like...

By: Orbital Technologies

Shareware

dbExpress driver for Sybase SQL Anywhere 1.0.1

VISOCO dbExpress driver for Sybase SQL Anywhere is based on the Embedded SQL database interface, provide direct access to Sybase SQL Anywhere and...

By: unknown

Shareware