CirquedeSQLeil (4/18/2011)

---

Craig Farrell (4/18/2011)

---

For anyone here who regularly works on the web app/public and private content coding side of things, if you wouldn't mind taking a breeze by this post,...

Gotcha...so that link I provided should help. You'll need to run the commands per user, per database.

Unfortunately, this doesn't help with any role membership on the instance. If...

A little more information would help, but I think what you're looking for is this:

sp_change_users_login

It's deprecated, but useful. That link is to Books Online, it shows examples but says...

Interesting, mine's in the upper right corner. I was actually impressed when I accidently hovered over it and it popped open.

I'm using Chrome also.

Craig Farrell (4/12/2011)

---

CirquedeSQLeil (4/12/2011)

---

Craig Farrell (4/12/2011)

---

WayneS (4/12/2011)

---

Jack Corbett (4/12/2011)

---

I'm sure y'all already know, but today is the last day of $299 price for SQLRally. Goes up to $349 tomorrow...

The Giants are right about where I figured they'd be, although the rest of Giants land thinks since they won last year it should be a lock for this year....

Mary Tyler Moore in the "The Dick Van Dyke Show" was HOT! Not as much later in her career though.

You could also try and run 'sqlcmd' from a DOS prompt. IIRC, that executable only gets installed with the tools option.

Jason is the true saint, I punted yesterday =p

Aye, we're doing our best =)

Here's a couple of links that may help:

http://support.microsoft.com/kb/955813

http://msdn.microsoft.com/en-us/library/ms143504(SQL.100).aspx

I just double checked my servers, in the local Windows groups there are the groups that I was used to seeing from the...

Let's try and approach this from a different perspective: is there a specific problem related to the agent in the 'sysadmin' role that you're trying to solve?

If...

There's an option to install more than the 'Database Engine'. If I recall correctly, it's a checkbox for "Tools, Workstation and Documentation" (or something similar to this).

For SQL Server 2008 there will be a group under 'Logins' called 'NT SERVICE\SQLSERVERAGENT'. I haven't figured out how to view that group on the Windows box yet (it's...

Sunny and 70 in California! (just to rub it in =p)

Too bad the Giants weren't so hot.