Lynn,

That worked perfectly.

Thank you very much.

Jeff

Here are some samples that I refer to frequently.

select convert(varchar(20),getdate(),101) --1 --MM/DD/YYYY

select REPLACE(convert(varchar(20),getdate(),101),'/','-') --2 --MM-DD-YYYY

select convert(varchar(20),getdate(),103) --3 --DD/MM/YYYY

select convert(varchar(20),getdate(),104) --4 --DD.MM.YYYY

select convert(varchar(20),getdate(),105) --5 --DD-MM-YYYY

select convert(varchar(20),getdate(),106)...

That worked great. I didn't think of it that way.

Merry Christmas.

I'll give this a try.

Thanks for your quick response.

Wouldn't the Slowly Changing Dimension task work for this? I've used the SCD task many times and it automagically creates the update and insert statements based on how you...

I went through the steps of the restore, but instead of executing, I scripted it.

Does this correct?

RESTORE DATABASE [RealPage]

FROM DISK = N'C:\RealPage_FTP\U1050266.bak'

WITH FILE = 1

,NOUNLOAD

,STATS =...

The zip file will always be extracted to the following:

c:\RealPage_FTP\U1050266.bak

I'm good with SQL from a data perspective, but not on the admin side. How would I write a SQL...

Thanks everyone, I've been able to resolve my problem. The SQL 2000 version that was appearing was related to an old install of an ERP system I had worked...

Thanks, I appreciate the advice.

Have a good night.

$50, that is amazing.

How fair?

Thanks,

I'm at a loss. I swear I used the same disks to install my previous local instance.

Does SQL Express have a SSIS component?

I'm going to go have a drink...

Configuration Check reported two Warnings.

1. - SQL Server Edition Operating System Compatibility (Warning)

Messages

SQL Server Edition Operating System Compatibility

Some components of this edition of SQL Server are not supported on...

Background Information

1. SQL Server 2005 Enterprise Edition

2. Laptop running Windows XP Profession Version 2002 Service Pack 2

3. 3.25 Gig of Memory

4. 50.7 Gig of Free Space

I had been running SQL...

I did some more digging and was able to determine that the old SQL 2000 (Select @@Version) was still on my laptop somewhere. So I've fully un-installed SQL Server...