Since this is going to be considered off topic for this list, it'd be best to reply to me off list unless this sparks an interesting discussion.
I've kind of evolved in being the "person who sets up the SQL servers for new users" as part of my job. I've managed to muddle my way around and get SQL
> -Original Message-
> From: Andres [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 28, 2003 9:28 AM
> To: CF-Talk
> Subject: OT - SQL server 2000 - total number of objects in a DB
>
>
> Hello Everyone,
> How can i get a count of all indexes a databas
x27;s already a function
that will return the number of objects in a given DB.
Adam.
> -Original Message-
> From: Andres [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 28, 2003 8:28 AM
> To: CF-Talk
> Subject: OT - SQL server 2000 - total number of objects in a DB
>
Hello Everyone,
How can i get a count of all indexes a database has? I have a SQL 2000 server and need
to get a count of various objects (tables, indexes, triggers, view, SPs) Does anyone
know of a way to get these counts WITHOUT having to do it manually?
Thank you!
Andres
Sql server 2000 keeps going into Single user mode anyone have ideas??
Thanks :)
Bill Wheatley
Director of Development
Certified Master ColdFusion 5 Developer
AEPS INC
Allaire ColdFusion Consulting Partner
www.aeps.com
www.aeps2000.com
954-472-6684 X303
ICQ: 417645
~
MAIL PROTECTED]]
Sent: Thursday, May 31, 2001 2:51 PM
To: CF-Talk
Subject: OT: SQL Server 2000
I have a web site that has SQL Server 2000 on it. I
have never even thought of touching this database
until now. I want to go in and create some tables. I
was told I can install some application on my comput
Easiest thing for you to do is get enterprise manager / Query Analyzer.
You can order the SQL Server evaluation CD for about $10 off of the
microsoft web site. (I.E. Enterprise Manager and Query Analyzer do not
time out). You will not be able to run a local SQL Server on Windows
95/98
I have a web site that has SQL Server 2000 on it. I have never even thought of
touching this database until now. I want to go in and create some tables. I was told I
can install some application on my computer that will allow me to connect to the SQL
Sever. Then use this program to create the t
8 matches
Mail list logo