Dynamic SQL can be a necessary evil in certain cases but it sounds like in this case the chimps didn't know how to write good code so they just "built"...

Duh. My bad. You specifically said "error logs".

Because this is a web app front end I'm thinking you have a generic user account that [everything] webby uses. ...

Re: Log files

You mean the SQL ERRORLOG or were you using Profiler?

I'm glad things are going well. You certainly have a promising future as a DBA if you decide to pursue it.

I haven't reviewed DHeath's suggestion (re: Ola Hallengren Maintenance...

OutSTANDing! You rock.

Weekly full and nightly differentials are part of a perfectly acceptable way of recovering user databases. Keep in mind that: a.) the differentials store [cumulative] changes...

Fly Girl

RE: server specs.

Unfortunately - as the folks here will agree - sometimes being a DBA is playing the hand you're dealt. Getting additional resources to beef up the...

I'd been "technical" for lots of years and finally decided to take the plunge into management. In hindsight, it probably [was] the internal culture of the company but at...

I'm 95% certain I would use a phone/PDA to administer my servers. More often than not the "after hours crisis" isn't something that would force me to bang out...

I came across this code on http://myitforum.com/cs2/blogs/jnelson/archive/2008/08/16/121273.aspx. Maybe it'll help...

BTW: The page also has a companion REVOKE statement builder query

SELECT

OBJECT_NAME(major_id) ...

I don't want to be a buzzkill but it looks like the alias is broken. I have a 2005 db with an login aliased to dbo that showed up...

Nice work. I was tangled up in refining the sys.database_principals/sys.sysusers query but rather than streamline, the query ended up getting larger... <lol, sigh>. I'll tinker with this some...

Sweet! I didn't have a lot of time today but I figured if I got something going, maybe someone else (such as yourself) would chip in. Outstanding additions,...

I honked around with this for a little bit between meetings. There might be a more graceful way to do this and I didn't test it a heck of...

<LOL>

Thanks, Cath. That's what came to mind for me as well when I first read his post but it seemed he had his heart set on using SQLCMD. ...

Click the Start button.

Navigate to Programs/Accessories

Right-click on Command Prompt

Click "Run as..."

Click "The following user:" radio button

Type the AD user name and password and click the OK button

In the Command Prompt...