peter,

As you said it is unuasual file size. If you are taking frequent backups it should not reach that much size.

what is recovery model of the database??

Full recovery model...

David

try to attach them individually. first attach MOdel and next MSDB. this would help.

How must also have added the lonkedserver login using sp_addlinkedsrvlogin I hope this will resolve the problem.

Kalyan

Yes RH, I have also the same problem yesterday till didn't sloved. Today I am going to try to back up dagain tha transaction log and then restore the previous...

By default you have assigned NULL to  the perameters

I think if some you use of these in the query for comparison with out changing their value in proceadure then these...

filegroup

in SQL Server, a named collection of one or more files that forms a single unit of allocation or for administration of a database.

A file cannot be...

LIKE supports ASCII pattern matching and Unicode pattern matching. When all arguments (match_expression, pattern, and escape_character, if present) are ASCII character data types, ASCII pattern matching is performed. If any...

WHY it is behaving like that?

Yes that may be true. It is considering E, D letters as scintific notations for floating point.

Isnumeric checks weather the string would be casted...

Yes grosshopper,

You should use eliase in subquerry. Not only this please verify the follwoing. Using IN operator on nullable fieds is a danger. when the ansi nulls is set to on. So...

Dear sukhoi,

--example 1

declare @EchVPoin as varchar(5)

declare @noofVisits as varchar(5)

set @noofVisits=2

set @EchVpoin = 1+@noofVisits

select @EchVpoin

--example 2

declare @EchVPoin as varchar(5)

declare @noofVisits as varchar(5)

set @noofVisits=2

set @EchVpoin = 1/@noofVisits

select @EchVpoin

--example 3

declare @EchVPoin...

I think when using distrubuted querry for updations it requires set xact_abort on unless the provider support nested transactions. Here Truncate doesn't even use the rollback segments. So I think...

the is fine. But may be you want to know even the customerids also who are duplicates. Then try the following

select c.id,c.lastname,c.phone,c.street from customers c inner join addresses a on...