This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
SQL Server 2005 connection window.

SQL SERVER – Clear Drop Down List of Recent Connection From SQL Server Management Studio

November 5, 2008
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, DBA, SQL Scripts, Vista

Is the SSMS connect drop down list full of old server names? Delete the mru.dat file for SQL Server 2005 or 2008 to clear it and start fresh.

Read More
SQL SERVER - Create Database Error in Windows Vista

SQL SERVER – Create Database Error in Windows Vista

May 7, 2008
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Utility, Vista

A reader on Vista got a create database error, Msg 262 CREATE DATABASE permission denied in database master. The fix is the same one from my earlier post.

Read More
SQL Server Management Studio - Logins.

SQL SERVER 2005 – FIX Error: 18456 : VISTA Windows Authentication

May 6, 2008
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server Security, Vista

My Vista Windows Authentication login failed with Error 18456 after installing SQL Server 2005, while sa worked. Adding my login as administrator fixed it.

Read More
SQLAuthority News - Fix : Remote Desktop Copy Paste Stop Working

SQLAuthority News – Fix : Remote Desktop Copy Paste Stop Working

January 22, 2008
Pinal Dave
SQLAuthority News
Database, DBA, SQL Error Messages, Vista

My Remote Desktop copy paste stopped working both ways while I worked on a remote SQL Server. Restarting did not help, but the fix at the end of the post did.

Read More
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com