If you delete default database of user, users of default database can not connect to database. You have to connect with sqlcmd on master database. After you have to change default database of user. Error Cannot open user default database. Login failed. Solution Open CMD prompt C:\>sqlcmd -E -d master 1> alter login [domain\LoginUser] with…
Tag: MsSQL Server
Create Linked Server for Oracle in SQL Server 2008 R2
If you want to fetch data from Oracle to SQL Server, you can use Linked Servers features in SQL Server Database. Linked Server is like a database link (Dblink). Installation steps Install Oracle Client on SQL Server database server Restart SQL Server database service Configure OraOLEDB.Oracle provider in SQL Server database Create user for remote…
MsSQL Server Recovery Models Features
SQL Server backup and restore operations occur within the context of the recovery model of the database. Recovery models are designed to control transaction log maintenance. A recovery model is a database property that controls how transactions are logged, whether the transaction log requires (and allows) backing up, and what kinds of restore operations are…
How to Install .Net Framework 3.5 on Windows Server 2012
You have to insert Windows Server 2012 DVD into DVD Reader. After you can install .Net FrameWork 3.5. Installation Steps insert Windows Server 2012 DVD or iso to D Drive. Open Add Roles and Features Wizard From Server Manager. Select .NET Framework 3.5 Features. Select Specify an alternate source path and select path that is…
Create Schedule Job For Execute Procedure in SQL Server 2008
If you want to run procedure or any query as scheduling, you can use job in SQL Server Database. For this process, you can use below operations. Right Click On SQL Server Agent > New > Job
SQL Server 2012 Top 12 Features
Microsoft has introduced SQL Server 2012 to the world and it’s time for IT professionals to start to come to speed on what’s new in this highly anticipated version of SQL Server. 1. AlwaysOn Availability Groups — This feature takes database mirroring to a whole new level. With AlwaysOn, users will be able to fail…