Error generating replication scripts

first post: gbargsle wrote: I am using a powershell file suggested to extract replication infor...

Rebuilding all the indexes in the table.?

first post: sakarthikaug18 wrote: My requirement is i need to rebuild all the indexes on one table by...

I cannot load the SQL Server module.

first post: lcerni wrote: I cannot load the SQL Server module. I have SQL Server 2012 and in...

latest post: shannonlowder wrote: Mike: Here’s what I’m doing with the data flow. Load a package...

Executing SQL Procedure from Powershell : not working ( SQL 2012 )

first post: AD_MUD wrote: Hello, I have a powershell script which collects performance ...

latest post: dawidjordaan wrote: Sorry, I just noticed that my formatting is busted. Let me try agai...

SQLPSX Online Help

first post: MarkTab wrote: Dead link on https://sqlpsx.codeplex.com/documentation Supposed ...

latest post: gpvaneron wrote: Perfect. Thanks Mike!

add-sqluser => uses DEFAULT_SCHEMA for SQLUSER linked to SQLLOGIN on WINDOWS GROUP.

first post: kristofdm wrote: Hi, If i create a LOGIN based on a windows group it seems impossibl...

latest post: kristofdm wrote: Yes i know. I'm not pointing in that direction, i'm pointing to the...

When will we see a new release of SQLPSX?

first post: ruthst00 wrote: Hi, First, I want to say that we love SQLPSX and use it extensivel...

latest post: cmille19 wrote: I've built test case using PSUnit. See the Source Code under TestSc...

set-sqldata

first post: ingted wrote: Hi^^ I'm not sure if this had been fixed or not. But in the Set-Sql...

latest post: MikeShepard wrote: You're correct, [string] should be omitted since the code inspects ...

Invoke-Storedprocedure/Invoke-SQL Issue when passing a connection

first post: JimDorame wrote: Okay, so I think there might be an issue with how a connection is ...

latest post: JimDorame wrote: No thank you for the work you have done. I appreciate it greatly. -...

SQLPSX with pure 2012

first post: ingted wrote: when using sqlpsx in a host without 2008 r2 it happens "Cannot fin...

latest post: ingted wrote: BTW, smoextented error is as the previous post

get-sqldatabase issue

first post: king6080 wrote: I am trying to use get-SqlDatabase to grab database names and sizes...

latest post: dawidjordaan wrote: cmille19! You are me new hero! Thank you so much!

Cloning the database?

first post: Saritasa wrote: Guys, I'm new to SQLPSX but is it possible to write a script that ...

latest post: cmille19 wrote: I guess it depends on what you mean by clone. Do you mean backup/r...

Problem with executing Invoke-SqlRestore

first post: Saritasa wrote: Guys, trying to create automated script to import backups automati...

latest post: Saritasa wrote: okay got this fixed, I was passing folder, not file, that's why it ...

Powershell 3.0 Support

first post: JohnClark wrote: Does SQLPSX support PowerShell 3.0? My $PSVersionTable reports th...

latest post: cmille19 wrote: My bad. I just noticed it was a discussion marked private by one of...

question about Copy-ISItemSQLToFile function

first post: Red8Rain wrote: i'm on a win7 machine. SQL server is 2005. on my win7 machine, i ...

latest post: cmille19 wrote: Are you able to run the following command? get-isitem -path '\Sky' ...

2012 support

first post: Steve_oReilly wrote: Does the SQLPSX run on the SQl 2012 version? Thanks

latest post: Steve_oReilly wrote: Thanks Chad, the dtutil.exe is great and very simple to use. Hav...

Set-SqlObjectPermission problem

first post: ingted wrote: in the sqlserver module definition of function Set-SqlObjectPermis...

latest post: cmille19 wrote: This discussion has been copied to a work item. Click here to go to...

Add-SqlFileGroup returns error

first post: sqlpadawan wrote: I'm trying to use the Add-SqlFileGroup to add a filegroup to a dat...

latest post: cmille19 wrote: I'm not sure I'm able to run the following code on my machine fine:...

Get-SqlServerPermission returns error

first post: billkan wrote: get-sqlserverpermission 'xxxx' Exception calling "EnumServerPerm...

latest post: billkan wrote: Thank you, seems to work now. I have this in the script and used to...

get-sqlerrorlog column width for description

first post: sqlguy2 wrote: the column width for the description returned by get-sqlerrorlog i...

