Try setting your application up to use an IP address for the SQL server instead of a network name.  You might be having name resolution problems.

heh.  I was just trying to show what BETWEEN does.  Chris is right.  In general, it is best to avoid performing computations (including convert and cast) on tables.  It is...

 @W BETWEEN @X and @Y is shorthand for:

@W >= @X  AND  @W <= @Y

as shown in the sample execution plan below.

hth jg

StmtText               

-----------------------

set showplan_text on

(1 row(s) affected)

StmtText                                                               

-----------------------------------------------------------------------

select...

I think you will need to look at the data in the tables.

A couple initial thoughts:

You may have a duplicate key in the source table as a result of corruption or...

Google for:  SQL insert script generator

You will find numerous tools that will generate the insert statements for you.

Unless you like keying them out by hand....

hth jg

Actually, if you stop SQL services properly, copy off the MDFs and LDFs for all the databases, then install SQL exactly as it was before, then copy back all of...

The plan you have should work fine.  Make sure you rebuild to the same patch level you have currently.  There are a few post-SP3 hotfixes that may be applied, unless...

Where MyBit = 1, Where MyBit = 0 are good for testing bits.   Using MyBit <> 0 instead of MyBit = 1 can change how the optimzer estimates the rowcount, which...

Another approach, which will have the least impact on the source database, would be to restore a backup to another server.  Since the backup is happening already, this should not...

"WHERE rm.rmsacctnum = '4313030999894992'"

What's the expiration date on your VISA card?

(heh)

jg

Fernando,

I have run across this problem as well.  Indeed the Query Analyzer limits the column width by default to 256 chars.  This can be changed in the options as indicated...

I have SQLMMC.DLL in that location.

jg

Henk,

Peter K also posted essentially the same thing, which I failed to notice before.

Emeril is the host of a cooking show in the US.  He says "BAM!" may times during a...

There are actually 10 kinds of people.  Those who understand binary and those who don't.

Try this:

SELECT Day1 FROM

(SELECT DATEADD(dd, -DATEPART(dw, t1.X)-5, t1.X) as Day1

From (Select '20050102' as X) as t1) as Y

BAM!

(Sorry, but I just got done watching Emeril)

jg