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??
LVL 10
GlobaLevelProgrammerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ncheungCommented:
DTS has been replaced by SSIS.  To view legacy DTS packages built in your legacy SQL Servers from Management Studio...

You'll need to have installed the optional run-time support for DTS.
Then to view DTS packages in Management Studio, first connect to an instance of SQL Server. (Do not connect to an instance of Integration Services.)  In the Object Browser under the management\Legacy\Data Transformation Services node.  Please see the link for more details.

Link:  http://msdn.microsoft.com/en-us/library/bb500440.aspx

In regards to SQL Agents, they should be available unless you are using management studio express or do not have permissions to view SQL Agents.
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
>> I know that in sql server 2008 that enterprise manager has been replaced with mng studio...

Yes, Enterprise Manager is replaced along with Query Analyzer to Manangement Studio starting from SQL Server 2005 itself.

>> but where is the DTS in 2008??  

As mentioned above, during teh installation you should have installed Integration Services in order to view SSIS ( DTS earlier) in your system.
Kindly check for SQL Server Integration Services in services.msc to confirm whether you have installed it or not.
And for developing packages in SSIS, you need Business Intelligence Development Studio(BIDS) installed in your machine which comes as part of Client tools.

>> where is the sql agents??

Kindly run this query in SQL Server Management Studio(SSMS).

select serverproperty('edition')

If you have SQL Express edition installed, then Agent will not be availabe else make sure you have installed Notification services in your machine as part of SQL Server installation.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
GlobaLevelProgrammerAuthor Commented:
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?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
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.
0
GlobaLevelProgrammerAuthor Commented:
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....
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.