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 | 39437 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 | 41252 Views | Created by Michiel Wories - MSFT - Wednesday, January 17, 2007 7:40 PM
-
0 Votes
Finding Trace Files via SQL Server Management Objects (SMO)
Version: 14.0.0.0 Some please put me out of my misery! I have several hundred SQL Server instances. I want traces are running on them kind of like the Powershell ... -
1 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 ...Unanswered | 0 Replies | 222 Views | Created by madmunsterdaddy - Tuesday, September 05, 2017 6:31 PM -
0 Votes
Exception calling "Create" with "0" argument(s): "Create failed for Table 'dbo.Student'. "
Hello everyone I'm very new to SQL world I know a little bit powershell and I'm studying I'm trying to connect to database and create tables I found the below script but I'm ...Answered | 2 Replies | 186 Views | Created by fadygh - Sunday, September 03, 2017 4:49 AM | Last reply by fadygh - Sunday, September 03, 2017 6:23 PM -
0 Votes
SMO Backup event PercentCompleteEventHandler not fired
Hi, When I run this code, the event PercentCompleteEventHandler (Backup_PercentComplete); never fired. Then event ...Unanswered | 9 Replies | 11727 Views | Created by Alvaro Mosquera - Wednesday, October 05, 2011 3:15 PM | Last reply by yeahe832 - Friday, August 25, 2017 7:50 AM -
0 Votes
problem with powershell and smo
I have a code like this $objectTypeFlags = [long][Microsoft.SqlServer.Management.Smo.DatabaseObjectTypes]::All -bxor ( ... -
0 Votes
Issue when creating database using PowerShell SMO
Script [System.Reflection.Assembly]::LoadWithPartialName('Microsoft.SqlServer.SMO') | out-null $srv = new-Object ...Unanswered | 1 Replies | 676 Views | Created by Rajavignesh Paranirajan - Monday, May 29, 2017 9:41 AM | Last reply by FOXPRONEWB - Thursday, August 10, 2017 8:25 PM -
0 Votes
Error Using Assemblyin Sql 2012
I have code which tries to load the assembly Microsoft.SqlServer.ConnectionInfoExtended like so: return ...Unanswered | 0 Replies | 244 Views | Created by Nigel Tavendale - Wednesday, August 02, 2017 5:30 PM -
0 Votes
When will ServerManagementObjects.msi 2017 be available?
We are experiecing the following ...Unanswered | 1 Replies | 302 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 | 92632 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 | 9314 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 | 468 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 | 1897 Views | Created by Kasper Roma - Wednesday, August 05, 2015 7:52 AM | Last reply by Jay Sanati - Friday, June 09, 2017 8:14 PM -
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 | 535 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 | 543 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 | 2864 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 | 696 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 ... - Items 1 to 20 of 2016 Next ›
No announcements