latest post: cmille19 wrote: Do you mean the output the screen? This controlled by the formattin...

Set DataFile Size

first post: AKCodeRat wrote: Is there a way to set the size of a data file with SQLPSX? The Ge...

latest post: AKCodeRat wrote: Thanks for the reply, that made it work.

Reporting Services module?

first post: yardbirdsax wrote: I was curious if there has been any thought to including a module f...

latest post: cmille19 wrote: @yardbirdsax, a module for working with SSRS would be very useful. ...

Unable to disconnect from server

first post: Tom_H wrote: I noticed recently that connections are not being removed until I c...

latest post: cmille19 wrote: This is an SMO thing. Take a look at this related post:http://sqlps...

[Resolved] Problem with EnumObjectPermissions for the login account

first post: gloox wrote: Hi all, I think I have a problem with EnumObjectPermissions which ...

latest post: gloox wrote: thanks.

[Resolved] Problem with Login.Script Method to re-create the login account

first post: gloox wrote: Hi all, I have a question about the Login.Script Method which re-cr...

latest post: gloox wrote: Thanks a lot !!!!!!!!!!!!!!!!!!

BULK INSERT fails

first post: jimmycjen wrote: when I run BULK INSERT from Management Studio it works. Below is th...

latest post: cmille19 wrote: I've hit that issues also. One of the limitations of BULK INSERTThe...

How to start using SQLPSX?

first post: jrara wrote: Is there some tutorial how to use basic commands of SQLPSX? I insta...

latest post: Zsoldier wrote: Import-Module SQLPSX

Can you connect to remote instance with Get-SqlData

first post: taints69 wrote: Is it possible to connect to a remote instance,port with: Get-SqlDa...

latest post: cmille19 wrote: Yes it works fine for me: get-sqldata -sqlserver "sql2k8r2.corp.con...

Type safe parameters in Get-SQLData

first post: mbezen wrote: I am currently looking for ways to interact with SQL Server from Po...

latest post: cmille19 wrote: Hmm, SQL Injection? I think you're missing the point of the SQLServ...

Connect to remote named instance

first post: mftosorio wrote: Need to connect to a remote instance, via TCP. This is a named inst...

latest post: cmille19 wrote: I was using invoke-sqlcmd today and figured out how to make it work...

Index rebuild/reorg

first post: gurbao wrote: I am thinking of using the Invoke-DBmaint for some maintenance, but...

latest post: cmille19 wrote: Adding param provides the most flexibility. If you do make the chan...

Add-SQLDatabaseRoleMember not working

first post: jfbradfo wrote: I love being able to manage SQL Server with PowerShell and without ...

latest post: MikeShepard wrote: Thanks, Chad...I figured you knew the answer. On , cmille19 <not...

Modification of Get-SQLErrorLog

first post: saleyoun wrote: Here a recommended update to the Get-SqlErrorLog function that will...

Problem with foreach loop

first post: king6080 wrote: I am working on the below script to gather info on my SQL Server's ...

latest post: king6080 wrote: cmille19 - your explanation made perfect sense and my edited script...

Set-ISConnectionString

first post: jimmycjen wrote: I'm trying to change the server connection inside the SSIS using Po...

