Thanks - you were right - the view was referencing another DB - So I: GRANT SELECT ON tableName TO userName (for that DB)

and it works fine

Thanks

Thanks for the replies.

One more permission related issue: If I execute this: EXEC sp_addrolemember 'db_datareader', 'User_Name_Here'

It give the user SELECT permissions on tables , but not views.

How can I...

Even though the status is "sleeping" ?

Could this be adding to the fact that the CPU is flat lining?

Can I kill these processes and will that solve my problem?

Well actually it's not me that wants to do this.

The question came from a developer working on a development server.

I guess he just wanted to know for interest sake -...

No the process is not being blocked. Here are some column values for that process for sp_who2.

Status, Command, CPUTime, DiskIO, ...

Well it's been over 5 hours now AND STILL running 🙁

Thanks for all your replies but I was now thinking: As mentioned it does UPDATES and INSERTS to tables....

I am getting the same error - says the job fails, but the log files are created in any case.

Maintenance history shows it was successful but the job history shows...

Thanks - I tried your suggestion -works just fine.

Appreciate it!!

Thank you - trailing spaces will have to be my option then.

I received this request from a client of ours and he (not being too IT literate) specifically asked for...

hmmm I have been getting that response from most people - that it can't be done.

I am definitely talking about fixed-width: as in all the columns must be of equal...

Thanks for all your replies - appreciate it!!

I have used the following statement:

exec sp_msforeachdb 'select ''?'', filename from ?..sysfiles'

it lists all my DBs and the individual mdf and ldf file per DB, and the extra mdf and...

free_mascot: how would I check that?

I have used that SP and it has confirmed the 2 locations:

D:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\DBName.mdf

D:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\DBName_Log.ldf

This will seem like a stupid question, but is it possible that those other MDF...

Ok there was a Shrink DB option in the Maintenance plan that executed every night at 12:00

I have disabled that.

I will keep an eye on it - see if this...