View Complete Post
SQL Server Management Objects offer developers a robust toolset for backing up and restoring databases, and issuing DDL commands, as John Papa explains.
MSDN Magazine June 2007
SQL Server can be administered programmatically using system stored procedures, but Distributed Management Objects (DMO) offer a more modern, object-oriented alternative. This article introduces SQL-DMO in SQL Server 7.0 and SQL Server 2000 and describes the SQL-DMO object model, then focuses primarily on the Databases tree and the JobServer tree of the object model. The sample code and the article show how to use various objects such as the Registry object, the Configuration object, and the Database object to automate common administration tasks such as programmatically retrieving configuration settings, creating new databases, applying T-SQL scripts, and creating and scheduling backups.
MSDN Magazine May 2001
What could be wrong?
I get this error when a stored procedure is executing sp_OAMethod from SQL Server 2000 SP4.
EXEC @rc = master..sp_OAMethod @Obj, 'Execute'
The linked server is SQL Server 2005 x64.ÃÂ Already installed is SQLServer2005_BC_x64.msi version April 15, 2006.ÃÂ Local server is SQL Server 2000 SP4.ÃÂ
I can execute the sproc successfullyÃÂ in Query Analyzer from my local dev box which has both 2000 and 2005 installed.ÃÂ Profiler in 2005 indicates success for the whole sproc.ÃÂ
ItÃÂ fails when I execute in Query Analyzer while connected on SQL 2000 SP4.ÃÂ Tried this withÃÂ 3 different machines SQL Server 2000 SP4.ÃÂ The server doÃÂ not have anyÃÂ 2005 component installed.
According to Profiler in 2005, the last event that happen is
if (object_id('master.dbo.sp_MSSQLDMO80_version') is not null) exec master.dbo.sp_MSSQLDMO80_version else if (object_id('master.dbo.sp_MSSQLDMO70_version') is not null) exec master.dbo.sp_MSSQLDMO70_version else select 0
Below is the trapped Query Analyzer message.
Error Source: Microsoft Data Transformation Services (DTS) PackageÃÂ Error Description:Package failed because Step 'dts_name_removed' failed.ÃÂ Error code: 80040428 \Error Help File:sqldts80.hlpÃÂ Error Help Context ID:700ÃÂ
Step Error Source: Microsoft SQL-DMO (O
In the June 2002 installment of Basic Instincts I began a discus-sion of objects and values. This month I'll build on that column, so I will assume you've read the June installment and that you know the fundamental differences between value types and reference types.
MSDN Magazine October 2002
Am sorry if this mght be abit silly question am a Novice Developer.
If am using Visual Studio 2008 Pro, Do I need SQL Server Management Studio? or is it included in the VS 2008 Pro Suite? Am learning C# and SQL Server.
I've posted my problem in a few other categories. Sorry for that. I didn't see the security category until now.
I'm trying to use ASP.NET's built-in role/user management for a couple ASP.NET MVC 2 sites. I'm using the MVCMusicStore as my guide. I click on the Configuration Tool as the tutorial suggests, which launches the site administration page. Unfortunately when I click on the security tab, I get an error that it cannot connect to the data store. Attempting to test the AspNetSqlProvider gives me a similar error.
I've run the aspnet_regsql program as the error message suggested, and I have a role/user management database ready to go on the server. The proper tables are constructed, and all that. The configuration tool still doesn't see the data store.
As a test, I ran the MVCMusicStore demo in the debugger. Its role/user management functionality worked. I was able to add myself as a customer, and add/remove items from my cart with no errors or exceptions. However, when I attempted to access its security tab in the configuration tool, I received the same error as I get for my own project. How is it possible that role/user management works, but the configuration tool cannot change its settings?
Any suggestions on how I can get the configuration t
I just installed SQL Server 2008 Management studio Express on my Vista machine. i tried connecting to local machine using :.\sqlexpress, (local)\sqlexpress, or .\SQLExpress, MyPCNAME\SQLExpressnothing is working, getting this error:-----------------------------Cannot
connect to PC-NAME\SQLEXPRESS. A network-related or instance-specific
error occurred while establishing a connection to SQL Server. The server
was not found or was not accessible. Verify that the instance name is
correct and that SQL Server is configured to allow remote connections.
(provider: SQL Network Interfaces, error: 26 - Error Locating