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 | 39208 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 | 41016 Views | Created by Michiel Wories - MSFT - Wednesday, January 17, 2007 7:40 PM
-
0 Votes
When will ServerManagementObjects.msi 2017 be available?
We are experiecing the following ...Unanswered | 1 Replies | 52 Views | Created by Matt Barber - Friday, July 21, 2017 4:46 PM | Last reply by Olaf Helper - Friday, July 21, 2017 6:58 PM -
4 Votes
Microsoft.SqlServer.SqlClrProvider...dll ver 10.xx
Microsoft.SqlServer.Management.Sdk.Sfc.EnumeratorException: Failed to retrieve data for this request. ---> System.IO.FileNotFoundException: Could not load file or assembly ...Answered | 14 Replies | 91245 Views | Created by kalifumestokalifa - Thursday, August 14, 2008 7:46 AM | Last reply by king4sun - Thursday, July 13, 2017 7:21 AM -
0 Votes
userdefined Function wit SMO get Error Msg 6522
Hello I am trying to create a userdefined function that works with SMO. I wrote this class and function in C #. This will generate the Create Script for an available table, then drop the table and ...Answered | 5 Replies | 9052 Views | Created by Slodej - Wednesday, October 07, 2009 12:58 PM | Last reply by Solomon Rutzky - Tuesday, July 11, 2017 4:08 PM -
0 Votes
Can't find Microsoft.SqlServer.ConnectionInfo
Hi, I can't find this library in my installations of SQL Server 2017 and 2016. I can find this library in an installation of SQL Server 2014, but not 2016 ...Answered | 2 Replies | 156 Views | Created by Dennes - Saturday, July 08, 2017 4:51 AM | Last reply by Dennes - Saturday, July 08, 2017 3:48 PM -
0 Votes
Nested Level SQL dependency tree using SMO
I'm using SQL SMO to build tree like sql management studio dependency tree in my windows forms application Server srv = new Server(); var dependencyWalker = ...Unanswered | 3 Replies | 1681 Views | Created by Kasper Roma - Wednesday, August 05, 2015 7:52 AM | Last reply by Jay Sanati - Friday, June 09, 2017 8:14 PM -
0 Votes
Issue when creating database using PowerShell SMO
Script [System.Reflection.Assembly]::LoadWithPartialName('Microsoft.SqlServer.SMO') | out-null $srv = new-Object ...Unanswered | 0 Replies | 306 Views | Created by Rajavignesh Paranirajan - Monday, May 29, 2017 9:41 AM -
1 Votes
Versions of SMO 'compatible' with SQL2016
Hi, hope this isnt a silly question but is it okay/right/possible to install 2008R2 SMO on a SQL 2016 server? There is a legacy application which states it will only use 2008 R2 version. The ...Answered | 4 Replies | 300 Views | Created by Philip Luke - Thursday, May 25, 2017 1:35 PM | Last reply by Philip Luke - Friday, May 26, 2017 7:35 AM -
0 Votes
Cannot access SQL Server SMOs in a PowerShell script when running it remotely via WinRM with a new account
winrs -r:sqlhost -u:Administrator -p:... "powershell -file ... -
0 Votes
Issue while calling SQL job using SSMO
I have windows service which is using SMO to start a SQL job. Recently our SQL 2008 R2 has been upgraded to 2012 SP pack 3. From that time , we are getting the error 'Index was outside ...Answered | 2 Replies | 340 Views | Created by S_Sarav - Monday, May 15, 2017 12:10 PM | Last reply by S_Sarav - Thursday, May 18, 2017 4:28 AM -
0 Votes
SMO - Attempted to access an unloaded AppDomain
I have SMO code that copies a DB, which all works fine (eg drop and recreates the tables) but as soon as it comes to copying the data i get the error: Attempted to access an unloaded ... -
0 Votes
Default Values for User Defined Table Types Not Scripted Out in SQL 2016
Hi I've stumbled across a difference between SQL 2014 and SQL 2016. When you script out a user-defined table type in 2014 as CREATE any default constraints are included. This same ... -
0 Votes
How do I use SMO?
I am trying to use SMO but I am getting errors. If I try to create a new ServerConnection I get this error: Could not load file or assembly ...Unanswered | 12 Replies | 2364 Views | Created by MarDude - Wednesday, November 16, 2016 9:06 PM | Last reply by Ansel Castro - Tuesday, April 18, 2017 6:44 PM -
0 Votes
How would I set a Transfer to copy all objects EXCEPT users?
I ran into a problem when using TransferData() with "CopyAllObjects = true". In SQL Server our model database already contains users, so when we copy a database using SMO the new database ...Unanswered | 2 Replies | 491 Views | Created by Yoten - Monday, April 03, 2017 4:13 PM | Last reply by Yoten - Wednesday, April 12, 2017 8:48 PM -
0 Votes
Why can't C# SMO see extended properties on a column but Powershell SMO can?
I am attempting to read extended properties on tables and columns in a winforms C# application. I am using SQL Server SMO to do so. When I execute the application it does not see the extended ... -
1 Votes
C# Extended Events Library
Hi folks, I am wondering if there is a C# library that is able to "read" a .XEL file that's is produced by my Azure SQL Database Auditing & Thread Detection. I want to ...Answered | 2 Replies | 516 Views | Created by Larovadi - Tuesday, March 28, 2017 7:36 AM | Last reply by Larovadi - Tuesday, March 28, 2017 8:26 AM -
1 Votes
How to install SQL Server setup on Virtual machine?
Hello, I am beginner, I created one VM using MS Azure, and want to install sql server setup from my local system. means How to browse local system path on VM? How ...Proposed | 2 Replies | 617 Views | Created by Rakpa88 - Thursday, March 09, 2017 11:23 PM | Last reply by Alberto Morillo - Friday, March 10, 2017 3:02 AM -
1 Votes
Is there any way in SMO to get the current version
I have the following SMO versions installed on my ...Answered | 4 Replies | 579 Views | Created by SQLNeophyte - Wednesday, March 01, 2017 8:22 AM | Last reply by SQLNeophyte - Thursday, March 02, 2017 6:59 AM -
0 Votes
Microsoft® SQL Server® 2014 Feature Pack doesn't have SMO download image?
Hi all, The Microsoft® SQL Server® 2014 Feature Pack from this link: https://www.microsoft.com/en-us/download/details.aspx?id=42295 In the ...Answered | 3 Replies | 567 Views | Created by TrangKDuong - Wednesday, February 22, 2017 8:31 PM | Last reply by TrangKDuong - Wednesday, February 22, 2017 9:56 PM -
0 Votes
One question about Powershell
Hi all, Here I have one question about using powershell. We have developed one BAT file to generate the instance migration scripts. when we use the BAT file to ...Unanswered | 8 Replies | 632 Views | Created by Wison.W.He - Tuesday, February 21, 2017 1:58 AM | Last reply by Dan Guzman - Wednesday, February 22, 2017 9:05 PM -
0 Votes
Why an application is strictly dependent of the SMO version/level which used to be built with?
Hello, I would ask ... Why an application is strictly dependent of SMO version which used to be built with? Why it does not use the later SMO ... - Items 1 to 20 of 2011 Next ›
No announcements
