<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss Content Posted by Chad Miller
»
SQL Server PowerShell Extensions (SQLPSX)...
15 posts, Page 2 of 2
««
1
2
SQL Server PowerShell Extensions (SQLPSX) Part 1
Rate Topic
Display Mode
Topic Options
Author
Message
Jason Denne
Jason Denne
Posted Monday, March 09, 2009 10:32 AM
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, April 05, 2011 1:13 AM
Points: 3,
Visits: 140
Great article. Just a small point being a complete beginner to Powershell....but I had a problem sourcing the scripts into Powershell. i think it came down to a syntax error in your example :
Launch PowerShell and source or dot the LibrarySmo.ps1 file using the following command:
.
.\LibrarySmo.ps1
To get this step to work I had to swap the slash around i.e.
. ./LibrarySmo.ps1
Just thought it was worth mentioning in case other beginners like me get stuck at that point.
Post #671722
jsimpson-988516
jsimpson-988516
Posted Thursday, March 12, 2009 9:21 AM
Forum Newbie
Group: General Forum Members
Last Login: Thursday, August 12, 2010 6:29 AM
Points: 2,
Visits: 8
Great stuff. I have no problems at all with get-sqldata, but I cant get set-sqldata to work...
Ok, so this works
Get-SqlData 'VISTA-LAPPY\SQLEXPRESS' Worldship 'SELECT top 3 * FROM
dbo.UPSData'
But this does not...
Get-SqlData 'VISTA-LAPPY\SQLEXPRESS' Worldship 'INSERT INTO dbo.UPSpod
(Sheet, User) VALUES (4, Jim)'
Nether does:
Set-SqlData 'VISTA-LAPPY\SQLEXPRESS' Worldship "INSERT INTO dbo.UPSpod
(Sheet, User) VALUES (4, 'Jim')"
The insert statement works in SQL, so I am not sure what i am
missing.... Hope you can help.
Post #674357
cmille19
cmille19
Posted Friday, March 13, 2009 1:28 PM
SSC Veteran
Group: General Forum Members
Last Login: Wednesday, June 05, 2013 5:01 AM
Points: 257,
Visits: 674
jsimpson (3/12/2009)
Great stuff. I have no problems at all with get-sqldata, but I cant get set-sqldata to work...
Ok, so this works
Get-SqlData 'VISTA-LAPPY\SQLEXPRESS' Worldship 'SELECT top 3 * FROM
dbo.UPSData'
But this does not...
Get-SqlData 'VISTA-LAPPY\SQLEXPRESS' Worldship 'INSERT INTO dbo.UPSpod
(Sheet, User) VALUES (4, Jim)'
Nether does:
Set-SqlData 'VISTA-LAPPY\SQLEXPRESS' Worldship "INSERT INTO dbo.UPSpod
(Sheet, User) VALUES (4, 'Jim')"
The insert statement works in SQL, so I am not sure what i am
missing.... Hope you can help.
Thanks. I'm suprised the insert statement works in SQL for you. The column name "user" gives me an error message of "Incorrect syntax near the keyword 'user'". In both SQL Server Management Studio and Powershell I have to enclose the SQL reserved keyword "user" in brackets i.e. [user] and only then does the insert work.
Set-SqlData 'Z002\SQL2K8' dbautility "INSERT INTO dbo.UPSpod (Sheet, [User]) VALUES (4, 'Jim')"
Post #675533
jsimpson-988516
jsimpson-988516
Posted Friday, March 13, 2009 1:31 PM
Forum Newbie
Group: General Forum Members
Last Login: Thursday, August 12, 2010 6:29 AM
Points: 2,
Visits: 8
hehe I figured that out too... I had been removeing the []'s in posh, because I thought I couldn't use them. Live and learn. :) Thanks!!!
Post #675536
Grant Fritchey
Grant Fritchey
Posted Thursday, May 14, 2009 1:08 PM
SSChampion
Group: General Forum Members
Last Login: Today @ 9:14 AM
Points: 13,435,
Visits: 25,277
Just chiming in as someone getting started with PowerShell. Well done. Thanks for the work. I'm still just digging through it all & figuring it out.
----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of:
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans
Product Evangelist for
Red Gate Software
Post #717304
« Prev Topic
|
Next Topic »
15 posts, Page 2 of 2
««
1
2
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
