I\'d like to use SMO to do several things that aren\'t easily done in T-SQL. However, all the examples I\'ve found are for C# or Powershell.Is there an easy way to invoke SMO via T-SQL, as you could d
Is it required to have anything SQL Server related installed on a web server in order to make use of SMO? I\'ve built a web app that programmatically creates a SQL Agent job, adds a step (which ultima
I am using SQL Server Management Studio 2008 R2 to manage a SQL Azure database.When I try to right-click on any of the objects in the database, and do 开发者_运维问答Script Table As -> CREATE -> New Q
I got some path while working on a project but not able to figure out the kind of it. What is this and how can I access it.
I am creating a setup project for a product.For my install, I have an executable that is run as a custom action.This executable is responsible for executing a SQL script during the install.However the
Using SSMS for the following statement I can see the estimated plan using Display Estimated Plan command.
I am sing C#, .NET 3.5, and SMO to create a copy of a database (o开发者_运维问答ur production database) to some other databases (our DEV and Test-database) in SQL Server 2005.
You can set the usermappings voor a user in sql server for a database, is this possible to do it in C#? for example setting db_owner permissions on a datab开发者_StackOverflowase for a user, using SMO
I am trying to set up a C# tool that scripts an entire database from the tables down to the stored procedures. I want to get all the schema and data. I am having a hard time finding much on the net on
How can i backup and restore a database with file stream Using SMO 开发者_开发技巧in C#. i found some attributes in Server Class in SMO Like \"FilestreamLevel\" and \"FilestreamShareName\"