When you right click on the job->properties there is a test box with owner: specify a username like your domain/admin account here and see if this works.. This is a...

set it to default at installation, whatever is selected.normally it would be SQL_Latin1_General_CP1_CI_AS.

but remember, there are other products like reporting services DB and sharepoint, whcih might use diff collations, so...

check to see this post if it is useful:

http://www.sqlservercentral.com/Forums/Topic610659-146-1.aspx

BTW: if you want to change the collation of one database use ALTER database.

For teh timeoout error do this:

in Query window: on principal server do this:

ALTER DATABASE "Db name here" SET PARTNER TIMEOUT 30

the dbname witout Quotes:

i would take a backup copies of all the databases and do a restore on the new server or if this is much of a hassle and too much data,...

on a Clustered Environment, Did you detach the nodes and stop the cluster services before attempting this:

check these links, these are helpful:

http://social.msdn.microsoft.com/Forums/en-US/sqldatabasemirroring/thread/b6312557-d240-4dcd-9cfa-a306c6ada019

http://msdn.microsoft.com/en-us/library/ms190913.aspx

did you see any errros in the SQL Agent Log or SQL Server Error Log. ?

Any resource errors or permissions Errors. ?

Are you Running the SQL Agent under a domain...

I agree.

We put off our second instance installation, when i analyzed our resouces.

I was at 4GB RAM+SQL Standard 2005/SAN/Quad Core.

The First instance had 55 DB's+SSAS+SSIS+SSRS.. so it was a BIG...

Yes, we can put the Sharepoint Db's in our regular Maintenance plan's and DR Strategies like all other databases. (That is what i do for my sharepoint DB's)

I do indexes...

try this for table growth:

This will give you number of rows and tale size in each database.

sp_msforeachdb @command1='USE [?]; DECLARE @top int

DECLARE @include_system_tables bit

SET @top= 10

SET @include_system_tables = 0

BEGIN

IF...

This is where your expertise rules in:

No human running reporting will want to pull 100M rows and he will not be able to go through all the 100 M rows...

I agree with George..

#2 or #3 are almost the same and will make sense in terms of managibility:

I have a central Rep, which has linked servers to all the other servers and i...

Try this:

From the Computer in question:

goto Start-->run-->type: "cliconfg"

in the windows check to see TCP/IP and named Pipes are on the right side List. if not add them.

goto Alias Tab: if...