Viewing 15 posts - 15,091 through 15,105 (of 39,901 total)
Lots of ways to do this. It's essentially auditing the user's actions.
Search for auditing, read about different solutions. You have trace, xEvents, triggers, SQL Server Audit, and more.
October 3, 2011 at 12:19 pm
SQL Kiwi (10/3/2011)
Spot the Difference Competition:SSC article http://www.sqlservercentral.com/articles/delete/61387/
EMC consulting blog entry http://consultingblogs.emc.com/sujeethkonagalla/archive/2011/09/29/the-difference-between-truncate-and-delete.aspx
?
Reported to EMC
Tx
October 3, 2011 at 12:04 pm
It seems there are any number of tools to replicate data from ADABAS to relational databases. If you need a cross platform tool, I'd suggest you start evaluating the various...
October 3, 2011 at 9:34 am
Congrats, Jack. Hope to see you soon and shake your hand.
October 3, 2011 at 9:23 am
Matthew Joughin (9/29/2011)
October 3, 2011 at 7:55 am
Software assurance has no effect on your install. It's strictly an administrative item, not a technical one. Meaning the install doesn't know if software assurance was purchased.
October 3, 2011 at 7:50 am
The only decent week I've had. Big Ben and Shawn Greene are killing me.
October 3, 2011 at 7:44 am
You can close some connections and those objects will drop their tempdb space. Or cancel the transactions.
You could try adding 5MB to the existing file and then grow on...
September 28, 2011 at 9:58 am
Clustering works with shared storage. When the passive node picks up, it picks up the storage that was being used by the active node. Some SAN technologies or geo-clusters play...
September 28, 2011 at 9:52 am
Yes, here's some powershell code that does that and runs a backup of there's an alert. however the comments describe essentially what you're doing: http://www.simple-talk.com/sql/backup-and-recovery/alert-based-transaction-log-backups---automate-your-database-maintenance-part-2/
September 28, 2011 at 9:50 am
Brandie Tarvin (9/28/2011)
Do not tempt me. I have done things like this before. @=)
Speaking of writing, follow this link if you like high fantasy and want to read a story...
September 28, 2011 at 9:26 am
Once the iSCSI disks are attached, the procedures for both of these are available in books online or on the web. I would suggest searching for them.
September 28, 2011 at 7:20 am
You'll need to grow tempdb to gain a little space for the growth operation.
You can restart SQL Server as well to clear the tempdb db and recreate it.
September 28, 2011 at 7:19 am
Easiest way is to backup and restore as a new database (new name), delete the data in each database you don't need.
If you do this regularly, you need to build...
September 28, 2011 at 7:16 am
Brandie Tarvin (9/28/2011)
SQL Kiwi (9/28/2011)
WayneS (9/27/2011)
• ...
September 28, 2011 at 7:08 am
Viewing 15 posts - 15,091 through 15,105 (of 39,901 total)