How to enable SMO and SQL-DMO

When I installed SqlServer 2005 SP1, a warning message stated that I need to
install Hotfix 2047 or higher. I searched MSDN website and found Cumulative
hotfix package (buld 2153) for SQL Server 2005.
If I understand correctly there are 6 different hotfixes that must be
applied in a particular sequence and I must enable something called Server
Management Object (SMO), and SQL Server Distributed Management Object
(SQL-DMO) before installing the hotfix package.
"You must enable the SQL Server Management Object (SMO) and SQL Server
Distributed Management Object (SQL-DMO) extended stored procedures before
you install the hotfix package. For more information about the SMO/DMO XPs
option, see SQL Server 2005 Books Online."
I have searched Books Online extensively and found nothing specific about
enablling SMO and SQL-DMO. Can someone please give me the short version of
how to do this?
Thanks,
KeithThey are both enabled by default. If you want to verify, use sp_configure.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"keith" <kbrickey@.dslextreme.com> wrote in message news:OPxx0cUTHHA.480@.TK2MSFTNGP02.phx.gbl
..
> When I installed SqlServer 2005 SP1, a warning message stated that I need
to
> install Hotfix 2047 or higher. I searched MSDN website and found Cumulativ
e
> hotfix package (buld 2153) for SQL Server 2005.
> If I understand correctly there are 6 different hotfixes that must be
> applied in a particular sequence and I must enable something called Server
> Management Object (SMO), and SQL Server Distributed Management Object
> (SQL-DMO) before installing the hotfix package.
> "You must enable the SQL Server Management Object (SMO) and SQL Server
> Distributed Management Object (SQL-DMO) extended stored procedures before
> you install the hotfix package. For more information about the SMO/DMO XPs
> option, see SQL Server 2005 Books Online."
> I have searched Books Online extensively and found nothing specific about
> enablling SMO and SQL-DMO. Can someone please give me the short version of
> how to do this?
> Thanks,
> Keith
>sql

How to enable SMO and SQL-DMO

When I installed SqlServer 2005 SP1, a warning message stated that I need to
install Hotfix 2047 or higher. I searched MSDN website and found Cumulative
hotfix package (buld 2153) for SQL Server 2005.
If I understand correctly there are 6 different hotfixes that must be
applied in a particular sequence and I must enable something called Server
Management Object (SMO), and SQL Server Distributed Management Object
(SQL-DMO) before installing the hotfix package.
"You must enable the SQL Server Management Object (SMO) and SQL Server
Distributed Management Object (SQL-DMO) extended stored procedures before
you install the hotfix package. For more information about the SMO/DMO XPs
option, see SQL Server 2005 Books Online."
I have searched Books Online extensively and found nothing specific about
enablling SMO and SQL-DMO. Can someone please give me the short version of
how to do this?
Thanks,
KeithThey are both enabled by default. If you want to verify, use sp_configure.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"keith" <kbrickey@.dslextreme.com> wrote in message news:OPxx0cUTHHA.480@.TK2MSFTNGP02.phx.gbl...
> When I installed SqlServer 2005 SP1, a warning message stated that I need to
> install Hotfix 2047 or higher. I searched MSDN website and found Cumulative
> hotfix package (buld 2153) for SQL Server 2005.
> If I understand correctly there are 6 different hotfixes that must be
> applied in a particular sequence and I must enable something called Server
> Management Object (SMO), and SQL Server Distributed Management Object
> (SQL-DMO) before installing the hotfix package.
> "You must enable the SQL Server Management Object (SMO) and SQL Server
> Distributed Management Object (SQL-DMO) extended stored procedures before
> you install the hotfix package. For more information about the SMO/DMO XPs
> option, see SQL Server 2005 Books Online."
> I have searched Books Online extensively and found nothing specific about
> enablling SMO and SQL-DMO. Can someone please give me the short version of
> how to do this?
> Thanks,
> Keith
>

How to edit a asp.net2.0/C# project in VS2005, Plz HELP

hi all,

I created a new sql server 2005 database name wsat_demo in the

(lESSQL1)\sql2k5 enterprise server

in the default website properties i added a connection string named WSAT1 to wsat_demo database using aspnet_user account with SA priveledge

i modified the machine.config to use WSAT1 connection string

Then i run the WSAT (website admin tools) to create users.

this error appears. "Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'. "

i've tried attaching the database created by the asp.net project located at app_data folder named it App_data1 database

do the same configuration as stated above. Viola! the WSAT connects to it.

After comprehensive investigation, App_data1 database shows that it contains many security objects builtin to it by asp.net 2 application.

QUESTION: How can I have WSAT_demo database to have the same object as App_data1 given the fact that my connection is enjoying SA priviledge?

thanks,

joeydj

Pareng joey...musta na buhay natin?

Are you creating a database that will store user profiles? If you are, you might wanna start by creating a blank SQL Server database. Then, run the aspnet_regsql.exe and point to this blank database you just created. This is a wizard that creates all these database objects in SQL Server(whether it's 2000 or 2005). Then you can point your ASP.NET 2.0 web app to this database in your web.config. But before you can do this, make sure you override the settings in th machine.config. For a complete step-by-step guide on this, check out Scott Guthrie's blog as this was my guide when I was working on a similar task using the Beta 2 version of Visual Studio 2005

|||

okay lang. sounds like i'm at the

msforums it used to be msdn.ph

running the aspnet_regsql.exe is just like attaching the database

from the app_data on the remote server

|||

Hi,

How can i run or edit my ASP.NET 2.0/C# project in VS2005. I have source code files (including database) but it doesn't have .sln file. Please guide me how can i edit or run this in VS2005

How to download a file from a secure website

We need to download a file from a secure website using either DTS or Visual basic.Any idea??Q1 We need to download a file from a secure website using either DTS or Visual basic.Any idea??

A1 A suggestion would be to gather additional specifications (available from the website host?); generally that should constrain the possibilities somewhat and make different options easier to evaluate in relation to the local environment and local security requirements.

For example: (Is this a rare or one time event, or an hourly, daily, or weekly event? May one use / choose among vpn, ssl methods, etc.? How large a file is to be transferred and what is to be done with it?)|||use OpenURL method, it can do https

Inet1.URL = "https://www.mysecuredserver.com/myfile.txt"
bValidate() = Inet1.OpenURL(Inet1.URL, icByteArray)
Open "c:\myfile.txt" For Binary Access Write As #1
Put #1, , bValidate()

;-)
jiri