I am using Microsoft SQL Server 2008 Management Studio Express to develop a database application with the development database on sqlserver express database on my dektop computer. The database has now been copied and attached to the test server which runs SQL server 2008 R2. However i am not able to connect to the SQL server using Microsoft SQL Server 2008 Management Studio Express. I am able to access and manage the database on the server via Remote desktop so my user rights seems to be ok. My question is: Is the functionality of the "Microsoft SQL Server 2008 Management Studio Express" restricted in a manner such that it can only be used to connect to the "localhost" SQL server express on my desktop?
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed