Category Archives: Limitation

SQL Server 2005 – Failed Maintenance Job

I Know SQL Server 2005 is no longer in support by Microsoft, but Want to provide a solution for those who have legacy system and come across a issue where maintenance job failed in jobs and on maintenance plan history … Continue reading

Posted in Bug, Error Log, Limitation, Others, Troubleshooting, What I learned today | Tagged , , | Leave a comment

SQL 2016-Always Encrypted

As you know this has been introduced in sql server 2016, I am not going in details on it but would like to highlights some points which I learned today: YOU WILL NEVER GET/READ THE REAL DATA FROM “SQL SERVER … Continue reading

Posted in Limitation, sql 2016, What I learned today, Whats New | Tagged , , , | Leave a comment

Always use Configuration Manager for changing service account

When your service account is expired/disabled or is not having access than sql service could not able to start and you may get an error an en eventvwr as “Could not open error log file ‘C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG’. Operating system error … Continue reading

Posted in Basic, Error Log, Limitation | Tagged , | Leave a comment

More IMPORTANT miscellaneous info

This is a first blog for this month, yes I was busy with Powershell quiz and some other personal stuff. Okay, continue with Miscellaneous Info here is some more important stuff/ information about sql server. >>Ghost cleanup task runs every 5minuts … Continue reading

Posted in Basic, Experts, Limitation, Others | Tagged , | Leave a comment

Error 0xC0014062: Unable to complete login process due to delay in opening server connection

Sometimes on a heavy loaded server(many databases/connection). You may get an error log when your backup maintenance plan job gets fails with the following error Message: Executed as user: xxx\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 10.0.5500.0 for 64-bit  … Continue reading

Posted in Bug, Limitation | Tagged , , | Leave a comment

Command Prompt connectivity –U option

When you try to connect to sql server using isql/osql or sqlcmd there are two authentication you can use windows authentication and sql authentication. -E option is used for windows authentication where you domain windows login which you have connected … Continue reading

Posted in Basic, Limitation | Tagged , , | Leave a comment

Desktop Edition Sql server 2000 MSDE Install upgrade

for sql server 2000 (I know its old) desktop edition does not includes any GUI. so installation of desktop edition ie MSDE is via command prompt. you can install the setup for desktop edition for free from here. http://www.microsoft.com/download/en/details.aspx?id=22661 to … Continue reading

Posted in Add/remove, Installation, Limitation, Troubleshooting | Tagged , , | Leave a comment

Resource database

Today learned new thing about Resource database, as everybody knows resource database is the system database introduced in sql server 2005, this database is hidden and user cannot see and access it directly, all the sys. schema (system objects) are … Continue reading

Posted in Computers and Internet, General, Limitation, What I learned today | Tagged , | Leave a comment

Schedule the backup job in Express Edition

Schedule the backup job in Express Edition: Everyone knows that, you cannot schedule a job in Express edition, as Express edition does not have Sql Agent. Today found very interesting information, you can schedule the backup job or any sql … Continue reading

Posted in Backup and Restore, General, Limitation, What I learned today | Tagged | Leave a comment