What version of SQL server are you using and what are the errors being returned by DBCC SHRINKFILE() ?

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring...

The best way to is to get a baseline of the system before the adding the indexes. First, use Performance Monitor to capture performance levels for processor, memory, lock wait...

I've written an e-Book published by NetImpress that discusses these types of questions. There is a discount for SQL Server Central users. The link to purchase is my signature.

K. Brian...

What numbers are appearing?

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

Take your pick:

http://www.puzzlers.org/secure/wordlists/dictinfo.html

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

If your SQL Server service is running and you don't see counters, try this:

http://support.microsoft.com/default.aspx?scid=kb;en-us;196657

There are other articles that detail other possibilities, but apparently Microsoft is still working out the bugs...

I haven't used it, but there is SQSH. You may need the FreeTDS libraries to connect to SQL Server.

SQSH:

http://www.sqsh.org/

FreeTDS:

http://www.freetds.org/

HTH.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring...

According to his author info, Randy Dyess at Verizon has some VLDB. The single largest is > 2.2 TB.

http://www.transactsql.com/Author.html

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring...

There is also always the option of going to three letters with something like a z or q used if someone doesn't have a middle name.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to...

SQL Server 7.0 is limited to 2 GB of RAM in standard edition. In EE it comes with support up to the maximum the vendor supports. You'll have to configure...

I'm not surprised. Too many things break when you lock down sysdatabases. Which begs the question, why does the public role need access to file path locations in the first...

The alert mechanism in the SQL Server Agent properties doesn't allow for a differentiation. That's probably how you're getting notified. You may check there to verify. Unfortunately, there aren't criteria...

The SQL Server Agent will talk to the Application Event Log on the server. If you are in the process of clearing it, it won't be available for use by...

This is the on-link to Books Online's section on Installing SQL Server. This should give you a good overall impression of what runs, why, and what options you have:

http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/sql/in_overview_0lm4.htm

K. Brian...

quote:

---

I am hesitant to start SMTP locally on a win2k box because I don't yet know how to prevent anyone from turning...