1
  • 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 2008...

    TLMercer45 pointsBadges:
  • 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...

    Muralihan5 pointsBadges:
  • 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 don't contain the...

    TJay85 pointsBadges:
  • 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?

    Rick Martinez585 pointsBadges:
  • 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...

    Dataempress115 pointsBadges:
  • 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 can get my...

    Palloquin95 pointsBadges:
  • 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?

    ITKE344,970 pointsBadges:
  • 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 Thanking you in advance

    Davewaltonuk20 pointsBadges:
  • 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?

    Akansha150 pointsBadges:
  • 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...

    EmNichs3,250 pointsBadges:
  • 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?

    Akansha150 pointsBadges:
  • 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?

    Ganners255 pointsBadges:
  • Oracle 10g versus Microsoft SQL Server 2008

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

    Akansha150 pointsBadges:
  • 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...

    Student0045 pointsBadges:
  • 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. But using Export...

    Tsp196520 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following