No announcements
-
0 Votes
Please 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 | 43709 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 | 45388 Views | Created by Michiel Wories - MSFT - Wednesday, January 17, 2007 7:40 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 | 848 Views | Created by MyCatAlex - Saturday, December 14, 2019 8:51 PM | Last reply by MyCatAlex - 15 hours 5 minutes ago -
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 | 953 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 | 615 Views | Created by Rick_DBA - Wednesday, November 20, 2019 7:53 PM | Last reply by eddyzhu - Tuesday, November 26, 2019 1:28 AM -
0 Votes
SMO 14.0.0.0 fails to script CLR Stored procedure (SMO 10.0.0.0 worked fine)
Hi We have 2008 R2 SQL Server. Using SMO ver 10 to script one of the databases that has CLR stored procedures (.Net ver 3.5). This version of ... -
0 Votes
How to do a TSQL Syntax Check with SMO
I know I have posted the answer to this at least once, and now that I need it myself I can't for the life of me find it, and I can't search through all my posts one by one to find ...Answered | 6 Replies | 13534 Views | Created by Jonathan Kehayias - Friday, August 29, 2008 1:54 AM | Last reply by Mark Burns - PMADN - Wednesday, November 6, 2019 6:42 PM -
0 Votes
Microsoft.SqlServer.Management.Smo - Bug -> Rename a Index ( .Rename(new_name) ) doubles this Index under tbl.Indexes (not physically!)
Hi, we need to create a 1:1 replic of a table which requires to rename the original table and all it's dependend objects (indexes, constraints). After calling .Rename on a ... -
0 Votes
Linked Server connection - set "Be made using this security context"
I've got a script to create Linked Server connections, and add logins. But in "For a login not defined in the list above, connections will:" I'm unable to set the "Be made using this ...Unanswered | 2 Replies | 699 Views | Created by Firmbyte - Sunday, October 13, 2019 3:21 PM | Last reply by Firmbyte - Monday, October 14, 2019 3:48 PM -
0 Votes
Problem installing Microsoft.SqlServer.BatchParser, Version 11.0.0.0 and Process Architecture AMD64
I was doing Web Deploy when I ran into this error: The package installation failed. Details: The assembly 'Microsoft.SqlServer.batchparser, Version=11.0.0.0, ...Answered | 6 Replies | 23682 Views | Created by Filip_MSDN - Friday, March 22, 2013 11:23 AM | Last reply by wayne_ Z - Monday, October 14, 2019 3:32 AM -
1 Votes
SMO Backup failed using Sql Server 2008 R2
Hello, To do database backup with C# I am using the following code: Server myServer = new Server(new ...Answered | 7 Replies | 16791 Views | Created by fofito11 - Tuesday, April 19, 2011 10:42 AM | Last reply by prashant_programer - Sunday, October 13, 2019 3:32 PM -
0 Votes
Programmatic install of SQL Server 2014 with SMO
I am currently using a VB.Net Winforms app to install SQLServer2008 R2 Express without user intervention, because SMO (Shared Management Objects) is part of SQL2008. The Winforms app uses SMO to ... -
0 Votes
Create a sql create function statement in C# with the DacFx Framework
Hello community, i posted this question in the wrong forum. So i try it here again ;) I have a working sql statement to create a ... -
0 Votes
adding query time out value manually to an higher value on the PS script connection
Hi, I need to add the query time out value to the below $ connectionDetails since i am calling $connectionDetails in all ...Answered | 5 Replies | 1353 Views | Created by Eben Raja Earnest - Friday, September 13, 2019 6:19 PM | Last reply by Eben Raja Earnest - Monday, September 16, 2019 10:38 AM -
0 Votes
Power shell command to iterate into selective databases
Hi Below part of powershell query is not able to iterate through these 4 databases selectively on the 10 DB i have , can any of you help me know where in ...Unanswered | 6 Replies | 886 Views | Created by Eben Raja Earnest - Tuesday, September 10, 2019 1:57 PM | Last reply by Stefan Hoffmann - Tuesday, September 10, 2019 3:20 PM -
0 Votes
SMO Scripting Options. How to get rid of SET ANSI_NULLS ON SET + QUOTED_IDENTIFIER ON
Hi All, I'm trying to generate scripts with powershell using SMO Scripting. The problem is that i get all my SQl Server Objects scripted but with the "SET ANSI_NULLS ...Proposed | 10 Replies | 5987 Views | Created by SMO Scription Options - Tuesday, February 14, 2017 10:31 AM | Last reply by Gentil Douglas da Silva - Wednesday, September 4, 2019 7:43 PM -
0 Votes
Backup succeeds when run from SSMS but fails when run using SMO
I have a program written in .NET that uses SQL Server SMO objects to perform regular database backups. When trying to perform a full backup using this program I get this error after the backup ...Unanswered | 1 Replies | 1060 Views | Created by GeneJoy1 - Monday, August 12, 2019 5:18 PM | Last reply by Tom Phillips - Monday, August 12, 2019 5:59 PM -
0 Votes
Code to change TCP port for SQL works locally but not remotely
Hi All. I have the piece of code below, which works fine when run locally however when run using PowerShell remoting/credssp, it comes up with an ...Answered | 11 Replies | 1844 Views | Created by MrFlinstone - Saturday, July 20, 2019 12:22 AM | Last reply by MrFlinstone - Tuesday, July 23, 2019 8:01 PM -
0 Votes
Some things about SMO
Hey, I have got two problems using SMO. First I cannot start and stop the SQL Server Agent. What property should I use? I can only ...Unanswered | 16 Replies | 13560 Views | Created by Nose77 - Friday, June 8, 2007 7:12 AM | Last reply by Sai Kiran Chary P - Monday, June 3, 2019 12:52 PM -
0 Votes
After upgrading from SQL Server 2014 to SQL Server 2017 backups fail with SMO issue
After upgrading from SQL Server 2014 to SQL Server 2017 our backup software fails to backup SQL because it can't detect SQL Server 2017 SMO (SQL Server Management Objects) and it then tries ... -
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 | 1 Replies | 1415 Views | Created by quinnj09 - Tuesday, May 28, 2019 12:16 PM | Last reply by Olaf Helper - Tuesday, May 28, 2019 1:54 PM - Items 1 to 20 of 2090 Next ›
No announcements