Were these machines installed from an image?  It could be that the MTC identifiers in the registry are the same.  I had a similar issue about a year ago that...

Hi Andrew -

Welcome to the SQLServerCentral world!

Questions back to you:  Is there a way to uniquely identify every record?  Would there be a field or combination of fields that you...

Also check in EM(Enterprise Manager) to see which filegroup SQL decided to place any 'Text' data.  Even if you don't have text fields, SQL creates a pointer to those filegroups and...

JJ, you need to group on datepart(mm,datefield) but this will only work if you have only one calendar year's data.  You could try grouping on datepart(yy,datefield), datepart(mm,datefield)

As for the second...

Take a look at the Cast and Convert page in Books Online (BOL).  There are styles you can use.  Perhaps you can convert to a char field and do the...

Here is what another SQL site recommends:

http://www.sql-server-performance.com/stored_procedures.asp

I was the 'new DBA' appearing to revoke rights from all-knowing developers too.  I do not envy you.

I see.  You changed the definition of the field.  Of course it is going to give you all 3 records if you have it set as char(6) and only place...

APF -

I tested it on SQL2k with SP3 and it works fine.  I have tested with varchar and char and it works both ways.  Could you please show me why it...

What kind of comparisons are you going to do?

I use integer for weeks ie week 32 of year 2003 is written as integer 200332 which makes the math simpler than...

create table test

(field1 char(5))

insert into test

values('abcde')

insert into test

values('ab de')

insert into test

values('ab d ')

select * from test

where charindex(' ',field1) > 0

two results:

ab de

ab d

I'm sure there is a tool you could purchase to monitor this, but I don't know what that would be.

I run sp_who2 every 10 minutes on my server and put...

I hesitated answering this, because I know with SQL2000, you can attach an mdf without the ldf.  But I cannot remember in SQL7 if this was a possibility.

If you use...

In Enterprise Manager, you can right click a database and Generate SQL Scripts.  Within that you can choose to script permissions.  This has worked well for me in moving between...

I like the article because it gets me thinking.  We all have a 'well I will get to that' list and documentation and backup are usually #1 and 2.

Our office...

Here's my answer:  It depends.

Do your users select * and pull in all fields when they really only need one or two?

You could make your three tables, then create a...