No announcements
-
0 VotesPlease mark threads that are answered
If an answer to your question has been answered by a post, please mark that post as an answer. This allows us to keep better track of progress. The SQL Server team is ...Sticky | 0 Replies | 44149 Views | Created by Michiel Wories - MSFT - Friday, January 11, 2008 10:12 PM
-
0 Votes
Where to file product feedback (bugs, suggestions, feature requests, etc.)
See this article for details how to file product feedback: http://msdn2.microsoft.com/en-us/library/ms166362.aspx It's highly recommended to send feedback if you ...Sticky | 0 Replies | 45734 Views | Created by Michiel Wories - MSFT - Wednesday, January 17, 2007 7:40 PM
-
12 Votes
SMO 2017 Microsoft.SqlServer.BatchParser.dll load error
SMO being distributed now via NuGet is great. However there is an issue that not only myself, but others have run into as well (see comments on this ...Proposed | 30 Replies | 30215 Views | Created by madmunsterdaddy - Tuesday, September 5, 2017 6:31 PM | Last reply by СђrΐsτσρhΞr ScЋδlτξη - Monday, February 10, 2020 8:24 PM -
0 Votes
-
0 Votes
Test-SqlAvailabilityGroup : Cannot bind parameter 'InputObject'
> Test-SqlAvailabilityGroup -InputObject $ag Test-SqlAvailabilityGroup : Cannot bind parameter 'InputObject'. Cannot convert the "[HSAG]" value of type ... -
0 Votes
How do I get the backup file names using SMO ?
I can get all the LSN information using EnumBackupSets but can't find the path to the backup files. I've also tried EnumBackupSetFiles but no backup filename there ... -
25 Votes
How to drop identity property of Column
Hi all, Can any one help me or guide me how to drop identity property of a column with help of smo or ...Answered | 21 Replies | 248066 Views | Created by TechnologyasArt - Friday, November 9, 2007 11:34 PM | Last reply by Arulmouzhi - Friday, January 17, 2020 3:03 PM -
0 Votes
Cannot modify a stored procedure.
When I try to open a Stored Procedure in AdventureWorks2017 DB by clicking on Modify I get an error message: Invalid Version: 15. I have SQL Server 2017 Developer. Its version is 15.0.2070.41. I want ...Answered | 3 Replies | 1739 Views | Created by MyCatAlex - Saturday, December 14, 2019 8:51 PM | Last reply by MyCatAlex - Sunday, December 15, 2019 8:25 PM -
0 Votes
Compare SQL Tables from 2 different instances in Powershell
Hi guys. I am currently attempting to work around the issue detailed here (static data with FK issue in sqlpackage) One of the ideas I had was to build ... -
0 Votes
The current transaction cannot be committed
I have a tsql script made up of multiple batches several thousand lines long. Somewhere, in the middle of the tsql script, I have the 2 lines below. The error says the ...Unanswered | 2 Replies | 1608 Views | Created by rgelfand - Thursday, November 28, 2019 11:51 PM | Last reply by rgelfand - Friday, November 29, 2019 4:50 PM -
2 Votes
SSMS 18.4 Error RejectType: unknown property. (Microsoft.SqlServer.Smo) (#3649)
RejectType: unknown property. (Microsoft.SqlServer.Smo) Within SSMS, right click on an external table and select Script table as Create or Drop and Create. Both selections ...Discussion | 1 Replies | 1047 Views | Created by Rick_DBA - Wednesday, November 20, 2019 7:53 PM | Last reply by eddyzhu - Tuesday, November 26, 2019 1:28 AM -
0 Votes
SMO 14.0.0.0 fails to script CLR Stored procedure (SMO 10.0.0.0 worked fine)
Hi We have 2008 R2 SQL Server. Using SMO ver 10 to script one of the databases that has CLR stored procedures (.Net ver 3.5). This version of ... -
0 Votes
How to do a TSQL Syntax Check with SMO
I know I have posted the answer to this at least once, and now that I need it myself I can't for the life of me find it, and I can't search through all my posts one by one to find ...Answered | 6 Replies | 14014 Views | Created by Jonathan Kehayias - Friday, August 29, 2008 1:54 AM | Last reply by Mark Burns - PMADN - Wednesday, November 6, 2019 6:42 PM -
0 Votes
Microsoft.SqlServer.Management.Smo - Bug -> Rename a Index ( .Rename(new_name) ) doubles this Index under tbl.Indexes (not physically!)
Hi, we need to create a 1:1 replic of a table which requires to rename the original table and all it's dependend objects (indexes, constraints). After calling .Rename on a ... -
0 Votes
Linked Server connection - set "Be made using this security context"
I've got a script to create Linked Server connections, and add logins. But in "For a login not defined in the list above, connections will:" I'm unable to set the "Be made using this ...Unanswered | 2 Replies | 1039 Views | Created by Firmbyte - Sunday, October 13, 2019 3:21 PM | Last reply by Firmbyte - Monday, October 14, 2019 3:48 PM -
0 Votes
Problem installing Microsoft.SqlServer.BatchParser, Version 11.0.0.0 and Process Architecture AMD64
I was doing Web Deploy when I ran into this error: The package installation failed. Details: The assembly 'Microsoft.SqlServer.batchparser, Version=11.0.0.0, ...Answered | 6 Replies | 24499 Views | Created by Filip_MSDN - Friday, March 22, 2013 11:23 AM | Last reply by wayne_ Z - Monday, October 14, 2019 3:32 AM -
1 Votes
SMO Backup failed using Sql Server 2008 R2
Hello, To do database backup with C# I am using the following code: Server myServer = new Server(new ...Answered | 7 Replies | 17207 Views | Created by fofito11 - Tuesday, April 19, 2011 10:42 AM | Last reply by prashant_programer - Sunday, October 13, 2019 3:32 PM -
0 Votes
Programmatic install of SQL Server 2014 with SMO
I am currently using a VB.Net Winforms app to install SQLServer2008 R2 Express without user intervention, because SMO (Shared Management Objects) is part of SQL2008. The Winforms app uses SMO to ... -
0 Votes
Create a sql create function statement in C# with the DacFx Framework
Hello community, i posted this question in the wrong forum. So i try it here again ;) I have a working sql statement to create a ... -
0 Votes
adding query time out value manually to an higher value on the PS script connection
Hi, I need to add the query time out value to the below $ connectionDetails since i am calling $connectionDetails in all ...Answered | 5 Replies | 1731 Views | Created by Eben Raja Earnest - Friday, September 13, 2019 6:19 PM | Last reply by Eben Raja Earnest - Monday, September 16, 2019 10:38 AM -
0 Votes
Power shell command to iterate into selective databases
Hi Below part of powershell query is not able to iterate through these 4 databases selectively on the 10 DB i have , can any of you help me know where in ...Unanswered | 6 Replies | 1277 Views | Created by Eben Raja Earnest - Tuesday, September 10, 2019 1:57 PM | Last reply by Stefan Hoffmann - Tuesday, September 10, 2019 3:20 PM -
0 Votes
SMO Scripting Options. How to get rid of SET ANSI_NULLS ON SET + QUOTED_IDENTIFIER ON
Hi All, I'm trying to generate scripts with powershell using SMO Scripting. The problem is that i get all my SQl Server Objects scripted but with the "SET ANSI_NULLS ...Proposed | 10 Replies | 6684 Views | Created by SMO Scription Options - Tuesday, February 14, 2017 10:31 AM | Last reply by Gentil Douglas da Silva - Wednesday, September 4, 2019 7:43 PM - Items 1 to 20 of 2093 Next ›
No announcements
