>Hi,
>
>I would appreciate it if someone could help me on the following:
>
>I have several tables eg, tbl1, tbl2, tbl3.....tbl10. How to view all the
>tables structure
>and indexes using SQL Query Analyzer or using stored procedures.
>
>tq.
Hi GW,
Check out the following subjects in Books Online:
* The various INFORMATION_SCHEMA views;
* The stored procedures sp_help, sp_helpindex, and sp_indexes.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)
.
SOLVED!!!!! iis/asp + sql2000 a bit slow ... I created a stored procedure from within SQL Query Analyzer and NOT from ... I changed the ASP page to not use DNS names but instead use SQLOLEDB. ... Set RS = Connection.Execute("SET ARITHABORT ON") ... MySQL - once stored procedures and such are support on MySQL that is. ... (microsoft.public.inetserver.asp.db)
Re: UDF/SP Editor ... now learning SS2K.... I have built several stored procedures and several user ... rest of SS2K is indicative of this, I'm going back to Oracle.... You should be using SQL Query Analyzer... (microsoft.public.sqlserver.programming)
Re: Help with where clause in Stored proc and Qry Analyzer getting different rec. counts ...Stored procedures are just compiled sql statements.... Can you create a script that someone can use to reproduce the problem that you are seeing? ... > In other words, when I execute the following command in SQL Query Analyzer: exec sp_MyStoredProc '6', it returns 34 records. ... (microsoft.public.sqlserver.programming)
Re: On sysprocplan being locked ... if the modified temp tables are used by stored procedures and they have ... as will changing user permisions on the table ...Prev by Date: ... (comp.databases.informix)
Stored Procedure ... Are stored procedures are precompiled in SQL Server....John....Prev by Date: ... (microsoft.public.dotnet.framework.adonet)
