Cory,

Your posting is from 6/6/2006...did you ever resolve the issue?

-SQLBill

Andy,

There could be lots of things wrong. You just don't give us enough information on what you are trying to do.

1. are you on the same network as the...

That's why it is SO helpful to have the code posted and why we ask for it so often.

-SQLBill

Try:

SELECT CONVERT(VARCHAR(10),GETDATE(),101) + ' ' + SUBSTRING((CONVERT(VARCHAR(19),GETDATE(),100)), 13, 7)

I use GETDATE() for testing purposes. Just replace it with your parameter.

-SQLBill

What data type is TransactionDate? If it is DATETIME, then it has a time part.

Let's say TransactionDate is 2/6/2007 05:00:00. That is NOT equal (=) to 2/6/2007. Why...

How many characters are you talking about per row?

UPDATE: Forgot to ask....are you SURE the data is really in the field? Run this against the column you are having...

Wow...doesn't that sound like a homework question!!!!!!!!!

-SQLBill

It may NOT be a permission error. Is the new server still in the same domain as the original server? Is the server using the same name as it originally...

And then once you choose Client Tools, you will get a window where you can choose what client tools you want to install (Books OnLine, QA, Enterprise Manager, debugger, etc.)

-SQLBill

Though you solved it...here's the answers to your questions:

Have you checked the Windows Event Viewer Logs for related error messages?How do I access the event viewer in enterprise manager? Or...

1. You don't have much CPU usage. You only have 2 to 5%, that's not bad.

2. If you want to find out what processes are running, go to this site:

...

Unless someone changed the job name, the job name itself matches the DTS Package name.

-SQLBill

Have you checked the Windows Event Viewer Logs for related error messages?

Can you run these and see what happens:

select top 1 id from DVD_I_Have where Userid=78 and DVDID=8 and onhold=0;

SELECT...

Run this query:

SELECT ServerProperty('Edition'),

ServerProperty('ProductVersion'),

ServerProperty('ProductLevel')

Then let us know what the results are. It will tell you...

Nope. Because an Identity column is in numeric order.

1

2

4

5

6

10

etc.

So, numbering the rows yourself:

1

5

2

10

6

etc

can't be converted to IDENTITY.

-SQLBill