Check this thread - there's several scripts posted: http://www.sqlservercentral.com/Forums/Topic432483-146-1.aspx

Seems strange. I have a nearly identical setup, but it works for me (using a SQL Server authentication rather than Windows authentication).

The login should not need any...

Some earlier Gb cards didn't have the option to set Gb speed/duplex directly, you had to set it to auto-neg. Not sure if that can be fixed by an...

Another alternative is to run this:

exec sp_msforeachdb 'exec sp_helpdb ?'

You could add some logic utilising IF DATABASEPROPERTYEX([dbname], 'Status') = 'ONLINE'...

DBF? Sounds like another product's equivalent of an MDF or MDB, which you can't import directly to the best of my knowledge - you need to have that database...

Are your NICs set to auto-negotiate or set to a fixed speed/duplex? I've had problems with auto-negotiate in the past.

The target size in DBCC SHRINKFILE is actually in megabytes, so what is given above (5120) will actually give you a 5GB file size.

What profiles have you configured for Database Mail? What profiles are public? What profile are you specifying in the sp call?

Sorry, don't have an answer for that one. I'm not sure if SQL Server uses the views that DBCC updates or hits the tables themselves when it comes time...

If you know the rough per-day growth rate, multiply it by the number of days you expect the database to be around for and set the database size to that...

What you're missing is that you need to be fiddling with DATABASE roles, not SERVER roles. Access to tables, stored procedures etc is governed by the database roles within...

I haven't come across any. Last time I had to do that sort of thing I wrote a VBS script to handle it (delete files older than x). ...

Explain how a differential backup works. I had that one in my last interview.

What happens if you try running:

master..xp_cmdshell 'D:\JPMorgan_IMPORT\pdfcombine.exe D:\431411406.PDF D:\431411408.PDF D:\COMBINED.PDF'

Are any error messages returned? Or is it just the never helpful 'NULL'