latest post: jimmycjen wrote: Hi Chad,Instead of calling set-ISConnectionString (for some reason ...

invoke-BulkCopy Error

first post: amolzagade wrote: Team,I am getting following error for invoke-bulkCopyException call...

latest post: amolzagade wrote: Thanks Mike.I got the file on http://sqlpsx.codeplex.com/SourceCont...

Invoke-Sql Achoc Connection Closed Error

first post: amolzagade wrote: Team CodePlex,If you see the function below, when we supply Adhoc C...

latest post: amolzagade wrote: Thanks Mike for you immediate assistance.

import-module SQLProfiler for x64 Systems

first post: MarkTab wrote: Hello -- My comments are more of a note and solution, rather than a...

Setup error

first post: willshak wrote: Hi,After installing SQLPSX some functions work OK (e.g. Format), bu...

latest post: Bernd_K wrote: Checked OracleIse still running on x64.

problem with .csv output

first post: AndyKowalczyk wrote: Whenever I try to create a .csv file from the SQLIse add-on, I get ...

Missing "Results To" from Options

first post: saveena wrote: Not sure why, but after installing this on 2 different servers, bot...

latest post: AndyKowalczyk wrote: In the pull down menu there is an "Output Format" item. It opens a...

How do you use the performance counter functionality?

first post: ZBo wrote: Maybe I am blind, deaf, or dumb, but I don't understand how the Get...

latest post: cmille19 wrote: Looks interesting. I've added you as developer to the SQLPSX projec...

Using PS ISE to replace Management Studio

first post: ZBo wrote: I had a thought in my brain the other day of using PS ISE to replac...

latest post: cmille19 wrote: If you write scripts internally and then wish to share them inevita...

SQLPSX 2.3.1 "import-module sqlpsx" not loading Perfmon module?

first post: ZBo wrote: Isn't 2.3.1 supposed to have Laerte Junior's extensions to use Powe...

latest post: ZBo wrote: Thanks for helping me out. I am coming up to speed on PowerShell 2...

invoke-Sqlbackup and timeout

first post: dholmes wrote: how can i change the timeout for making a backup? This would have ...

latest post: cmille19 wrote: This has been fixed in the 2.3 release

Unexpected behavior from Get-SqlTable

first post: FNoltie wrote: Hello,Currently Get-SqlTable does this: foreach ($table in $...

latest post: cmille19 wrote: This has been fixed in the 2.3 release

Error when initiating New-Oracle_connection

first post: philiplavoie wrote: Hi,Apologies in advance if this has been covered or i just missed t...

latest post: cmille19 wrote: Some type of Oracle client installation is necessary for the connec...

bug in invoke-sql?

first post: dholmes wrote: Shouldn't $cmd=new-object system.Data.SqlClient.SqlCommand($sql,$c...

latest post: MikeShepard wrote: Looking at the code, the following (correct) line shows up in invok...

Similar names not handled

first post: russ960 wrote: I have a database I'm testing with and the script grabs the output ...

latest post: russ960 wrote: Thank you.

Get-SqlData?

first post: RPriesing wrote: I am trying to use Get-SqlData to run t-sql to get the logical file...

latest post: cmille19 wrote: I see a few problems, first your query has some extra double quotes...

invoke-sqlbackup

first post: RPriesing wrote: Is there a way to use multiple backup files with invoke-sqlbackup? ...

latest post: cmille19 wrote: The Invoke-SqlBackup and Invoke-SqlRestore functions are not writte...

get-sqluser Issue

first post: t0ta11ed wrote: Hey, love SQLPSX from what I've tried so far and I'm attempting to ...

latest post: cmille19 wrote: You do something like this:$db = get-sqldatabase "Z002\sql2k8" pubs...

Failed to connect to server...

first post: jimmycjen wrote: I have a (Powersehll) script that goes thru each SQL server and is...

latest post: jimmycjen wrote: Thank you for getting back to me. After some debugging, it turns ou...

connecting to SQL server into DomainA from DomainB by using windows authentication with SMO object

first post: arunyadav_ece wrote: Hi,I am connecting to SQL server into DomainA from DomainB by using...

latest post: cmille19 wrote: arunyadav_ece wrote: Hi, I am connecting to SQL server into Domain...

SQLIse Feedback

first post: cmille19 wrote: Feedback on SQLIse module

latest post: bernd_k wrote: The problem is caused in Get-ConnectionInfo by using -DataBinding.

LibrarySmo.ps1 Error when using Reporting Feature

first post: dbadon wrote: HiI am getting an error when executing the PSX job for reporting wh...

latest post: dbadon wrote: Hi Thanks a mill for the patch it is working great now!! Don

Is there a way not to show "Loading SQLPSX Module..."

first post: jimmycjen wrote: I'm executing Powershell script using EXEC master..XPCMDSHELL, but ...

latest post: jimmycjen wrote: Thank you so much. I really appreciate it.Jimmy

Import-Module SQLParser fails

first post: JapNolt wrote: When runningImport-Module sqlpsxI get this:Loading SQLPSX Module - ...

latest post: cmille19 wrote: I would look at one of two things:First, did you unblock the zip fi...

Installed - nothing returning for get-module listavailable

first post: AJMendo wrote: I just downloaded and installed the latest version SQLPSX V2 on Win...

latest post: AJMendo wrote: Yes. Just downloaded this morning.Maybe I should remove everything ...

Execute *.sql script via SQLPSX

first post: icnivad wrote: Hi,maybe i didn't looked deep enough, but is there a way instead of...

latest post: bernd_k wrote: I think it might be possible to split a script at the go lines and ...

Standardized parameter names

first post: StephenMills wrote: I would like to suggest standardizing the parameter names across th...

latest post: cmille19 wrote: This discussion has been copied to a work item. Click here to go to...

Import-Module SQLPSX corrupts PSModulePath

first post: StephenMills wrote: In Version 2.2, Import-Module SQLPSX corrupts PSModulePath and does...

latest post: Bernd_K wrote: When I wrote it, I had no opportunity to test what would happen, wh...

set-sqldata spawning so many spids

first post: sqlnoob wrote: Am I doing some wrong here? When i run the followingFor ($serverna...

latest post: cmille19 wrote: None that I can think of. If you're familiar with ADO.NET and look ...

Row Manipulation

first post: jbruns2010 wrote: I feel really stupid asking this but I looked in the online help, h...

latest post: cmille19 wrote: We're working on adding online help for additional modules includin...

how do i get column size

first post: dholmes wrote: Using the library i wrote a simple function to return the basic col...

latest post: gladysY wrote: look at the column.datatype object, they have the property MaximumL...

Import Errors

first post: Mniazi wrote: I am getting the following Errors when attempting to import the mod...

latest post: Mniazi wrote: I installed the RTM version and have imported the modules. Thanks f...

Great project

first post: barbosa wrote: I watched the webcast of Laerte showing how to use this library and...

Import SQLServer module error?

first post: rdameron wrote: PS C:\Documents and Settings\Ronald Dameron> import-module $home\D...

latest post: rdameron wrote: I moved the modules from the system location to correct location in...

It would be great if there were a feature list that was not behind a registration wall

first post: scottw wrote: So I went over to the links on the home pagehttp://www.sqlservercen...

latest post: cmille19 wrote: I couldn't agree more. I'm working on updating documentation and I...

SQLPSX 1.6.1 Release

first post: cmille19 wrote: I completed a maintenance release of SQL Server PowerShell Extensio...

latest post: SebastianCrewe wrote: This is a wonderful way to explore what PowerShell has to offer. T...

SQL Server PowerShell Extensions PowerGUI PowerPack

first post: cmille19 wrote: I created a PowerGUI PowerPack for SQL Server PowerShell Extensions...

SQLPSX Release 1.6

first post: cmille19 wrote: I completed Release 1.6 of SQLPSX which adds support for SQL Authen...

CodePlex User Contact

first post: cmille19 wrote: If you contact me directly through CodePlex using the Contact User ...

Connect Using Alternate Credentials

first post: spowser wrote: Great job thus far on this project!  I had one suggestion that I th...

latest post: spowser wrote: I'll try and get it in before the 30 day mark.  Got most of the Lib...

SQLPSX Release 1.5

first post: cmille19 wrote: I completed Release 1.5 of SQLPSX which adds 30 new functions for w...

Archive failed

first post: rdameron wrote: I was able to import data to db but the archive step failed. PS ...

latest post: cmille19 wrote: I have not seen that issue. Try adding the whatif parameter to the ...

Created Test-SqlScript and Out-SqlScript cmdlets

first post: cmille19 wrote: Test-SqlScript parses a T-SQL script and tests whether the script i...

Get-SqlData returns System.Object

first post: IrishAnto wrote: Folks,     I'm quite new to Powershell so maybe I'm doing somethin...

latest post: cmille19 wrote: Actually its an array of System.Data.DataRow which I incorrectly de...

SQL 2008 PowerShell Provider/SMO 10.0

first post: cmille19 wrote: I noticed some issues with SMO 10.0 and I've logged a bug with Conn...

latest post: cmille19 wrote: I"ve been meaning to post a follow up to this issue. The SMO 10.0 i...

SQLPSX 1.4 Release

first post: cmille19 wrote: I completed Release 1.4 of SQLPSX which adds 15 new functions for w...

report errors

first post: cuph62 wrote: Hi, i am trying to use the reporting as is included in your nice...

latest post: cmille19 wrote: The reports for SQLPSX are not meant to run from within SSMS. You c...

SQLPSX vs SQLPS

first post: ewancourtney wrote: Hi I'm new to the shell and am trying to decide the 'best' way t...

latest post: cmille19 wrote: No problem, here is the link to the blog entry you mentioned: http:...

How can I contribute?

first post: marcoshaw wrote: How can I contribute to this project? You can email me at marco s...

  • 1-83 of 83 discussions
    • Previous
    • 1
    • Next