Linked Questions

Ask Question
48 questions linked to/from What event information can I get by default from SQL Server?
Hot Newest Score Active Unanswered
5 votes
2 answers
662 views

I am aware of the disadvantages of AUTO_SHRINK being configured on SQL Server databases. Recently, in a new environment, I discovered several production servers with the Auto Shrink option turned on. ...
Magier's user avatar
  • 4,847
0 votes
1 answer
610 views

I am in for a requirement where I need to use EE to capture the Objects Accessed by a particular SQL User. I want to avoid the action sqlserver.sql_text, if I use this, I will need to manually scan ...
Moh's user avatar
  • 11
14 votes
4 answers
37k views

I know I can cycle the current error log easily by running sp_cycle_errorlog, but I'm wondering if SQL Server will ever delete the old/archived error log files at all. Can't seem to find an answer to ...
tuseau's user avatar
  • 1,905
30 votes
4 answers
59k views

Before immediately marking as duplicate, I have read Mike Walsh's Why Does the Transaction Log Keep Growing or Run Out of Space?, but I don't think it gave an answer to my situation. I looked through ...
DerekCate's user avatar
  • 438
11 votes
3 answers
31k views

I am trying to find a way to figure out when was couple of my sql databases were taken offline. I checked the the logs but could not find any such info and moreover there is no default trace enabled. ...
KASQLDBA's user avatar
  • 7,213
6 votes
2 answers
2k views

I need to confirm if a particular table ever existed in our SQL Server. Is there an existing script or method one can use to list all dropped databases in an SQL Server instance?
Brian Mogambi's user avatar
  • 63
9 votes
3 answers
11k views

Is there a way to list who created certain procure in SQL Server 2008? In this SO link there are some answers but from 6yrs ago. I know it's a best pratice to write your name and date, and then ...
Racer SQL's user avatar
  • 7,558
5 votes
1 answer
45k views

I have a Microsoft SQL Server 2008r2 SP1. I need to know which users connect to, and disconnect from, database. Ideally, I would like a list of (datetime, username, connect/disconnect). Can this be ...
carlo.borreo's user avatar
  • 1,497
8 votes
2 answers
8k views

Is there any way of seeing details of sessions from the past (I fully expect the answer to be "no"). I am trying to find out what server a certain application is running on, that application accessing ...
Spratty's user avatar
  • 203
3 votes
2 answers
4k views

I am trying to find the cause which have bloated the mdf of a database from 20 GB to 100 GB. So far i tried checking the autogrow events to find time, but could not find none using standard reports ...
BeginnerDBA's user avatar
  • 2,230
1 vote
1 answer
14k views

The boss has asked for a list of DB names along with size and name of last person to use that DB. I've found resources for when a DB was last accessed but for by whom. How would I solve this? ...
Paul's user avatar
  • 1,453
4 votes
2 answers
2k views

A coworker who worked on restoring a backup changed the database owner from his name to 'sa' (rightly so) last night. While I had seen the his name in a SQL Server Management Studio window, I did not ...
VK_217's user avatar
  • 151
1 vote
1 answer
7k views

In a production server (Microsoft SQL Server 2014), the file MSDBData.mdf ballooned up to more than 450 GB, eating almost all the space in the server (only 38 GB remaining). First thing, I created ...
sylletka's user avatar
  • 13
1 vote
2 answers
4k views

The TLOG in my SQL Server 2008 is growing faster than usual. The DB has a Full recovery model and we have a TLOG backup every hour. Can you please write me or refer me to link that describes a way to ...
Roni Vered's user avatar
  • 585
1 vote
1 answer
2k views

I have a column that is out of order (ordinally, not in terms of select statement), and I just can't figure out how it got that way. I've been researching this for quite some time and am coming up ...
Joe Hayes's user avatar
  • 335

15 30 50 per page
1
2 3 4