It is my understanding that you can go either direction without any problems.

Tempdb is used during query processing for sorts, joins, unions, etc.  If you have enough poorly written code and a number of users, it is possible that tempdb is getting...

Okay... You will need to elaborate on that one.  Not really sure what you are talking about regarding "forms".

Since you have a backup, just restore the database.  When you do that, the database will be in 2000 compatibility mode.  You will need to go into the properties and...

After doing the above, restart SQL and then delete the original tempdb data and log files, as they will still exist in their original location.

Also depends on indexes as well.  If the datefield is indexed it should still run well, but I guess we'd have to find someone willing to test it on a...

Got beat, oh well!

Or you can try this:

select

    a.dtDate,

    datediff(dd,(select min(b.dtDate) from dbo.testtbl b where b.dtDate <= a.dtDate), a.dtDate) as AccumTime,

    datediff(dd,isnull((select max(c.dtDate) from dbo.testtbl c where c.dtDate < a.dtDate), a.dtDate), a.dtDate) as...

Why do you need the result returned as a comma seperated list?

No, SQL Server Agent can not be running while SQL Server is stopped.  It would be unable to access the msdb database.

You don't need a cursor:

declare @SQLString varchar(max)

select @SQLString = isnull(@SQLString,'') + Column1 + ',' from myTable

set @SQLString = substring(@SQLString, 1, len(@SQLString) - 1)

select @SQLString

I can help answer part of your questions, mainly question 2.

The transaction log is not truncated by either full or differential backups.  To truncate the transaction log, you need to...

We haven't setup Database Mail (yet) but I had a similiar requirement using SQL Mail on two SQL Server 2000 systems.  I populated a temporary table with the information from...

Although your are being authenticated through the group BUILTIN\ADMINISTRATORS, system_user still returns who you are.  I do not know of any system functions that will return the group through which...

Not sure, but you can give this a try:

CREATE PROCEDURE [dbo].[MY_CREATE_VIEW] AS

WITH EXECUTE AS OWNER

AS BEGIN

    DECLARE @SplitTblName char(5)

    DECLARE @CreateViewScript nvarchar(4000)

    DECLARE @GrantPermissionsScript nvarchar(4000)

    DECLARE @Count...