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
Monthly Archives: August 2010
Change ‘Edit Top 200 rows’ setting in SSMS 2008
SQL Server Management Studio (SSMS) is a good feature rich tool. While many choose to do data manipulation using T-SQL queries, there are a lot of users who make use of SSMS for manipulating data. Until SQL Server 2008, right … Continue reading
Drop and re-create System Stored Procedures in SQL Server 2000
Today in one of the SQL communities, I came across a question. The scenario was something like this. One of the audit report stated that someone had dropped an re-created a System Stored Procedure on an instance running SQL Server … Continue reading
Posted in SQLServerPedia Syndication, Troubleshoot
Tagged configure, scripts, sql 2000, tips and tricks
2 Comments
RSS
Email
Twitter
Ovi App
LinkedIn
FourSquare