Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Table vs. View SQL Server 2000
Sorry for the ambiguity on what I mean by refreshed.... Thanks for the reply. I'm still reading up on this and trying to familiarize. Looking in the Books, but I also wanted to get a non-biased experience on performance when it comes to views. I think I'm finding out that there might be too...- P1A3
- Post #4
- Forum: Microsoft SQL Server: Programming
-
Table vs. View SQL Server 2000
Hi, Wondering if anyone can provide input on using Views vs. Tables in SQL Server 2000. I have been tasked with a complete redesign of a bunch derived tables that are currently loaded with along with the main tablew with each import. There are, in some cases, millions of records. The derived...- P1A3
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
-
User Job History - SQL Server 2000 Enterprise Manager
Thank you. Unfortunately, I don't have rights to use the trace utility, but it seemed like exactly what I needed. Too bad I'm in the type of corporate environment that would take months to get any new permissions granted for me. I did go and look at the sp_nrSpidByStatus link that you sent...- P1A3
- Post #3
- Forum: Microsoft SQL Server: Setup and Administration
-
User Job History - SQL Server 2000 Enterprise Manager
Hi Using SQL Server 2000 - Is there a way to view the actual stored procedure jobname initiated by a specific user with Enterprise Manager or possibly with a built-in sp using Query Analyzer. I am tasked with finding out the name of stored procedures that are being used by remote executables...- P1A3
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Setup and Administration
