No announcements
Categories
-
Select allSQL Server Integration ServicesData MiningSQL Server Reporting Services, Power ViewSQL Server Analysis ServicesSQL Server ToolsTransact-SQL.NET Framework inside SQL ServerSQL Server Data AccessSQL Server SMO/DMOSQL Server XMLSQL Server ReplicationSQL Service BrokerSQL Server SecuritySQL Server Database EngineSQL Server DocumentationSQL Server Setup & UpgradeSQL Server High Availability and Disaster RecoverySQL Server Notification ServicesSQL Server CompactGetting started with SQL ServerDatabase MirroringSQL Server ExpressMicrosoft Drivers for PHP for SQL ServerSQL Server Data WarehousingSQL Server SearchSQL Server SpatialSQL Server Samples and Community ProjectsMicrosoft StreamInsightDatabase DesignSQL Server MigrationSQL Server Master Data ServicesSQL Server Application and Multi-Server ManagementSQL Server PowerPivot for ExcelSQL Server PowerPivot for SharePointSQL Server ManageabilitySQL Server Distributed ReplaySQL Server Data Quality ServicesMicrosoft HDInsight (Windows and Windows Azure)SQL Server Data Tools
-
Select allAnnouncements for all ForumsForums Redesign - Q&A / DiscussionsWhere is the Forum For…?Forums Issues (not product support)Suggestions and Feedback for the ForumsOff-Topic Posts (Do Not Post Here)MSDN and TechNet Profile and Recognition System Discussions
-
Select allVisual C#Visual BasicVisual C++C++ Standards, Extensions, and InteropParallel Computing in C++ and Native CodeVisual F#Microsoft "Roslyn" CTP
-
Select allVisual Studio General QuestionsVisual Studio Setup and InstallationVisual Studio ExtensibilityVisual Studio Tools for OfficeVisual Studio EditorMSBuildVisual Studio LightSwitch ExtensibilityVisual Studio LightSwitch - General QuestionsLightSwitch HTML Client PreviewVisual Studio Visualization & Modeling ToolsTesting with Visual Studio Test Manager (MTM)Test Tools in Visual Studio 2010 and 2012Visual Studio Unit TestingVisual Studio Diagnostics (Debugger, Profiler, IntelliTrace)Visual Studio Tools for Applications (VSTA)
-
Select allUI Design for Windows Store appsTailoring your Windows Store app for hardware and devicesBuilding Windows Store apps with HTML5/JavaScriptBuilding Windows Store apps with C++Building Windows Store apps with C# or VBBuilding Windows Store games with DirectXTools for Windows Store appsPublishing Windows Store apps
-
Select allApplication Compatibility for Windows Desktop DevelopmentDeveloping Windows Desktop Applications with Power ManagementWindows Desktop Development for Accessibility and AutomationDirectShow DevelopmentGeneral Windows Desktop Development IssuesWindows Desktop Development for Ink, Touch, and Tablet PCMedia Foundation Development for Windows DesktopMicrosoft Message Queuing (MSMQ)Network MonitorWindows Desktop Optical Platform DiscussionPeer-to-Peer Networking for Windows DesktopApplication Security for Windows DesktopWindows Desktop Sidebar Gadget DevelopmentUser Interface development for Windows DesktopVisual C++Windows Desktop DebuggingWindows Desktop Search DevelopmentWindows Desktop Search HelpWindows Filtering Platform (WFP)Windows Imaging Component (WIC)Windows Desktop Perfmon and Diagnostic toolsWindows Desktop Pro-Audio Application DevelopmentWindows Desktop SDKWindows Desktop Web Services API (webservices.dll)Windows Desktop Winsock Kernel (WSK)Windows Hardware WDK and Driver DevelopmentDevelopment with the Windows Sensor and Location PlatformWindows Desktop Ribbon DevelopmentWindows Hardware Testing and CertificationC++ Standards, Extensions, and InteropMessage Analyzer
-
Select allDeveloping for Windows PhoneTools for Windows Phone developmentShare your "How To" samplesPush NotificationsIn-App AdvertisingMango Update (Archived)Expression Blend for Windows Phone
-
Select allDeveloping Apps for Office 2013General Office DevelopmentAccess for DevelopersExcel for DevelopersOutlook for DevelopersWord for DevelopersOpen XML Format SDKVisual Studio Tools for Office
-
Select allWindows Azure DevelopmentWindows Azure Troubleshooting, Diagnostics & LoggingWindows Azure Storage, CDN and CachingWindows Azure SQL DatabaseConnectivity and Messaging - Windows AzureManaging Services on Windows AzureSecurity for Windows AzureWindows Azure Purchasing, Pricing & BillingWorkflow Manager 1.0Service Bus 1.0Windows Azure Active DirectoryWindows Azure Active AuthenticationWindows Azure Media ServicesWindows Azure BizTalk ServicesWindows Azure Virtual NetworkWindows Azure Virtual Machines
Filter
:
All Threads
All Threads
Answered
Unanswered
Proposed Answers
General Discussion
No Replies
Helpful
Has Code
All Languages
-
Sticky0VotesPlease 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 ...
-
Sticky0Votes
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 ...
-
Unanswered0Votes
DataTransfer Progress Event with SMO
I'm trying to report on the smo data transfer progress of my powershell script. I am receiving the error: Cannot convert argument "0", with value: ... -
Answered0Votes
Inserting a DataColumn in Sql Table using Smo?
With the help of Alok and SREEKAR I now have a powerful way to manipulate my Sql Server tables matadata including adding, deleting columns and peeking into properties using Smo. It is very convenient. ... -
Answered0Votes
Copy Database with Microsoft.SqlServer.Management.Smo.Transfer breaks identity columns
Hello I have a task to copy at runtime "etalon" database inside one same SQL 2005 server. Everythings ok except identity fields: identity breaks in new database.I use such ... -
Answered2Votes
Converting and comparing SMO.DataType to CLR type
I'm sure this question has come up plenty of times before, but does anyone have a good technique for deriving a CLR type from the slew of various SMO types? I have no issue with creating the ... -
Answered1Votes
ALTER TABLE ALTER COLUMN [access-id] failed because one or more objects access this column
Hi when I'm upgrading table schema with alter statement I'm getting error like this ALTER TABLE ALTER COLUMN [access-id] failed because one or ... -
Answered0Votes
Set Compatibility Level SQL2012
All, I am trying to set the compatibility level of a database using SMO in SQL 2012. The problem is when I go to set it to 110 I get an error message stating ... -
Answered2Votes
Some questions on SQL SERVER SMO - Generating Table DDL
I am uisng sql server 2008 and Visusla Studio 2008 C# to automatically generate ddl scripts and dml scripts (Insert statements for my database). I am used to Oracle's export/impot utility and want to ... -
Answered0Votes
Stop Mirroring using SMO
How to stop mirroring on a database. I tried the following code in powershell but it did not work ... -
Answered14Votes
How to drop identity property of Column
Hi all, Can any one help me or guide me how to drop identity property of a column with help of smo or ... -
Answered2Votes
SQL Server 2008 R2: System.InvalidOperationException: Operation is not valid due to the current state of the object
The SSMS generate Scripts option (ALL OBJECTS - SINGLE FILE OPTION) was working fine. Since few days its giving error on UDT ... -
Unanswered0Votes
SubscribeToEvents Server Method Error Hresult: 0x80070005 Access Denied
Hi there; I am developping a smo app that uses the Server.Events.SubscribeToEvents Method and actually a have a Access Denied Error if I use it local and I have a ... -
Answered2Votes
requirements for upgrading sqldmo code in c++ to sqlsmo
Hello, I am in process of upgrading my c++ code using sqldmo to work with sql server 2012. Could you pls let me know if its possible to use ... -
Unanswered0Votes
Capture only errors in ConnectionContext ServerMessage event
I have the following code Server server = new Server(new ServerConnection(sqlConnection)); server.ConnectionContext.ServerMessage += new ... -
Answered0Votes
Difference bewtween InfoMessage and SeverMessage events
Can somebody tell me, what's the difference between SMO Server ConnectionContext, SeverMessage and InfoMessage events? Sunil -
Proposed1Votes
Generate Scripts with dependency preserved (SQL 2008 R2, SQL 2012)
Generate Scripts..." does not preserve the dependency order of objects ie. when selected a set of tables and sprocs, it generates the scripts for the sprocs first. I have read ... -
Answered0Votes
sp_OACreate monitoring tool
Hi All, I have an interesting situation. Task on hand is to make a log entry whenever sp_OACreate is used or called from SQL Server query analyzer with a specific ... -
Proposed4Votes
SQLServer SMO connection failed after deploy on IIS
I built an MVC 4.0 application to manage server jobs on my server. The application worked fine in VS 2012 environment (IIS Express) but after deploy on IIS I get this ... -
Answered2Votes
SQL Trace .NET
http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.trace(v=sql.105).aspx is it possible to create a sql trace via .net and just collect the data in memory, ... -
Answered0Votes
Determining SQL max / min server memory configuration via WMI
Hi, I haven't been able to find any way to retrieve the max / min server memory settings for a SQL Server instance via WMI. I know it's possible to use sp_configure, or to examine ... -
Answered0Votes
create a sql agent job through website in c#.net
how to create a sql agent job and add 3 packages for job steps dynamically through website in C#.net?? when i type "test" in textbox in website ... - Items 1 to 20 of 1776 Next ›
