Tag Archives: Limitation

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

Error: ACCESS DENIED on installation

Error: ACCESS DENIED on installation Generally you would get error on: >> During installation >> when try to start the sql services. >> After installation when try to access instance. You would get “ACCESS DENIED” error. To resolve this issue, … Continue reading

Posted in Error Log, Installation, Troubleshooting | Tagged , , | Leave a comment

Denali – Day 4: Editions & Licensing

Denali – Day 4: Editions & Licensing Editions: Here is a brief edition summary of Editions available for all sql server from 2005 to 2012. Sql Server 2005 Sql Server 2008 Sql Server 2008 R2 Sql Server 2012       … Continue reading

Posted in Denali, Whats New | 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

spid in Killed/Rollback cannot kill – external

We come across a situation where we have to kill one spid which was running for quite some time, so we though killing will help us, but after killing found that that spid is not killed but stuck in our … Continue reading

Posted in Add/remove, Lock/Blocking, Others | 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