This code should help.

select so.name as [Table Name], si.name as [Index Name], so.crdate as [Create Date]

from sysobjects so inner join sysindexes si

on so.id = si.id

order by so.name, si.indid

SQL DMO (Distributed Management Objects) is a set of Objects which allow you to programatically manage SQL Server.  For example, I could write an equivalent Enterprise Manager using SQLDMO.

I'm not...

As Chris said, it's not possible to do.  Sure you can create a table that is bigger than the 8060 limit, but on inserting or updating, you will get an...

Yup, and that works!  I tried this when I got in...Forgot to update the forum.

Thanks for your input tho!

Sorry, typo by me!

Not using \\VirtualSvrName\InstanceName.  I am trying to connect with VirtualSvrName\InstanceName

I got the same problem.

Trying to connect to a virtual server from a different server.

I can ping the virtual IP address, but cannot connect.

Get an error message saying the username...

Agree with rqR'us.

There is no one procedure to analyse the database/server performance.

There are many area's which you would need to investigate.  Your question is a bit too open.  I would...

Couldn't agree more.  Well said.

Another update...

It appears that the cluster node that the database was on was overloaded.  We failed the resourse over to the other node and everything was back to normal.

Think it's...

Just an update...

Done a complete site DBREINDEX and updated all of the statistics.  Optimizations also ran for the DB's on the instance.

Although the connectivity is now better, it is still...

The server has 8Gb of memory and each instance is configured to dynamically allocate memory.  There is on limit on how much each instance can use.

This is the config of...

I guess this all depends on the actual role.  I know that a lot of DBA's do a lot aside from just administration.

Things I check on a daily basis...

* Backups

*...

Nice story Steve.

I hope all went well for your son in the competition.  Keep us posted with his results.

I guess it's down to personal preference.  Given the choice, I'd create SQL logins and apply users to roles, thus making the adding/removing of users very simple.

However, if for example,...

The databases vary in size from maybe 2Gb to 7Gb.  I agree, the reindexing/updating statistics has been defined to load balance.  The problem I have though is that 1 week...