Re: SQL Enterprise Manager equivalent for 2005
thanks heaps for the advice guys. i am currently downloading the ems manager lite suggested by mike. looks right up my alley. cheers mike There is a free tool for SQLServer2005 at http://sqlmanager.net/products/mssql/manager/. It's called EMS SQLManager Lite. The Lite part means it doenst have some features on it, but nothing that would worry us for what we do. The bits taken out are for professional DBAs and what's left is fine for making tables, manipulating data, modifying databases, etc. The extract database is a neat feature that allows turning an entire database, or teh structure only, or the data only in to a SQL Script that you can run i a query analyser to duplicate the database on another server. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 2/25/07, Mike | NZSolutions Ltd [EMAIL PROTECTED] wrote: ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270723 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Enterprise Manager equivalent for 2005
There is a free tool for SQLServer2005 at http://sqlmanager.net/products/mssql/manager/. It's called EMS SQLManager Lite. The Lite part means it doenst have some features on it, but nothing that would worry us for what we do. The bits taken out are for professional DBAs and what's left is fine for making tables, manipulating data, modifying databases, etc. The extract database is a neat feature that allows turning an entire database, or teh structure only, or the data only in to a SQL Script that you can run i a query analyser to duplicate the database on another server. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 2/25/07, Mike | NZSolutions Ltd [EMAIL PROTECTED] wrote: Hi guys, Did a bit of research on this topic, but a little confused. What should I be using as an enterprise manager equivalent for sql server 2005 (hosted at my webhost). I wish to be able to connect to the db and create/organise tables - including reordering columns, and also create queries/views/sp's. Am wondering if I need to purchase full license of sql server 2005 for my local machine to achieve this ? Any help/advice would be appreciated. mike ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270649 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Enterprise Manager equivalent for 2005
Mike | NZSolutions Ltd wrote: Hi guys, Did a bit of research on this topic, but a little confused. What should I be using as an enterprise manager equivalent for sql server 2005 (hosted at my webhost). I wish to be able to connect to the db and create/organise tables - including reordering columns, and also create queries/views/sp's. Am wondering if I need to purchase full license of sql server 2005 for my local machine to achieve this ? Any help/advice would be appreciated. mike ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270626 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SQL Enterprise Manager equivalent for 2005
I'm not sure this came through properly the first time so here it goes again... sorry if this is a duplicate post. In SQL Server 2005, the Enterprise Manager has been replaced with the SQL Server Management Studio. There is a version called SQL Server Management Studio Express Edition that is a free download that you should be able to use. According to the docs, it supports connections to other versions of SQL Server 2005 (not just the express edition), as well as SQL Server 2000 and MSDE. HTH Steve Mike | NZSolutions Ltd wrote: Hi guys, Did a bit of research on this topic, but a little confused. What should I be using as an enterprise manager equivalent for sql server 2005 (hosted at my webhost). I wish to be able to connect to the db and create/organise tables - including reordering columns, and also create queries/views/sp's. Am wondering if I need to purchase full license of sql server 2005 for my local machine to achieve this ? Any help/advice would be appreciated. mike --- --- ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270627 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SQL Enterprise Manager equivalent for 2005
SQL Server Management Studio combines the features of Enterprise Manager *AND* Query Analyzer in a single tool, which is great. You do not need a full license, you can install the client software locally - just download the trial of SQL 2005 and install only the client software. Rick On 2/24/07, Mike | NZSolutions Ltd [EMAIL PROTECTED] wrote: Hi guys, Did a bit of research on this topic, but a little confused. What should I be using as an enterprise manager equivalent for sql server 2005 (hosted at my webhost). I wish to be able to connect to the db and create/organise tables - including reordering columns, and also create queries/views/sp's. Am wondering if I need to purchase full license of sql server 2005 for my local machine to achieve this ? Any help/advice would be appreciated. mike ~| ColdFusion MX7 by AdobeĀ® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270628 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SQL Enterprise Manager equivalent for 2005
Get the Microsoft Action Pack you get a ton of Microsoft software for only $299 per year, Including SQL Server 2005. https://partner.microsoft.com/us/40013779 Enrollment is open to: Resellers, Technology Consultants, Value-added Technology Partners, System Integrators, System Builders, and best of all Developers which means you and probably the rest of us. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270630 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL Enterprise Manager equivalent for 2005
If you want a GUI tool that will interface (connect and more) to MS-SQL 7, 2000, 2005, as well as MySQL, SyBase, Oracle, etc... Try Aqua Data Studio from Aqua Fold http://www.aquafold.com -Original Message- From: Mike | NZSolutions Ltd [mailto:[EMAIL PROTECTED] Sent: Saturday, February 24, 2007 8:14 PM To: CF-Talk Subject: SQL Enterprise Manager equivalent for 2005 Hi guys, Did a bit of research on this topic, but a little confused. What should I be using as an enterprise manager equivalent for sql server 2005 (hosted at my webhost). I wish to be able to connect to the db and create/organise tables - including reordering columns, and also create queries/views/sp's. Am wondering if I need to purchase full license of sql server 2005 for my local machine to achieve this ? Any help/advice would be appreciated. mike ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270631 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SQL Enterprise Manager
Use the Client Network Utility to create aliases for each connection. HTH, Scott -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 3:06 PM To: CF-Talk Subject: OT: SQL Enterprise Manager Sorry for the OT post - I'm stumped. Using Enterprise Manager for MS SQL Server 2k, how can I register a server twice so I can use different DBs with different login credentials?It's a major pain having to disconnect and reconnect, using different credentials, over and over and over throughout the day. I have logins to the individual databases - no blanket access to the machine. TIA, Jeff _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Enterprise Manager
or use 1 to connect with the IP and the other to connect with the server name [EMAIL PROTECTED] 10/20/03 03:07PM Use the Client Network Utility to create aliases for each connection. HTH, Scott -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 3:06 PM To: CF-Talk Subject: OT: SQL Enterprise Manager Sorry for the OT post - I'm stumped. Using Enterprise Manager for MS SQL Server 2k, how can I register a server twice so I can use different DBs with different login credentials?It's a major pain having to disconnect and reconnect, using different credentials, over and over and over throughout the day. I have logins to the individual databases - no blanket access to the machine. TIA, Jeff _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Enterprise Manager
That is sooo sweet!Thanks - I was thinking that only aliased the server, and wouldn't allow multiple definitions to the same IP.Life is now much easier :-) -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 3:08 PM To: CF-Talk Subject: RE: SQL Enterprise Manager Use the Client Network Utility to create aliases for each connection. HTH, Scott -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 3:06 PM To: CF-Talk Subject: OT: SQL Enterprise Manager Sorry for the OT post - I'm stumped. Using Enterprise Manager for MS SQL Server 2k, how can I register a server twice so I can use different DBs with different login credentials?It's a major pain having to disconnect and reconnect, using different credentials, over and over and over throughout the day. I have logins to the individual databases - no blanket access to the machine. TIA, Jeff _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Enterprise Manager
Jeff, just a note - remember that even if you use different usernames that point to different default dbs, EM will still display the whole browselist of databases - even ones NOT authorized for that username - so if you are trying to streamline the length of the sidebar - it may not give you the result you desire. -Mark -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 2:58 PM To: CF-Talk Subject: RE: SQL Enterprise Manager That is sooo sweet!Thanks - I was thinking that only aliased the server, and wouldn't allow multiple definitions to the same IP.Life is now much easier :-) -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 3:08 PM To: CF-Talk Subject: RE: SQL Enterprise Manager Use the Client Network Utility to create aliases for each connection. HTH, Scott -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 3:06 PM To: CF-Talk Subject: OT: SQL Enterprise Manager Sorry for the OT post - I'm stumped. Using Enterprise Manager for MS SQL Server 2k, how can I register a server twice so I can use different DBs with different login credentials?It's a major pain having to disconnect and reconnect, using different credentials, over and over and over throughout the day. I have logins to the individual databases - no blanket access to the machine. TIA, Jeff _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Enterprise Manager
Thanks for the tip, Mark. I've got three DB's on one server - all for different clients.I usually switch back and forth all day long, and typing the username/pass combos over and over was getting dull - they use good passwords:) This is much easier! -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 4:24 PM To: CF-Talk Subject: RE: SQL Enterprise Manager Jeff, just a note - remember that even if you use different usernames that point to different default dbs, EM will still display the whole browselist of databases - even ones NOT authorized for that username - so if you are trying to streamline the length of the sidebar - it may not give you the result you desire. -Mark -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 2:58 PM To: CF-Talk Subject: RE: SQL Enterprise Manager That is sooo sweet!Thanks - I was thinking that only aliased the server, and wouldn't allow multiple definitions to the same IP.Life is now much easier :-) -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 3:08 PM To: CF-Talk Subject: RE: SQL Enterprise Manager Use the Client Network Utility to create aliases for each connection. HTH, Scott -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 3:06 PM To: CF-Talk Subject: OT: SQL Enterprise Manager Sorry for the OT post - I'm stumped. Using Enterprise Manager for MS SQL Server 2k, how can I register a server twice so I can use different DBs with different login credentials?It's a major pain having to disconnect and reconnect, using different credentials, over and over and over throughout the day. I have logins to the individual databases - no blanket access to the machine. TIA, Jeff _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Enterprise Manager
Ah... got it. -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 3:53 PM To: CF-Talk Subject: RE: SQL Enterprise Manager Thanks for the tip, Mark. I've got three DB's on one server - all for different clients.I usually switch back and forth all day long, and typing the username/pass combos over and over was getting dull - they use good passwords:) This is much easier! -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 4:24 PM To: CF-Talk Subject: RE: SQL Enterprise Manager Jeff, just a note - remember that even if you use different usernames that point to different default dbs, EM will still display the whole browselist of databases - even ones NOT authorized for that username - so if you are trying to streamline the length of the sidebar - it may not give you the result you desire. -Mark -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 2:58 PM To: CF-Talk Subject: RE: SQL Enterprise Manager That is sooo sweet!Thanks - I was thinking that only aliased the server, and wouldn't allow multiple definitions to the same IP.Life is now much easier :-) -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 3:08 PM To: CF-Talk Subject: RE: SQL Enterprise Manager Use the Client Network Utility to create aliases for each connection. HTH, Scott -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 3:06 PM To: CF-Talk Subject: OT: SQL Enterprise Manager Sorry for the OT post - I'm stumped. Using Enterprise Manager for MS SQL Server 2k, how can I register a server twice so I can use different DBs with different login credentials?It's a major pain having to disconnect and reconnect, using different credentials, over and over and over throughout the day. I have logins to the individual databases - no blanket access to the machine. TIA, Jeff _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]