I haev been working in SQL 7 for years and typically use Enterprise Manager to create/edit by stored procedures. I recently started working on a SQL 2000. Using the new version of EM, which is required for SQL 2000, I was suprised to see that the edit/view window for SPs was not sizeable. I'm not sure if there is a setting somewhere to make it sizeable or not. If not, I'm wondering what others are using to edit SPs. I like the highlighting and color in EM, so I'm particular to that --- that is, notepad just won't cut it for me. I'm looking for something a bit more integrated. Is there something I can use in Visual Studio.net Professional? Any other recommendations?
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful.
Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.