| | |
| Connection String Information |
2/27/2008
1705 views | For connection string information to be entered into External.Config see the following link: http://connectionstrings.com/?carrier=sqlserver |
| Installing a new SQL 2008 Standard Junxure instance |
8/6/2009
1695 views | Use:When performing a server move or upgrade from 2005 you may be asked to install a New instance of 2008 when the users have purchased a full version of 2008 Have the client put the 2008 disk in the Server and make sure that they have the Product Key if needed In the case of an upgrade from 2000 or 2005, you should first get everyone out of Junxure, run a |
| Restore a Database Using SQL Server Management Studio |
9/19/2008
1415 views | This following link is from the Server TechCenter and will provide you instructions on how to restore a DB backup in Server Management Studio http://technet.microsoft.com/en-us/library/ms177429.aspx |
| SQL Server Connection Issues |
6/2/2008
1363 views | This article list useful troubleshooting links for Server connection problems. Summary Link Server 2005 and issues that can occur with Windows 2003 SP1 http://blogs.msdn.com/sqlprogrammability/archive/2008/05/27/sql-server-interm |
| Tips for SQL Server Database Maintenance |
7/11/2008
1336 views | The following link is a Technet article that may be of interest to DB Admins http://technet.microsoft.com/en-us/magazine/cc671165.aspx |
| SQL Server 2005 Features Comparison |
7/3/2008
1185 views | This link will give you comparisons of EXPRESS, WORKGROUP, STANDARD, and ENTERPRISE versions of 2005 http://www.micro |
| SQL Server 2005 not sorting views in the proper order. |
2/19/2008
1098 views | You have a view in a database in Server 2005. In the definition of the view, the SELECT statement meets the following requirements: • The SELECT statement uses the TOP (100) PERCENT expression. • The SELECT statement uses the ORDER BY clause. When you query through the view, the result is returned in random order.However, this behavior is different in Microsoft Server 2000. In Server 2000, the resu |