that is correct i had to assign the datareader role for every database that the user should have access to, i am missing something, coz it still does not work.

sonal.

anyone???

Jason,

The account already exists, the higher ups want a reason why it is needed.

sonal.

I actually come across this error quite often and we have service pack 3.

Sonal.

Just curious, do you have a backup plan that executes periodically?

Sonal.

I have been trying to find out how to view the "logs" when data file's grow, what tool did the person asking the question use to see the data file...

--For default instances

sp_dropserver old_name

GO

sp_addserver new_name, local

GO

--for Named instances

sp_dropserver old_servername\instancename

GO

sp_addserver new_servername\instancename, local

GO

Sonal.

"Unknown SQL Exception 8117 occured additional error information from SQL Server is included below:

Operand data type nvarchar is invalid for sum operator"

This is the only error I see in the...

There are no entries in the error log or the server log.

Don't know where else to look.

sonal.

The recovery mode was set to Full for all dbs.

Dropped old job, recreated without the model and no issues.

What are the consequence of not doing a transactional log backup of...

Steve,

That was it, did forget to apply SP3 to the second install. thanks a bunch, much appreciated.

problem solved.

sonal.

It is installed.

I did a migration from a 32 bit to a 64 bit server yesterday.

I created a named instance, realized that I should have created a default instance, no...