Is the problem present if the user completely disconnects from SQL Server and reconnects?

I won't disagree with the encryption tools. It's not exactly easy to get encryption working in SQL Server.

SQL Server supports TLS. Has since the SQL 2000 days. Also, IPSEC can...

If I'm a system administrator, I still have...

A second vote for SQLPing. Let a domain admin run it for best results. Very useful discovery and auditing tool.

Yup, and I've done just that in troubleshooting a poorly performing 3rd party app which we didn't know the password for. The bottom line is all this points to an...

And I drop back to the point that even if you could block the Profiler trace, you could not block someone with local Administrator membership from using a debugger and...

The column accdate is the created date, not the last time the account was accessed. You can see this by doing an sp_helptext of syslogins:

CREATE VIEW sys.syslogins AS SELECT ...

Even db_ddladmin is overkill.

Grant CREATE PROC to a role. Put developers in that role.

Grant ALTER SCHEMA on the schema(s) that the developers need to modify stored procedures in to the...

There are certain key words which SQL Server will key in on and block the output, however, the Profiler in SQL Server 2008 is smart enough to recognize whether these...

Jeff Moden (1/19/2009)

---

Jack Corbett (1/19/2009)

---

Of course when the typo is still a word you need an editor. My original post "form" instead of "from".

My classic typo that...

Jeff Moden (1/19/2009)

---

How...

GilaMonster (1/19/2009)

---

Firefox has that built in. Why do you think I make so few...

Click on my name to the left of the forum and post and you should see a pop-up menu which has an option to...

TRACEY (1/19/2009)

---

Ok i got the links up from kendal.

Now from what im reading this is what i got to go check with AD people,

set the SQLServer account and the...

I don't see anything that stands out as causing the view definition right to be needed. All of these have the tbl prefix, so I'm assuming all are tables and...