How to output datafiles location using sp_helpdb?
This is a quick way of outputting the location of your database files/dbsize/date created on your instance.
2010-07-02 (first published: 2010-06-06)
1,307 reads
sp_helpdb
2009-04-28
2,347 reads
RE: poor Question of the day 7_13_2003
quote: - In normal conversation, we don't talk about what rights the guest user has in master and msdb and tempdb when we're talking about what rights a particular login has ... Therefore, this login that I'm using has no explicit rights assigned to it. Again, it's really all wrapped up in the semantics. But […]
2003-07-14
RE: Special characters
quote: Ok, maybe I missed something all this time but I have never had a special character bother other than ' as long as wrapped in single quotes 'nnnnnn'. So what is everyone running into that I have yet to hit? there are some more characters to watch. Look at this one: http://www.nextgenss.com/papers/advanced_sql_injection.pdf I've just […]
2003-06-17
Blogs
Back to Boston for SQL Saturday
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
The Future of the Social Web Is in Good Hands
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers