How do I determine if the time value of a datetime field (in SQL) is between
2 other time fields (e.g., I have a LastUpdated field =#5/29/2007 12:04:32
AM# and the comparison fields are starttime = #05:00:00 PM# and
endtime=#02:00:00 AM#)?

I will be moving the SQL Server 2000 databases from Server A to Server B.
Both the servers will be having the same directory structure. Here is what I
will be doing:
1. Backup and restore master from Server A to Server B

anyone knows a free documentation tool to use in SQL Server 2005?
Thanks a lot.

Strange problem that I just noticed. I use a handful of databases in SQL2005
Express for development. All of these databases except the one I've been
using most recently "cannot be opened due to inaccessible files or
insufficient memory'.

Good day to everyone.
I am in the process of upgrading our version of sql server from 7 to 2005.
My problem is we are currently using database application installed in sql
7,and i'm afraid it will not work in sql 2005.  can anyone help me on

I need to run a SQL Task If the task fails I want it to wait for 10
minutes then I want it to retry the task until it succeeds.  So to go
into more detail I have a task that checks to see if data is being
loaded into the database if it is I want to wait until it is done

I have a MDB that consists largely of a number of linked tables to
external data files, which contain various activity data. I then open
this db from my ADP project using OpenDatabase and OpenRecordset,
which I believe are based on DAO (are they?).

My management asking generate monthly reports on all produciton sql server
databases with different statistics.
How can I generate them?
Is there any system tables that store historical statistical data?

Does anyone have an experience using this trace flag in a production
environment? When you would use it and how to tell if it has a positive
effect? I gather that it might be a good option if you are not IO bound but
have a CPU bottleneck.

I am not so familiar with sql 2005. I cannot point my data to other drives
such as D:\ or E:\.
When I installed sql 2000, it gives me the option to select data folder to a
different location and program files are on C:\

I have a stored procedure that sends email.  It works fine with the
exception it doesn't include the assigned subject, so the subject is blank.  
I am running SQL 2000 SP4 on a Windows Server 2003 box.  The mail client is
Outlook 2003 with Exchange 2003 being the mail host.

I was reading about the improvements in SQL 2005 database creation, specifically how this is now much quicker.  A book I am reading sites and example of a 1 GB database being created in 1 second in SQL 2005 and ~38 seconds in SQL 2000.  It states:
"The reduction in creation time ...

Hi!  Thanks in advance for any guidance.  Should the databases be "In
Recovery" for so many hours?
Windows Server 2003 SP1
SQL Server 2005 SP2

Yesterday we had some 701 resource messages on one of our production
servers. This was followed by a number of Downgrading backup log buffers
from 1024K to 64K messages in our backup jobs. This is an SQL2005 build 3159
server on W2K3 SP2. We had similar problems last year with an ...

i have the following error poping up. i can not also open error log from
studio can open it with notepad however
Exception happened when running extended stored procedure 'xp_readerrorlog'
in the library 'xpstar90.dll'. SQL Server is terminating process 84.