Simple you can do a subquery for the maxdate and student and join this to the table itself for the rest. This assumes however the test can only be taken...

Look at

information_schema.columns

and

information_schema.tables

also what is your goal as it might work better with SQL-DMO?

If you are using SQL 2000 then you could easily do

select * from

a

inner join

b

on

a.col1 = b.col1

where

CHECKSUM(a.*) != CHECKSUM(b.*)

The checksum function is like a CRC value which if they are equal...

Ok so after you restart the app server? Is that what you said (in case I misread).

If so then you have to close your connections between each use for best...

FYI... Hotfix 878 will correct the issue.

http://support.microsoft.com/?kbid=838166

It is definently happens between 818 and 859 that cuase it for me as the only server with 859 left on it is...

Now when you look at these spids which server are you talking about, the one the UDF references or the local. If the remote then I am still looking as...

I fortunately have dealt only with eastern time zone so I have an SP to do the conversion (SQL 7 however I retired that code) or a com object. Personally...

First if you are near the max length on most of your fields you could actually loose space because varchar incurrs and extra 2 bytes to manage the offset for...

Don't look at how long open look at last bacth and see if that is days or not. If not then it is because the connection is being reused enough...

Task scheduler is like any other service it runs either under LocalSytem or a defined user. If you need a specific user rights on the SQL Server you need to...

Can you post how you are performing in the SP and are you on the server when manually running the DTS and are you using the same login account to...

Usually I see this when I have a table that has two rows with the exact same data in every column that was defined with no uniqueness in any column....

Constraint does duplication the check before insert, unique index does as insert is occurring. This means in the first there are two actions on the index, seeks if dupe found errors,...

I agree and I believe I was Little strong in my statement as was a bad day with another developer when I wrote. 99.9% are always happy to fix and...

Fortunately our building does have a backup generator so heat has been a minimal issue in our personal server room. But we have found keeping the lights off (we have...