Yes, each differential backup gets stored to its own file.  These files are backed up to tape nightly.  My transaction log backups get appended to the same file for each...

Opps.  Forgot a few changes to the second query.  Here is a corrected version of the second one:

SELECT

    cm.CustomerCode,

    cm.CustomerName,

    dca.Street1,

    dca.Street2,

    dca.City,

    dca.State,

    dca.Country,

   ...

If the query above doesn't work, here is another one to try:

SELECT

    cm.CustomerCode,

    cm.CustomerName,

    ca.StreetAddress1,

    ca.StreetAddress2,

    ct.CityName as City,

    st.LongName as State,

    cn.LongName as Country,

    ca.Zipcode,

    ca.Phone1 as Phone,

    ca.Fax,

   ...

You can overwrite an existing differential backup.  Restoring a database using a combination of Full, differential, and transaction log backups is a viable solution.  You only need the most current...

Currently you can't debug a stored procedure using SSMS.  At this time you have to have Visual Studio Professional or better to accomplish this very useful feat.  Personally, if you...

Not disputing that using the order by in a view defined with a select top 100 percent doesn't work in SQL Server 2005.  I am simply stating that it isn't...

Hemant,

Not having your table layouts or test data makes it a little hard to help you with your problem, however, based on your posts I have tried to come up...

And ultimately it is the application that dictates what needs to be done.  If a calendar table is not required, why build it.  No where in the posts is there...

I have the same issue.  All you can do at this time is keep the SQL 2000 client tools available for thos times you need to modify the UDF's you...

Why not just add the case statement to you select statement?

select

    a.SomeDate, -- a date field

    case

        when (datepart(dw, a.SomeDate) in (1,7)) then 'Discount'

        when '2002-01-01' + ' ' +...

If you are selecting less than 100 percent of the records returned in the select, the order by in a view works.  SQL 2005 ignores (as it is written in...

Windows 98 doesn't support the service architecture even though you can use the personal edition of SQL on Windows 98.

I would suggest looking at upgrading to at least Windows 2000...

Try this query:

SELECT

    tblSOP_Type.Id,

    tblSOPS.tblEquipment_id,

    tblSOPS.tblSOPType_id

FROM

    tblSOP_Type

    LEFT OUTER JOIN tblSOPS

        ON (tblSOPS.tblSOPType_id = tblSOP_Type.id

            tblEquipment_ID = 1)

hth!

Hemant,

I was looking at your code and to me it is somewhat confusing.

Your original query contains 2 derived tables, both based on the same table dbo.tblCustomerAddress.

Both queries also restrict the...

Try this query in your production environment:

select

    *

from

    dbo.TD_TASK_STEP a

where

    exists (    select

                    1

                from

                    dbo.TD_TASK_STEP b

                where

                    b.in_StepID <> a.in_StepID

                    and b.in_TaskID = a.in_TaskID)

hth