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 | 40033 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 | 41788 Views | Created by Michiel Wories - MSFT - Wednesday, January 17, 2007 7:40 PM
-
0 Votes
Why "Microsoft.SqlServer.BatchParser v11" is not there in SQL 2014
Hi Experts, Kindly help me with below query "Microsoft.SqlServer.BatchParser v11" is not there in SQL 2014 EE. Why it ...Unanswered | 4 Replies | 42 Views | Created by Vikki Vikki - Friday, April 20, 2018 12:52 PM | Last reply by Teige Gao - Monday, April 23, 2018 8:46 AM -
2 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 | 16 Replies | 3939 Views | Created by madmunsterdaddy - Tuesday, September 05, 2017 6:31 PM | Last reply by deadManN - Thursday, April 19, 2018 5:13 AM -
0 Votes
Adding Permissions to a Database View
Can you please tell me how to set with Powershell the PermissionType : SELECT to ALTER? I'm attempting to use ...Unanswered | 1 Replies | 252 Views | Created by DanFig - Friday, March 02, 2018 4:28 PM | Last reply by Ben Miller - DBAduck - Thursday, April 19, 2018 2:34 AM -
0 Votes
NuGet v140.17218.0 doesn't copy BatchParser.dll
The current version of the NuGet package (version 140.17218.0) does not copy Microsoft.SqlServer.BatchParser.dll to the build. Consequently, when I try to run an application that uses the ... -
0 Votes
How to list table from two database.
I have two database having identical schema and same table in both database. I want to iterate both database and want to compare each table in both ...Unanswered | 1 Replies | 373 Views | Created by Risu Raj - Thursday, December 21, 2017 10:37 AM | Last reply by Paul Wehland - Tuesday, February 20, 2018 11:49 AM -
0 Votes
Parametrized Query
Hello. I have a class to handle with the connection and querys with Sql Server. In all methods where it is possible to execute commands with user-entered data inputs, I use ...Unanswered | 2 Replies | 274 Views | Created by Paulo Siquiero - Thursday, February 15, 2018 6:03 PM | Last reply by Paulo Siquiero - Thursday, February 15, 2018 6:48 PM -
0 Votes
C# SMO Restore LogFile ToPointInTime Fail to find Time
0) ExecuteTransactions(); else SetDatabaseOnline(); } And the restore is going but it feels like he never gets the stop ...Unanswered | 0 Replies | 259 Views | Created by LEDRAPPIER Benjamin - Thursday, February 08, 2018 10:40 AM -
0 Votes
Required permissions for using SMO.Server?
Hello. I am working on a powershell script that gathers information our DBA's would like to have. I am using SMO.Server to pull this information but it appears I have to use sysadmin role or grant ...Unanswered | 6 Replies | 341 Views | Created by tcox8 - Wednesday, January 31, 2018 3:46 PM | Last reply by Olaf Helper - Thursday, February 01, 2018 4:48 PM -
0 Votes
Read & store (as string/stream) definition/textbody of a storedproc in code (C#/VB.NET)
I am having some challenges: 1) By way of Sql Management Studio I can run the following (which gets cut off, but that I believe is another issue) USE ...Unanswered | 1 Replies | 397 Views | Created by mxDOTnet - Friday, January 05, 2018 6:00 PM | Last reply by Olaf Helper - Saturday, January 06, 2018 5:36 AM -
0 Votes
Create database fails when run on SQL 2016
Microsoft.SqlServer.Management.Smo.WrongPropertyValueException: Cannot execute this operation while the property Growth is set to ...Unanswered | 3 Replies | 638 Views | Created by CPRow - Tuesday, December 19, 2017 9:36 PM | Last reply by CPRow - Tuesday, January 02, 2018 9:32 PM -
0 Votes
How to use Linq query to compare two table.
I have two table. I want to find differences between those table using linq query except method. How i can do it. I am using these ...Unanswered | 6 Replies | 485 Views | Created by Risu Raj - Friday, December 22, 2017 6:10 AM | Last reply by philfactor - Tuesday, December 26, 2017 4:20 PM -
0 Votes
How to compare two table
I have two table having identical schema. I want to compare two these two table to store different records in separate table. AjitAnswered | 6 Replies | 395 Views | Created by Risu Raj - Friday, December 22, 2017 8:35 AM | Last reply by Curendra - Friday, December 22, 2017 9:13 AM -
0 Votes
How to get total number of records in table.
foreach (Table myTable in myAdventureWorks.Tables) { int count = //logic for getting total number of records. //Print number of records for every table. ...Answered | 2 Replies | 374 Views | Created by Risu Raj - Thursday, December 21, 2017 1:32 PM | Last reply by Tom Phillips - Thursday, December 21, 2017 6:38 PM -
0 Votes
Get stored procedure metadata using SMO
I'm looking for an alternate way to get metadata from sql server for our code generation tool. These are the steps I currently use to get information about a stored procedure such as the return ...Answered | 3 Replies | 434 Views | Created by moondaddy - Wednesday, December 20, 2017 6:43 PM | Last reply by moondaddy - Thursday, December 21, 2017 6:03 PM -
0 Votes
How to get list of all tables having different records in two database.
I have two database having same number of tables and same schema. I want to get list of all those table which have different records. Only table name not their ...Unanswered | 1 Replies | 367 Views | Created by Risu Raj - Thursday, December 21, 2017 12:06 PM | Last reply by philfactor - Thursday, December 21, 2017 2:46 PM -
0 Votes
Create new DataBase from .BAK file using PowerShell and SMO library
Hello everyone! I'm trying to create a new database from a .bak file using powershell. Here is my script: TRY { ...Answered | 1 Replies | 671 Views | Created by Max Daniel Campos Cancino - Wednesday, November 29, 2017 8:15 PM | Last reply by Max Daniel Campos Cancino - Tuesday, December 19, 2017 1:31 PM -
1 Votes
Could not load file or assembly 'Microsoft.SqlServer.BatchParser.dll' or one of its dependencies
Hi all, We are working on silverlight application in which we are using Microsoft.sqlServer.Smo.dll, Microsoft.SqlServer.Ado.dll. On local enviorment it is working fine, but when we ...Answered | 3 Replies | 21549 Views | Created by Shambhu mishra - Monday, February 25, 2013 11:57 AM | Last reply by Selman Şahin - Thursday, December 14, 2017 10:03 AM -
0 Votes
The transaction associated with the current connection has completed but has not been disposed. Change in SMO between version 12 and 13?
Test Environment: two machines - SQL Server on first, Test App on second. Component Services - DTC disabled network on both. The following code ...Answered | 1 Replies | 589 Views | Created by ShawnCD - Monday, October 16, 2017 5:16 PM | Last reply by ShawnCD - Thursday, December 07, 2017 8:38 PM -
1 Votes
SMO Tables Collection: Accessing a table which is not in the dbo schema
null db.Tables["mdm.test"] ==> null db.Tables["[mdm].[test]"] ==> null Any ideas?? Regards ...Answered | 2 Replies | 10497 Views | Created by murph1973 - Friday, April 03, 2009 8:45 AM | Last reply by BassPro - Wednesday, December 06, 2017 4:41 PM -
0 Votes
SnapshotGenerationAgent GenerateSnapshot throws an error: The native replication resource dll failed to load
System.ApplicationException: The native replication resource dll failed to load. at ... - Items 1 to 20 of 2042 Next ›
No announcements
