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 | 45652 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 | 47225 Views | Created by Michiel Wories - MSFT - Wednesday, January 17, 2007 7:40 PM
Found 2102 threads
-
2 Votes
SMOs on RHEL 7.7 - Prerequisites and Installation
Hi fellow techies, I am trying to connect to an SQL Server 2017 installation on Windows Server 2016 from a Red Hat Enterprise Linux 7.7 box (both on cloud). This is one of the ...Unanswered | 4 Replies | 1017 Views | Created by Mroutlander - Sunday, July 26, 2020 4:12 AM | Last reply by Mroutlander - Monday, July 27, 2020 9:26 AM -
0 Votes
Where is gone Microsoft.SqlServer.Management.Common.ExecuteBatch?
I have tried to upgrade to the latest SMO (160.2004021.0) from the previous one (150.18208.0), but I had to revert: a class has disappeared without any prior deprecation warning, and I have no clue on ...Unanswered | 1 Replies | 1835 Views | Created by Frédéric Delaporte - Saturday, April 11, 2020 6:55 PM | Last reply by Dan Guzman - Saturday, April 11, 2020 8:19 PM -
0 Votes
Problems Creating Table SMO
Hello, I am using the following code to connect to the server and create a Table using SMO... try { ...Unanswered | 4 Replies | 1873 Views | Created by vilignoble - Friday, April 3, 2020 5:37 AM | Last reply by vilignoble - Monday, April 6, 2020 6:12 AM -
0 Votes
Table Creation with SMO failing
Hello! I'm trying to create a database and a table using SMO with a very simple console application (code below). My ...Answered | 4 Replies | 12712 Views | Created by Jemearl Smith - Wednesday, May 26, 2010 7:08 PM | Last reply by vilignoble - Wednesday, April 1, 2020 8:10 AM -
0 Votes
C# Exception Error SetParent failed for Table 'dbo.TableName'
I am using the following code to create a Table in an already existing Database using Microsoft.SqlServerObjects try { Server srv = new ...Unanswered | 8 Replies | 2103 Views | Created by vilignoble - Wednesday, March 18, 2020 8:50 AM | Last reply by vilignoble - Wednesday, April 1, 2020 8:07 AM -
0 Votes
SQL SEVER 2014
Hello Friends! when I try to install SQL SEVER 2014 on my Toshiba portage 930 PC on window 10 pro 2017, it can't start installation ? How to ... -
0 Votes
Issue with generated SQL for stored procs using SMO
We have an application that creates lightweight backups of massive SQL databases for our dev staff to be able to use locally rather than download a full 75 GB backup and restore ... -
0 Votes
2016 SMO on SQL server 2019
Hi DBAs, We have installed SQL 2019 server in our environment, later we learnt that it has a compatibility issue with the version of commvault(11.14) which we have. ...Unanswered | 1 Replies | 2053 Views | Created by KishoreKa - Tuesday, March 3, 2020 12:32 AM | Last reply by Olaf Helper - Tuesday, March 3, 2020 8:29 AM -
2 Votes
Constraint object in SMO??
Trying to drop a Primary Key, but I fail when removing the index as it is being used in a PRIMARY KEY Contraint. Is there any object or enumeration in SMO (i'm using 100 but if it ...Answered | 11 Replies | 13456 Views | Created by BabaBooey08 - Friday, April 4, 2008 2:59 PM | Last reply by Chrissy LeMaire - Tuesday, February 25, 2020 8:09 PM -
0 Votes
error in errorlog using $smo.databases.IsAccessible
in powershell script we select all databases via $smoSQL.databases | Where-Object {$_.IsAccessible} running the script we got no errors, ...Unanswered | 2 Replies | 2195 Views | Created by MarceldeStem - Saturday, February 22, 2020 10:41 AM | Last reply by MarceldeStem - Saturday, February 22, 2020 3:32 PM -
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 ...Unanswered | 1 Replies | 2248 Views | Created by Firmbyte - Wednesday, January 29, 2020 9:28 PM | Last reply by MarceldeStem - Saturday, February 22, 2020 11:06 AM -
0 Votes
Drop & Restore database fails
Microsoft.SqlServer.Management.Common.PropertyNotSetException: Property Login was not set. at ...Answered | 2 Replies | 2057 Views | Created by RenMut - Wednesday, February 19, 2020 6:43 AM | Last reply by Shanky_621 - Friday, February 21, 2020 6:37 AM -
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 | 34559 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 ... -
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 | 256046 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 | 4901 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 | 3700 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 | 3092 Views | Created by Rick_DBA - Wednesday, November 20, 2019 7:53 PM | Last reply by eddyzhu - Tuesday, November 26, 2019 1:28 AM - Items 1 to 20 of 2102 Next ›
No announcements
