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 | 42967 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 | 44644 Views | Created by Michiel Wories - MSFT - Wednesday, January 17, 2007 7:40 PM
-
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 | 659 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 | 287 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 | 5096 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 | 423 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 | 1267 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 | 12768 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 | 711 Views | Created by quinnj09 - Tuesday, May 28, 2019 12:16 PM | Last reply by Olaf Helper - Tuesday, May 28, 2019 1:54 PM -
1 Votes
Windows Server 2019 + SQL Server 2017 - SqlDataSourceEnumerator.Instance.GetDataSources() does not locate local SQL server 2017 instance
I have configure Windows Server 2019 Standard + SQL Server 2017 developer. My application in C#.net uses SqlDataSourceEnumerator.Instance.GetDataSources() which is not able to ...Answered | 2 Replies | 989 Views | Created by AngelVpd - Saturday, May 11, 2019 12:30 PM | Last reply by AngelVpd - Friday, May 24, 2019 8:50 AM -
0 Votes
With SQL Server 2008 going out of support in July, does that also apply to SSMO 2008?
Uh... Asking for a friend.Answered | 2 Replies | 815 Views | Created by Peter D Wickham - Thursday, May 23, 2019 6:01 AM | Last reply by Peter D Wickham - Friday, May 24, 2019 1:19 AM -
1 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 | 14 Replies | 6787 Views | Created by MarDude - Wednesday, November 16, 2016 9:06 PM | Last reply by Darko Martinović - Tuesday, April 30, 2019 6:25 AM -
0 Votes
Execute as caller added to altered procedures
Hello everybody, maybe one of you could point me to the right direction. I have some C# Code using SMO. The code creates and alters stored procedures (retaining the procedure ...Unanswered | 1 Replies | 1360 Views | Created by Benjamin Kettner - Friday, April 5, 2019 10:44 AM | Last reply by Olaf Helper - Friday, April 5, 2019 11:56 AM -
0 Votes
How to ALTER…CHECK CHECK CONSTRAINT using PowerShell and SMO
I have a PowerShell script that checks if the Constraint is enabled and checked. I want to add a step to do the equivalent of "ALTER.....CHECK CHECK CONSTRAINT" but I'm ... -
0 Votes
What is the way to install SQL Server 2017 SMO using PowerShell
This is what I have tried so far in PS: # This lists my providers Get-PackageProvider -ListAvailable Results include ...Answered | 6 Replies | 1741 Views | Created by Dusty of BI Goals - Saturday, March 16, 2019 2:03 PM | Last reply by Dusty of BI Goals - Saturday, March 16, 2019 5:10 PM -
0 Votes
Move to new AD group
Hi, We are moving from one AD to another. How it will affect SQL installation and what are precautions and actions needs to be taken. One of the servers is SSRS ...Unanswered | 1 Replies | 1637 Views | Created by Ashru - Monday, March 11, 2019 5:59 AM | Last reply by Ashru - Monday, March 11, 2019 10:36 AM -
0 Votes
Transfer Tasks SMO - works Intermittently
User::SourceConnection is set to: " + Dts.Variables("User::SourceConnection").Value.ToString(), Nothing, -1, True) Dts.Events.FireInformation(0, "", ... -
0 Votes
ServiceCache.ScriptFactory nullReferenceExcepiton
I have a SSMS extension built for SSMS 2008 that opens a new Query and inserts the query in it. Now im am trying to use the same extension in SSMS 2017 but it seems i can't get it ... -
3 Votes
Making SQL Server databases and tables in C#
There's more then likely 1000's of post like this. Just finding the one I want would be a pain. What I want to do is detect that SQL Server is installed. if so create a database and ...Proposed | 36 Replies | 2282 Views | Created by Joesoft11a - Friday, February 8, 2019 1:42 AM | Last reply by Joesoft11a - Friday, March 1, 2019 6:15 PM -
0 Votes
DMO backups with password, can't restore using SMO...Password is not supported
I have a bunch of customers with password protected backups made using DMO. Our latest software packaged now uses SQL2014 express and our backup tool now uses SMO instead of ... - Items 1 to 20 of 2084 Next ›
No announcements
