MSSQLTips

I am facing a problem in MSSQL: - I have a table in MSSQL, which has 10 rows & 5 columns. In this table I am maintaining a numeric range in 2 columns. First one has starting number & second column has end number. All rows have unique values in these 2 columns. For Ex.: - In first row the value...

What is difference between Update Stat and DBCC DBREINDEX .......... after doing dbcc dbreindex database size become smaller

I am having doubt - is it achivable Or not? The senario is , "If the outer transaction is rolled back, then all inner transactions are also rolled back" is it any way to avoid Rollbacking of inner transactions?? Thanks, srinivasan r

Hi, I’m looking for a table ore stored procedure which gives me al the information about the Maintenance Plans on a SQL Server. For example Backup Folder, witch databases are selected and so. I did find a quite a lot store Procedures and some views whit information about Maintenance Plans and Jobs, bud...

Good day all. I have about 25 SQL boxes that are 2000 and 2005. I have all the maintenance plans running successfully nightly now. What I would like to accomplish is to have all the history reports go to one location and email a report on the failed jobs. SQL 2005 doesn't have the option to add a...