index > SQL Server SMO/DMO

SQL Server SMO/DMO

• SMO & DMO FAQ
• SqlBackUp() vs Volume Shadow Copy Service
• scripting Stored Procedures
• Mapping a user to a login
• Schedule SQL job from .net 2005
• In SQL 2005 P1 SMO - Agent Last Run datetime
• Monitor Jobs on SQL Server
• Error while restoring database,
• Close existing connection before deleting/restore database
• SMO vs DMO script object method - why SMO so verbosed/slow?
• SMO BulkCopy
• Create view using SMO
• how to convert Microsoft.SqlServer.Management.Smo.DataType to Sys...
• script to take backup of a database
• Restore all data (system must not exit during restore) using SQL ...
• Scripting whole database with one command like in DMO in 2000
• Can I create table with constrains in SMO?
• Passing array to stored procedure
• Sql Server SMO script functions with owner?
• Scripting views / stored procedures in the order of Dependency
• Force invalidate snapshot - how?
• How to use the SecurePassword
• Transferring or batch creation : Maintenance Plan
• Database Mail SQL 2005
• Restoring database with fulltext index to a different computer
• When restoring - Cannot find the specified file
• How to script Role Memebers
• SQL 2005 Express SP2 needs the SQL Server Agent Job Scheduler.
• Database.EnumObjectPermissions throws InvalidCastException
• Reading the results of a T-SQL batch run via executeimmidiate
• Database Mail (can't connect to SMTP server)
• restoring from a backup file to a new database
• Microsoft SQL Sever management Studio: Failed to open connection ...
• VarCharMax Stored proc parameters
• SQL Server 2000 Error : to connect to this server, you must use s...
• Executing large SQL-scripts through DMO
• Collection cannot be modified when TextMode has been set (Microso...
• Transfer Data by using SQL SMO
• Creating a job for SQL 2000 using SQLDMO in c#
• Hoy to Deploye VB.net Application Along With Database....Please H...
• detect licensing
• Index.IsUnique vs. Index.IndexKeyType
• Attaching a rs2005sbsDW.mdf
• SMO Transfer.TransferData InvalidCastException
• Altering table structure by comparing it to a MODEL table
• SMO - How to get remote server file system...
• Restoring using smo
• Restore fails
• Copy structore of all the table -- using MSO
• Forcefully Disconnect All Users and Drop a Database
• SMO appears to provide inaccurate log file data
• how to install SQLDMO without install SQLserver?
• Problem with creating a primary key in SMO
• To connect to this server you must use SQL Server Management Stud...
• Proplem with SQL 2005
• SMO Trace and the use of template files (*.tdf)
• URGENT: SMO help needed
• Calling the New server Registration Dialog window
• Copy Database with Microsoft.SqlServer.Management.Smo.Transfer br...
• Adding a new VarBinaryMax column to an existing table using SMO.
• Executing .sql file using SMO
• Best way to generate script
• SQL-DMO Install on SQL Server 2005 Express Client
• Why doesn't SMO script out the CASCADE option on GRANT and DENY s...
• EnumProcess doesn't display the database name
• Access SMO objects in CLR proc
• SMO within C# procedure
• Getting creation script for database (including all objects)
• Can't create table definition with primary key and SMO.
• DMO ExecuteWithResultsAndMessages2 Method Error
• DataTransfer Error
• Column index
• problem with DtsTransferProvider
• ServiceBrokerInterface: is that all there is right now?
• SMO Weirdness on SQLExpress box
• SQL Server Memory usage keeps going up using SMO
• ExecuteInMainThread
• Generate backup using SQL-DMO and SQL Server 2000 .BAK file struc...
• Permissions needed to Restore a DB using SMO
• SMO's EnumAvailableSqlServers doesn't detect my local SQLEXPRESS ...
• using sqlcmd to create sql script
• Extended Property size limit
• SetDefaultInitFields "TextBody" for Stored Procedure
• The log for database <databaseName> is not available
• taskpad view in 2005 like 2000?
• How Detect SMO is installed?
• What interface does Management Studio use?
• SetDefaultInitFields fails for a Column using ExtendedProperties
• Error detaching sql express database using SMO
• Capture hashed password with SMO?
• SMO Restore Permissions
• Any help on this SMO request?
• error
• Network SQL servers does not list after service pack (sql2005)
• SMO in VBScript
• Will SMO support vbscript soon?
• Problem with SMO on a ASP.NET page
• SP2 - Need Your Feedback!
• Compatiblity of SQLDMO and SQLSMO with respect to scripting via C...
• Can't execute View script using SMO

Articles 281

1 [2] [3] next last

Welcome to Bokebb New Update Joins the collection

New Articles

• Passing Job to a JobStep
• creating a trace definition file (TDF) v
• SmoApplication.EnumAvailableSqlServers d
• Proplem with SQL 2005
• problem with DtsTransferProvider
• Is there any sample code which creates l
• .NET2 SMO Components
• SMO Trace - Leaving connected session be
• using WriteNotifyEventHandler with trace
• PropertyGrid and SMO objects
• SMO ScriptingOptions.NoCommandTerminator
• How can I get or set a foreign key's 'on
• Create Script Database
• VS 2005 and Microsoft SQL 2000 DMO on In
• Obtaining TCP/IP Port and Pipe name

Hot Articles

• URGENT: SMO help needed
• Setting HttpExpires Metabase Property by
• insufficient access rights error when do
• Enable/Disable Job with SMO
• Database Mail (can't connect to SMTP ser
• SMO Scripter generated script does not r
• VarCharMax Stored proc parameters
• Microsoft.SqlServer.Management.Trace.Tra
• Using SMO and ClickOnce deployment
• Forcefully Disconnect All Users and Drop
• SqlAssembly.Create is a poor implementat
• TableCollection does not contain any tab
• Execute installation script.
• Anybody played with SmoBrowser example w
• Retrieve SQL servers in the network

Recommend Articles

• Retrieve a tables primary key
• SMO - How to get remote server file syst
• SQL Server 2000 Error : to connect to th
• Capture hashed password with SMO?
• Using SMO to backup / restore a SqlExpre
• Enable/Disable Job with SMO
• SMO Weirdness on SQLExpress box
• getting stored procedure information/pro
• SMO vs DMO script object method - why SM
• Managing Database Mail using Microsoft.S
• Hoy to Deploye VB.net Application Along
• How I can copy object SMO between DB and
• Create Directory in Instance Sql Server
• Forcefully Disconnect All Users and Drop
• Poor performance when looping through ta