Silicon Investor (SI) -- The First Internet Community

STOCKTALK

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor. We ask that you disable ad blocking while on Silicon Investor in the best interests of our community. If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.

SI - Site Forums : Silicon Investor - Welcome New SI Members! -- Ignore unavailable to you. Want to Upgrade?

To: Teddy who wrote (19890)	11/12/2003 4:49:01 PM
From: Teddy	Respond to of 32921

test 1.5 pages: this works, so my guess is it has nothing to do copyright, but is all about lenght of a single post on SI. I think this limet is good. You should be aware that SQL Server Enterprise Manager does not dynamically refresh any of its containers. For example, if you create a database in SQL Server Query Analyzer, you might find it necessary to refresh the Databases container-otherwise, you might not be able to see the new database in SQL Server Enterprise Manager. You can refresh any container in SQL Server Enterprise Manager by right-clicking on it in the console tree and choosing Refresh from the shortcut menu. Registering Servers When you run SQL Server Enterprise Manager on a SQL server, it will automatically register and display that server in the console tree. You must register any other servers you want to manage from within SQL Server Enterprise Manager. You will also have to register your SQL servers if you install the SQL Server administrative tools on a client workstation. To register a server in SQL Server Enterprise Manager, right-click on the SQL Server Group container in the console tree. From the shortcut menu, choose New SQL Server Registration to start the Register SQL Server Wizard. You use this wizard to specify the server you want to connect to as well as how you want to be authenticated on that server. Once you have registered a server, SQL Server Enterprise Manager saves the registration information so that you can see that server the next time you open SQL Server Enterprise Manager. SQL Server Query Analyzer You use SQL Server Query Analyzer to run SQL queries as well as to optimize the performance of the queries. A query is simply a command you send to your server. This query can request data from the server, change data, or delete data. Queries consist of one or more SQL statements. When you run a query in SQL Server Query Analyzer, SQL Server displays your results in a separate pane called the result pane. Default Databases When you install SQL Server, the Setup utility automatically creates several system and sample user databases. System databases contain information used by SQL Server to operate. You create user databases-and they can contain any information you need to collect. You can use SQL Server Query Analyzer to query any of your SQL databases, including the system and sample databases. 1. List two features that make SQL Server a powerful database management system. SQL Server supports multiple operating systems including Windows 9x, Windows NT Workstation, Windows NT Server, and Windows NT Server Enterprise Edition; SQL Server's security, services, and performance monitoring are integrated with Windows NT; and SQL Server integrates with all of the Microsoft BackOffice applications. 2. What are the functions of the SQL Server Enterprise Manager and the Query Analyzer? The SQL Server Enterprise Manager enables you to create and manage databases and their objects and also configure server security and other optional services. The SQL Server Query Analyzer enables you to analyze the plan of a query, view statistics about its performance and execute queries.