Categories
Dynamics NAV Microsoft Windows 7 Windows 8 / 8.1 Windows Server 2008 Windows Server 2012 Windows Vista Windows XP

Shortcut Ctrl+Alt+F1 does not work

If the shortcut Ctrl+Alt+F1 does not work the problem is not linked with the application that you are using but maybe with the computer that you are using, I noticed that is a problem in Dell machines.

Shortcut Ctrl+Alt+F1 does not work

Solution:

Use Ctrl+Alt+WinKey+F1

NOTE (by Daniele Rebussi): This solution applies also when NAV is used via Citrix/VMWare visualization environments, where Ctrl+Alt+F1 combination covers other functionality.

Did my solution solve your problem? Leave a reply.

Categories
Dynamics NAV HOW TO Microsoft SQL Server

HOW TO take offline a database in SQL Server

HOW TO take offline a database in SQL Server?

Microsoft Sql Server Management Studio

Right click on the database node > Tasks > Take Offline

T-SQL Script

Execute the following query
[sourcecode lang=”sql”]
ALTER DATABASE [DatabaseName] SET OFFLINE WITH
ROLLBACK IMMEDIATE
GO
[/sourcecode]

If it seems that the command doesn’t work or the execution requires more time or to force to take offline or

if you’ll receive the following error:
ALTER DATABASE failed because a lock could not be placed on database ‘{DatabaseName}’. Try again later.

click on the following link to show the Solution:
ALTER DATABASE failed because a lock could not be placed on database

Did my HOW TO help you? Leave a reply.