Thanks my first step is picking upi the file using the FTP task thats my issue the name changes monthly.

Then I have a few steps importing into the db...

Yes thanks we have that one, but our boos was looking for a second tool.

Thank you

not this only the others

max_logical_reads

I couldnt figured out how to edit my post

Im trying to get them into minutes

Here is a good post I used last month we are VLF issue with over 1000

http://www.sqlskills.com/blogs/kimberly/post/8-Steps-to-better-Transaction-Log-throughput.aspx

Thanks

This will be my first time retoring a master db as I have restored many just not the master, are there steps for this as I have tried and keeps...

I tried to run this on the server in question

GRANT SELECT on spt_values TO public

but recieved an error

Msg 15151, Level 16, State 1, Line 1

Cannot find the object 'spt_values',...

Im trying to add a row to this view [INFORMATION_SCHEMA].[TABLE_PRIVILEGES]

Thats where Im getting the error ists in the master system Views

we are missing this row

dbopublicmasterdbospt_valuesSELECTNO

Thanks

no its missing the values in the system views in the master database, I have been trying to add these manually but I can not gettin this error Ad hov...

I figured out the issue here Im missing a row in

[master].[INFORMATION_SCHEMA].[TABLE_PRIVILEGES]

GRANTOR GRANTEE TABLE_CATALOG TABLE_SCHEMA TABLE_NAME PRIVILEGE_TYPE IS_GRANTABLE

dbo ...

Thanks, I found that and tried running the u scripts I get the error doesnt exist or does not have permissions. We have SA rights I cant find that table...

I verified the the permissions and we are SA also I looked at teh tables from the one database and the one having the issues and cant see any difference...

Quick question on those flags, I noticed that both are turned on. Turning off the 1204 and leaving shouldnt hurt anything correct?

Thank you

Thanks, I have been working on this still. I have figured out that I need to change the data type to nvarchar then update all the values that had NaN...