SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

SQLPS Meets the DMV's

By Edward Pochinski,

The vb script will launch the powershell script which will prompt you for the1st part of the sql named instance name then second part as:

Prompt 1: MSQL1

Prompt 2: SQL_Instance1

SQL Named intance full name: MSSQL1\SQL_Instance1

You can just call the.ps1 file also but since I am a bit lazy these days...Enjoy !

Total article views: 335 | Views in the last 30 days: 3
 
Related Articles
FORUM

Disabling User login prompt

Disabling User login prompt

FORUM

Masking Parameter prompts

Masking Parameter prompts

BLOG

SQL Prompt

I downloaded and installed SQL Prompt from Red Gate this morning. If you aren't aware, PromptSQL wa...

FORUM

how to disable multivalue prompt

DISABLE PROMPT BOX

Tags
dmv    
powershell    
 
Contribute