Search my blog
-
-
Recent Posts
- Reading list for the week – 24/10/11
- Reading list for the week – 17/10/11
- Reading list for the week – 10/10/11
- Reading list for the week – 03/10/11
- Reading list for the week – 26/09/11
- MSP Error: 29528 The setup has encountered an unexpected error while Setting reporting service exclusion path
- Reading list for the week – 19/09/11
Page Views
208,411-
Popular Posts
- How the Cannot generate SSPI context error was fixed
- Find the SQL Server Instance name using Task Manager
- Server is in script upgrade mode. Only administrator can connect at this time
- Script to check database user permissions
- Cannot create an instance of OLE DB provider ‘OraOLEDB.Oracle’ for linked server
Archives
Tags
backup configure data corruption data file hardware hotfix index internals locks maintenance plan performance PradeepAdiga restore RLFTW scripts security services setup sql 2000 sql 2005 sql 2008 sql 2012 sql agent ssis system databases tips and tricks tools Top Posts trace transaction log troubleshoot windows
Category Archives: scripts
Generate script for objects along with data using Microsoft SQL Server Database Publishing Wizard
Last week, we had a request from the Application Team to generate the DDL script for all objects on a Production database. Since the number of objects on that database was quite high (more than 100,000), the Generate Script wizard … Continue reading
Clean up Maintenance Plan History
Sometime back I had responded to a question where the user wanted to know the methods to cleanup the Maintenance Plan history. It is common for the DBA to come across a situation where the Maintenance Plan history grows large … Continue reading
Posted in maintenance plan, scripts, SQLServerPedia Syndication
Tagged maintenance plan, scripts, tips and tricks
1 Comment
RSS
Email
Twitter
Ovi App
LinkedIn
FourSquare