ubaert,

you can list the full text indexed columns by using:

sp_help_fulltext_columns

Also, you can list the catalogs by using:

sp_help_fulltext_catalogs

There are other sprocs in the master database that may help. Look these...

Lee,

As far as I understand it, creating a unique constraint on a column actually creates a unique index. Therefore there it would seem that there is no difference.

-Dan B

...

Do you have the AutoShrink option turned on?

-Dan B

leonx,

From an administrative and grading perspective you would be better off using one central sql server machine with all of the student databases loaded on it.

I would create...

Hey Jay,

What happens when you try to insert more data? Do you receive an error? Does the database grow in size?

-Dan B

Barsuk -

It sounds like your last plan is pretty good. Of course, it depends on your having the luxury of taking your database server offline for the duration...

Thanks Brian for the link! (and Brian for the article!)

A little more work and voila! Here is a sample proc that could be used with a scheduled job to...

Cross,

The pagefile is necessary for normal windows operation. Personally, I think the pagefile should be set to use between 1 and 1.5 times the physical memory on the box......

Thanks!

I have heard of some companies using websql console, but I have never used it.

Here is a link to the product:

http://www.websqlconsole.com

You could also check out myLittleAdmin...

Four more boxes and no issues yet... 🙂

Have not yet patched any of the clusters though.

Thanks for the info ifx!

Dan B

Nice!

Yup... all the login default databases are properly set. Only one goes the the database mentioned in the error message.

I wonder if this could be a result of each...

mdamera,

In my experience Windows machines run very oddly when any of the event logs are full. I have had servers that lock up and just in general perform badly...

Charles,

Unfortunately, simply adding the column list to this report is not enough. By joining them as above there are two distinct reports contained in one result set, ie. the...