OT - SQL Server 2000

2004-08-23 Thread Steve Logan
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

RE: OT - SQL server 2000 - total number of objects in a DB

2003-01-28 Thread Jim Davis
> -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

RE: OT - SQL server 2000 - total number of objects in a DB

2003-01-28 Thread Acantrell
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 >

OT - SQL server 2000 - total number of objects in a DB

2003-01-28 Thread Andres
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

OT: SQL SERVER 2000 GOING TO Single User Mode

2001-09-24 Thread William J Wheatley
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 ~

RE: OT: SQL Server 2000

2001-05-31 Thread Eron Cohen
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

Re: OT: SQL Server 2000

2001-05-31 Thread Jeffry Houser
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

OT: SQL Server 2000

2001-05-31 Thread Art Broussard
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