If you are referring to a lost server that had to be restored and you have the DB file in question, if it was not corrupted you may be able...

Ok guys does this not sound simply like this.

SELECT StatusLog.LogID, StatusLog.Status, StatusLog.StatusDate FROM StatusLog

INNER JOIN

(SELECT LogID, Max(StatusDate) as MaxStatusDate FROM StatusLog GROUP BY LogID) AS MaxTbl

ON

StatusLog.LogID = MaxTbl.LogID...

I believe if I remember correctly that you cannot disable netbios requests and that it is always check first as this is the provider that will tell about shares and...

For SQL 7

7.00.623 if SQL Server 7.0 with no service pack applied

7.00.699 if SQL Server 7.0 Service Pack 1

7.00.842 if SQL...

Try this,

CASE

WHEN datediff(month,@as_of_date, #lease_scheds.end_date) < 0 THEN 0 ELSE datediff(month,@as_of_date, #lease_scheds.end_date)

END

By using case I tell the value to be 0 when less than 0 otherwise print the value.

"Don't roll...

Unless you keep really good documentation.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Take a look at the following KB Article on MS site http://support.microsoft.com/default.aspx?scid=kb;en-us;Q276041 which is fixed with SP3 on SQL 7. Tell me if it does not apply to you but...

Ok I understand now, let us know if the other works. If not you may be able to pull it off with active script in DTS to handle the import,...

Straight foward and giving in both formats to show the implimentation needs was a nice touch.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston...

It requires that the base pages themselves use Windows Authentication for you to be able to use a trusted connection. That is because the user is otherwise passed as Anonymous...

No not really, could have been a corruption in the configuration that reset when you moved off TCP/IP then back on, but I would have to dig in the registry...

When you get to the autchenication screen there is a button for client config. Did you check in there to make sure that it is deffiently using the TCP/IP network...

Ok let me ask this. Are you saying that you have multiple columns of data and the overall width is 20000 bytes which is well over the 8000 byte limit...

Actually this is default (at least that is whjat I thought and have seen from my experience). But if you need to increase or decrease you right click in the...

Crude forgot to put in, this is done this way for several reasons including being able to restore to another server from backup or straight file since the logins in...