Home Dashboard Directory Help
Refine Search Results
Status
Votes
Total Votes (at least)
Workarounds
Total Workarounds (at least)
Validations
Total Validations (at least)
Comments
Total Comments (at least)
Time
Created in the last (days)
Updated in the last (days)
Product Search Results
Sort By:
You searched for: sqlps or invoke-sqlcmd (signing in could show even more results)
Showing 1 - 10 of 21 Previous 123 Next

20
0
Sign in
to vote
From Connection: SQL Server
Invoke-Sqlcmd does not return raised error if query was run in Single user mode! The same code run in SSMS 2016 correctly returns the raised error if query was run in Single user mode! The below erro…
Created on 10/7/2016 (updated 4 weeks ago) | 1 validation | 0 workarounds | 0 comments | feedback id: 3105942  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
… Distributed Replay services (this is less important) I collect information through SMO and it would be useful to have it included in the collection so that there's one source of information.
Created on 9/20/2016 (updated 31 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 3103838  | 
Active
1
1
Sign in
to vote
From Connection: SQL Server
Powershell code that tries to create DMF.PolicyStore object fails. Exception is rised. $conn = new-object Microsoft.SQlServer.Management.Sdk.Sfc.SqlStoreConnection("server=servername;Trusted_Connecti…
Created on 9/6/2016 (updated 1 week ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 3101626  | 
Active
3
0
Sign in
to vote
From Connection: SQL Server
Unlike most SQL Server query tools, when there's a SQL error within a stored procedure, the Invoke-Sqlcmd Powershell cmdlet doesn't output the SP name and line number of the offending line within the …
Created on 9/2/2016 (updated 18 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 3101172  | 
Active
11
0
Sign in
to vote
From Connection: SQL Server
When using the PowerShell step type in a SQL Agent 2016 RTM job, cmdlets which use the FILESYSTEM provider fail with errors such as, "cannot find path," and, "invalid path."
Created on 6/27/2016 (updated 19 weeks ago) | 1 validation | 1 workaround | 1 comment | feedback id: 2865564  | 
Active
3
0
Sign in
to vote
From Connection: SQL Server
Invoke-Sqlcmd do not return any output when query return error "Arithmetic overflow error converting expression to data type int", SQLCMD does not have this issue Invoke-Sqlcmd -Query "SELECT conver…
Created on 5/20/2016 (updated 18 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 2729028  | 
Active
2
0
Sign in
to vote
From Connection: SQL Server
Trying to run sqlps via remote powershell session to Windows 2016 Core. It freezes after showing the version.
Created on 5/11/2016 (updated 30 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 2695245  | 
Active
24
0
Sign in
to vote
From Connection: SQL Server
SQL Server 2016 finally has a Get-SqlDatabase cmdlet however it still lacks Get- cmdlets for common SQL Server objects like Tables, Stored Procedures, Views, Triggers, etc... While the SMO Database O…
Created on 4/14/2016 (updated 7 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 2589763  | 
Active
48
0
Sign in
to vote
From Connection: SQL Server
A great capability that could easily be added to SQLPS module would be the ability to check the status of SQL Agent Jobs via a cmdlet. For this functionality it would be best to be able to pass in a …
Created on 4/13/2016 (updated 2 weeks ago) | 2 validations | 0 workarounds | 8 comments | feedback id: 2584782  | 
Active
41
0
Sign in
to vote
From Connection: SQL Server
SQLPackage.exe - Needs to be made into at least 3 cmdlets (and possibly more; we have added ideas for additional cmdlets below). The first 3 cmdlets that need to be made into are: Export-SqlDatabase…
Created on 4/5/2016 (updated 7 weeks ago) | 0 validations | 0 workarounds | 8 comments | feedback id: 2554415  | 
Active
Showing 1 - 10 of 21 Previous 123 Next