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 | 42694 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 | 44377 Views | Created by Michiel Wories - MSFT - Wednesday, January 17, 2007 7:40 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 | 149 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 | 1035 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 | 12524 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 | 461 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 | 729 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 | 572 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 | 6455 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 | 1128 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 | 1456 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 | 1383 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 | 2033 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 ... -
0 Votes
Trouble running PowerShell "Failed to Connect to server".
Hello, I'm still a noob in PowerShell, I have created a script that runs smoothly on Windows Server where I have built it but it doesn't run on any other server and giving me ...Unanswered | 3 Replies | 1774 Views | Created by Shahid_Ali - Tuesday, February 12, 2019 4:43 PM | Last reply by MotoX80 - Tuesday, February 12, 2019 9:14 PM -
2 Votes
ServerInstances of ManagedComputer is empty
I am trying to turn on TCP and Named Pipes for a given SQL Server instance. I have used the same code on several different scenarios successfully but just encountered errors on Windows 7 64 ...Answered | 9 Replies | 12580 Views | Created by blitzlink - Tuesday, June 22, 2010 8:56 PM | Last reply by Fred876543 - Monday, January 28, 2019 5:30 PM -
11 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 | 25 Replies | 23486 Views | Created by madmunsterdaddy - Tuesday, September 5, 2017 6:31 PM | Last reply by donatt - Wednesday, January 9, 2019 3:39 PM -
0 Votes
SMO returning incorrect location of database files
I've got a PowerShell SMO query to find full path to log shipped database data & log files. But it is returning the location of source database files. If I query using tsql joining ... - Items 1 to 20 of 2081 Next ›
No announcements
