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 | 47582 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 | 49411 Views | Created by Michiel Wories - MSFT - Wednesday, January 17, 2007 7:40 PM
Found 2104 threads
-
0 Votes
[reflection.assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") not returning information about SQL Server
I have the following powershell script that we run on many servers to retrieve the SQL ...Unanswered | 2 Replies | 4096 Views | Created by quinnj09 - Tuesday, May 28, 2019 12:16 PM | Last reply by RussRayner - Monday, August 17, 2020 7:40 PM -
0 Votes
Getting invalid version 15. (microsoft.sqlserver.smo) SSMS 17.9.1 Any fix besides SSMS 18.x?
Is there any other way to fix this issue with 17.9.1? MS dropped support of the debugger and I can't put VS on this server. I can't imagine how dropping ... -
0 Votes
SQL Server ALTER View
We had in issue with our SQL Server 2016 and the company did an upgrade to SQL Server 2019. I have several hundred views in our SQL Server. The views are working and retrieving data but If ...Unanswered | 9 Replies | 2339 Views | Created by Ray1127 - Saturday, August 15, 2020 12:05 AM | Last reply by Dan Guzman - Saturday, August 15, 2020 2:39 PM -
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 | 3179 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 | 3699 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 | 3660 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 | 15046 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 | 4403 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 | 3786 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 | 15272 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 | 4114 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 | 4413 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 | 3950 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 | 43631 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 | 270517 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 | 19758 Views | Created by MyCatAlex - Saturday, December 14, 2019 8:51 PM | Last reply by MyCatAlex - Sunday, December 15, 2019 8:25 PM - Items 1 to 20 of 2104 Next ›
No announcements
