I think DavidB made the best point. It's not Management, whether they are good or bad. It's US, whether we are developers or DBA's. WE have to co-operate with each...

Thanks to both of you. I wanted to do this for two reasons....better security and some of my user's queries were crashing their systems and taking too long. This way...

Can you tell us what the fields are? Do you have a datetime field?

If you have a datetime field that holds the datetime of the entry, you could do:

select *

from...

Here's what I found out from Microsoft's web site: (http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/reskit/sql2000/part2/c0361.asp)

SQL Server 2000 Personal Edition is not a separate product but rather a client component of SQL Server 2000...

There isn't a 'desktop' version. There's the Personal Edition and MSDE edition.

Which is the one you want?

-SQLBill

Is there an ID on each row?

If so, have you tried:

SELECT *

FROM mytable

WHERE myid NOT IN (SELECT DISTINCT * FROM mytable)

-SQLBill

Where are you trying to save it on the destination server? Is it a partitioned drive? How much space is in that partition?

For example: The destination server could have a...

Or you could use IS NULL:

UPDATE mytable

SET mycolumn = 'newentry'

WHERE mycolumn IS NULL

-SQLBill

Check out the Books OnLine for ISNULL.

ISNULL(check_expression, replacement_expression)

Select ISNULL(mycolumn, 'NewEntry')

-SQLBill

Your query could be truncating the time from the column. That's what I would check first.

For example, try this in Query Analyzer:

select getdate()

select convert(varchar(10), getdate(), 120)

-SQLBill

Great idea for those who could participate. Maybe a poll could be used to find out how many can/will participate. I can't for three reasons:

1. don't have a test/development setup...

I run an active/passive cluster (Win2K Advanced Server/SQL Server 2000). One database is currently 160+ GB, one table is 528,000,000+ rows. The database gets BULK INSERTs and SELECTs only. BULK...

Have you tried using Enterprise Manager, right clicking on TEMPDB, selecting properties and then checked to see the default size of the database? That's what TEMPDB will start at when...

I do both depending on how long I need to keep my backup. I append my Full Backups; since one might be bad I want more options.

I overwrite my differentials,...

This is a "double" posting and is also in the section for BACKUPs. Since that's the more appropriate area, let's allow this one to cease and respond to the other...