Viewing 15 posts - 736 through 750 (of 6,105 total)
Is the problem present if the user completely disconnects from SQL Server and reconnects?
January 22, 2009 at 12:42 pm
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...
January 22, 2009 at 12:39 pm
Jack Corbett (1/22/2009)
All of the above issues are why I believe any encryption should be done in the business layer, not the database.
If I'm a system administrator, I still have...
January 22, 2009 at 10:53 am
A second vote for SQLPing. Let a domain admin run it for best results. Very useful discovery and auditing tool.
January 22, 2009 at 7:14 am
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...
January 22, 2009 at 7:11 am
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...
January 22, 2009 at 6:31 am
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 ...
January 21, 2009 at 7:57 pm
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...
January 21, 2009 at 8:28 am
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...
January 21, 2009 at 8:24 am
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...
January 19, 2009 at 6:20 pm
Jeff Moden (1/19/2009)
Jack Corbett (1/19/2009)
Here's a good blog post about people just implementing solutions form the internet or forums without caring why:http://www.straightpathsql.com/blog/2009/1/18/empirical-evidence.html
I found this on a tweet by Jonathan Kehayias.
How...
January 19, 2009 at 3:57 pm
GilaMonster (1/19/2009)
Jack Corbett (1/19/2009)
That's probably my favorite feature of the google toolbar, spell checking just like in Word.
Firefox has that built in. Why do you think I make so few...
January 19, 2009 at 3:51 pm
TRACEY (1/19/2009)
How do i PM you ...thanks
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...
January 19, 2009 at 10:41 am
TRACEY (1/19/2009)
Now from what im reading this is what i got to go check with AD people,
set the SQLServer account and the...
January 19, 2009 at 10:40 am
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...
January 19, 2009 at 9:18 am
Viewing 15 posts - 736 through 750 (of 6,105 total)