Dump the SQL from the job, it should allow to 'View T-SQL'. It'll give you more info, we can then start down the sys.databases path.

Thanks Steve, that makes sense.

So next newb question: has someone done this with Powershell/VBScript?

Try putting brackets around the database name:

select name from [QA_WSS_Search_NSAB-SS82-SPF-N].dbo.sysfiles;

go

SQL no likey the dash, probably sees it as a minus sign.

Congrats on the new position, I found myself in similar circumstances. I went thru this book:

http://www.microsoft.com/learning/en/us/book.aspx?ID=9364&locale=en-us

and was able to pass the test on the first try. ...

johnyjj,

Here's a link to get SSMS express installed:

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

I'm not sure with the Express edition, but with full installs, if you don't choose to install the "tools, documentation" option,...

I know this is an old post, but I'm having the same problem. Based on research I've already changed:

allow updates to 0

CPU and I/O affinity set to Automatic

Seems others...

Thanks so much Gail. Do you think my database was backed up properly?

I guess I shouldn't have asked the question, as it isn't pertinent to the issue. I'm trying to find out why my user is 'broken' now, will post back...

Thanks Alvin. But shouldn't the 'Local System' account have enough privileges to run the job?

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

I changed the job owner to 'sa' (from my domain account) and it...

I found that the email account that I was using to try and send email was not configured properly. Found this out by talking to my email admin. ...

Could be a bug:

http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/6f143ca9-d08c-4028-9fef-58ae62ae5fc6

I'm going to follow up with Microsoft.

Thanks Jeff. But as I stated, that area was changed to email me and I've yet to see any email. Also, when I look at the properties of...

Found an answer for question number 2:

https://metalink2.oracle.com/metalink/plsql/f?p=130:14:2551972738979005909::::p14_database_id,p14_docid,p14_show_header,p14_show_help,p14_black_frame,p14_font:NOT,466228.1,1,0,1,helvetica

Thanks for the input, Lynn. It doesn't appear to be a problem to mismatch those column definitions, based on some tests I did, though:

create table test_n_id2

(

n_idvarchar(20)

)

----------------------------

insert into test_n_id2

select

national_id

from...