PowerShell Scripts for SQL 2.0

Version: 2.0
PowerShell Scripts for SQL

Downloads:0

Hits:2681

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:

SQL Sets 1.1

Quickly capture and organize snapshots of your SQL Server data into a single, self-contained file called a Portable Data Document.

By: Mike Morris Homepage

Shareware

SQL Editor for Oracle 3.1

Free SQL Editor for Oracle. Features - colored syntax, multi-threaded configuration, explain plan, reading DBMS_OUTPUT stream, error positioning,...

By: DBA Inventions Ltd. Homepage

Freeware

SQL Partition Manager 1.1.56

SQL Partition Manager provides a wizard-driven interface to partition tables in a large SQL Server database for improve performance and efficiency....

By: DonWellSoft, LLC Homepage

Shareware

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

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

GM - SQL Executer

Features:========= - Unlimited number of simultaneuos DB connections via ODBC. - Typing and executing single or multiple SQL statements directly. -...

By: GM - Software

Freeware

SQL Additional Tools 1.0

Design package for the extension of the Delphi environment and operation with SQL servers. Adds some possibilities at operation in the...

By: AVS Software

Freeware

SQL Examiner 1.2

SQL Examiner is a program which compares and synchronizes the schemas of different versions of SQL server databases no matter how complex their...

By: TulaSoft

Shareware