asked on

sql server 2008 enterprise manager replaced with studio manager...

I know that in sql server 2008 that enterprise manager has been replaced with mng studio...but where is the DTS in 2008?? where is the sql agents??

SOLUTION

ncheung

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Raja Jegan R

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

GlobaLevel

ASKER

man, thats a bummer..I mean enterprise manager and query analyzer were cool..I wonder what their vision was at MS....

there was so much you could from enterprise manager...now how do we manage the transaction logs??

>>so the inetgration services will take care of handling the trans logs as well?

Raja Jegan R

No, All features of Enterprise Manager and Query Analyzer would be handled through SSMS itself.
And to manage Transactional logs, just schedule a Transactional log backup to run at specific intervals.

Let me know what exactly you want to do so that I can provide the steps to achieve it.

GlobaLevel

ASKER

I need to run a sproc through sql server 2008 and not sure how to create that...and schedule it as well...I have sql server 2008 64-bit so I cant run the optional runtime version....

Raja Jegan R

Ok.. Follow the steps below:

1. Open SSMS and connect your SQL Server
2. Open a New query window by Right clicking your Server
3. Type in your procedure and click F5 to execute it.

To schedule that you need to create Agent job and link below would help you out:

http://databases.about.com/od/sqlserver/ss/sql_server_agent.htm
Choose T-SQL task which can help out.