What's the output of this command?

get-executionpolicy

graeme.black (10/20/2009)

---

cmille19 (10/20/2009)

---

Let's try just running portions of the script to see if we can't find a problem. Save this PowerShell code to a script file (for example test.ps1). Then...

Let's try just running portions of the script to see if we can't find a problem. Save this PowerShell code to a script file (for example test.ps1). Then execute the...

graeme.black (10/20/2009)

---

The error message I get is

still get the following error

Exception calling "Fill" with "1" argument(s): "Invalid object name 'server_spa

ce_lku'."

At C:\BIN\Write-DbSpaceToDb.ps1:27 char:19

+ [void]$da.fill( <<<< $dt)

I am running

C:\BIN>Write-DbSpaceToDb.ps1 "IEOAK-SQL2005-B"...

graeme.black (10/16/2009)

---

graeme.black (10/15/2009)

--------------------------------------------------------------------------------

The command I am running is

C:\BIN>write-dbspacetodb.ps1 'IEOAK-2005-B' spacedm &

C:\BIN>write-dbspacetodb.ps1 'IEOAK-2005-B\MSSQLSERVER'

I have tried different combinations, i have attached a picture of the table

Does server name IEOAK-2005-B host the backend...

Does server name IEOAK-2005-B host the backend repository...

Attached fixed download. Since the publication of article with your help I've addressed these issues:

Missing procedure creation statements from download

SQL Agent job missing parameters for PowerShell script

Incorrect caluculation of of...

127.0.0.1 (10/15/2009)

---

Hello,

First, many thanks for your contribution

I have the same problem than Grasshoper. (free_mb is null)

But if I execute :

SELECT CAST(SERVERPROPERTY('ServerName')...

What is the Powershell commmand you are running and what are contents of the server_space_lku table?

Correct code for database space, (thanks Birdmaster777):

CREATE TABLE #output(

server_name varchar(128),

dbname varchar(128),

physical_name varchar(260),

dt datetime,

file_group_name varchar(128),

size_mb int,

free_mb int)

exec sp_MSforeachdb @command1=

'USE [?]; INSERT #output

SELECT CAST(SERVERPROPERTY(''ServerName'') AS varchar(128)) AS server_name,

''?'' AS dbname,

f.filename AS...

Birdmaster777 (10/15/2009)

---

Hello

I have strange results from the powershell scripts.

The scripts run successfully, however the Free_MB column only displays Null values in exception of the master database.

The...

Link to the stored procedure creation statements. I will update the zip file included with the article, but this may take a few days to show up.

graeme.black (10/14/2009)

---

Hi

I am stepping thorugh the various steps, but when I try to launch the powershell scripts, I get the following error

C:\BIN>WRITE-DBSPACETODB.PS1

Exception calling "Fill" with "1" argument(s): "Invalid object name...

vinodkn (10/14/2009)

---

Look like very usefull stuff, thanks but cant try with out spacedm.procedures.sql

can you please copy paste the procedures in the article itself.

I tried downloading it from following...

Wanderer (10/13/2009)

---

Interesting stuff. we have something similar using SQL agent jobs, and SSRS.

Unless I missed it, the prediciton doesn't seem to have methods for predicting impact of reindexing and check...