Restore SQL Server 2008 database backup error specified cast is not valid
Received a SQL Serer 2008 database backup newdatabase.bak from a site in UK and attempted to restore it onto my server in USA. Receive error . I assume this is a Server Collation difference issue. Can anyone help me overcome this so that I may be able to restore this backup on my SQL Server [...]

Answer Question   |  July 20, 2012  5:37 PM
Server configuration, SQL Server 2008 administration

SQL Server 2008 Upgrade
I have 7 SQL Servers I need to upgrade from SQL Server 2005 to SQL Server 2008. Can I install the SQL Server 2008 prerequisites using Microsoft System Center? If yes how?

Answer Question   |  February 1, 2011  8:10 PM
SQL 2008, SQL Server 2005 upgrades, SQL Server 2008, SQL Server 2008 administration, SQL Server upgrades

SQL Server Express 2008 w/Tools vs. Advanced
Hi, I installed SQL Server Express 2008 w/Tools on my Windows 7 OS. I just found out that if I want to download the AdventureWorks database .msi from codeplex, I need SQL Server Express 2008 w/Advanced Services. Do I need to uninstall the SQL Server Express 2008 w/Tools and install SQL Server Express 2008 w/Advanced [...]

Answer Question   |  October 4, 2010  3:18 PM
.MSI files, AdventureWorks, SQL Server 2008, SQL Server 2008 administration, SQL Server Express, Windows 7

Help navigating SQL Server 2008 database?
Hi all, I’m facing an interesting challenge… Lets say: I have a payment coming in and of course my client has not specified which of the 45 open invoices he is paying. The amount does not match any single invoice so it has to be a combined payment for 2 or more invoices. Now, I [...]

Answer Question   |  August 31, 2010  8:44 AM
SQL Server 2008, SQL Server 2008 administration, SQL Server database, SQL Server tables, VB.NET

How to add two timings in SQL Server 2008
DECLARE @TIME1 VARCHAR(10),@DURATION VARCHAR(10) SET @TIME1=’10:00′ SET @DURATION=’00:25′ SELECT CONVERT(TIME(0),@TIME1)+CONVERT(TIME(0),@DURATION) I need to add two timings …suppose if the @time1 is ’10:00′ and the duration is ’15′ mns then it should show 10:15 … Any help highly appreciatable…

Answer Question   |  May 18, 2012  7:59 AM
SQL Server, SQL Server 2008, SQL Server 2008 administration, T-SQL

Best way to back up SQL Server 2008 database?
What’s the best way to back up my SQL Server 2008 database? We are currently backing up the SQL data files during off hours but soon we’ll be going 24/7 and we’ll need to use maintenance plans and shadow copy. Can someone provide help?

Answer Question   |  July 16, 2010  7:50 PM
Shadow Copy, SQL Server 2008, SQL Server 2008 administration, Sql Server 2008 Backup, SQL Server database

SQL Server 2008 Code to find fields containing similar text
I want to find fields that may be the same in some parts but not 100% identical For example Field 1 Has the word “Smith” Field 2 has “Smith AB” in it Is there any code i can write to find these, without writing code for every single name I am using SQL server 2008 [...]

Answer Question   |  July 14, 2010  3:37 PM
SQL commands, SQL Fields, SQL Server 2008 administration, SQL Server development

OLTP in SQL Server 2008
While using OLTP in Micrsoft SQL 2008 enterprise edition, does the row level locking happens or table level locking happens?

Answer Question   |  April 21, 2010  4:45 AM
OLTP in SQL, SQL Server 2008, SQL Server 2008 administration

Microsoft Live Chat: Introducing Microsoft SQL Server 2008 R2 on 4/22 11am ET
Join us on April 22nd at 11am ET to hear how SQL Server 2008 R2 can provide your IT environment with an end-to-end approach that increases efficiencies, reduced costs and an increased competitive advantage for your business. Visit the blog today to learn more and ask your questions in the comments section. You can also sign up [...]

Answer Question   |  April 21, 2010  6:17 PM
Database, Exchange, Microsoft Live Chat, Oracle, SQL Azure database, SQL Server 2008, SQL Server 2008 administration, SQL Server 2008 R2, Windows

Policy Management – SQL Server 2008
I have installed SQL Server 2008 Developers Edition on Laptop witrh XP. All installed ok but noted that under Management section there is no policy management. Is this a separate option during the installation or not included in the Developers 2008 edition of MS SQL Studio?

Answer Question   |  April 13, 2010  11:09 AM
Policy Management, SQL Server 2008, SQL Server 2008 administration, SQL Server 2008 performance, SQL Server 2008 Policy Management, Windows XP

16 node failover clustering in SQL Server 2008
How can 16 node failover clustering be achieved in Microsft SQL 2008 enterprise edition? Are all nodes in active state? How many nodes can remain active?

Answer Question   |  April 13, 2010  9:31 AM
Failover Clustering nodes, SQL Server 2008, SQL Server 2008 administration, SQL Server 2008 performance

Oracle 10g versus Microsoft SQL Server 2008
Require comparison between Microsoft SQL 2008 enterprise edition versus oracle 10g standard edition.

Answer Question   |  April 9, 2010  5:58 AM
Oracle 10g, Oracle 10g administration, Oracle versus Microsoft SQL, SQL Server, SQL Server 2008, SQL Server 2008 administration

Email sp_who2 on lock/wait sql server 2008
I have an alert set up to run a stored proc that will email me the results of a sp_who2 when the Lock Waits/sec rises above 2 seconds. The problem is that the alert doesn’t fire off until after the lock has cleared, so the results of the sp_who2 are not very useful because they [...]

Answer Question   |  April 15, 2011  9:10 PM
SQL Server 2008, SQL Server 2008 administration

Database management plan wizard
I installed Microsoft SQLSERVER 2008 management studio Express with advanced services. I am trying to work with Database management plan wizard. What is the navigation for that? and i don’t find management plan folder under management in SSMS express…Do i need to install sql server enterprise manager to get management plan wizard?

Answer Question   |  February 23, 2010  8:24 PM
Database management plan wizard, SQL Server 2008, SQL Server 2008 administration

Copying view from remote to local SQL Server with SSMS
Hi I’m currently trying to get to grips with an upgrade from sql server 2000 to 2008, forced by an upgrade at my ISP. I’m used to using Enterprise Manager to export data from my ISP to my local machine for backup, and this process copying tables as tables, views as views and so on. [...]

Answer Question   |  February 10, 2009  2:52 PM
SQL Server 2000, SQL Server 2000 migration, SQL Server 2008, SQL Server 2008 administration, SQL Server Enterprise Manager, SQL Server Management Studio, SQL Server Management Studio 2008, SQL Server migration, SQL Server views, SSMS 2008