Please, could you help me with this SQL query ?
I need get data from last 3 months,
but it´s shows me only January's data.
(Query doesn´t get data from november and december/2009)

I have this query
SELECT COUNT(*)
FROM   Pro
WHERE      D_TIME BETWEEN '2010-02-14 00:00:00.000' AND '2010-02-20

Suppose you were looking at widget manufacturing data, and your DB
looked like this:
tblWidgetsProduced
 dtStartTime

Is it possible to link access tables to a sql server 2005 db? I can't seem
to find any option in Management Studio.
Thanks
Regards

I don't really have a problem per se but since I am not a 24/7 DB
developer I'd appreciate an experienced set of eyes to provide some
feedback (and help me avoid future problems).
I am getting under way with designing a new MS SQL DB architecture

I've been tasked with designing an application to capture data about
sports clubs.
Let's say there are four different types of club - Soccer, Cricket,
Rugby and Tennis.  For various reasons it is essential that data about

I am trying to design a db schema (or rather extend existing db
schema). My goal is to extend the database table so that every time a
new column is needed, we dont go about adding the new columns by
altering the table. Here is some background.

Here is the senario:
I have a stored procedure (we'll call it ProcA) which builds a cursor
then loops over the cursor calling another proc (we'll call this one
ProcB) for each record.  I need to create a temp table inside ProcB.

I have a SharePoint farm running and connecting to a SQL 2008 default
instance.
However, it looks like the  domain "Logins" within the MGMT Studio are
gone; I do not see any domain accounts nor can I perform any sys admin

I have created a database called ALIS with schemas logically related to
company departments:
usr All Users
acc Accounting

I will need to perform a nightly rebuild of a database during the
pre-release testing phase of a project.
The build and populate is performed by a number of .sql scripts.
I found a nice Powershell script to run all of these sql scripts by

SQL Server 2005 SP2 9.0.3054
I would like to move my DB (with Full Recovery Model) onto a
/different/ server.  I would like to do this w/o losing any
transactions.

I'm no where close to a SQL Server expert but we're using it as a back end
to another application.
I lost a PC that had MS SQL Server 2000.  I was able to recover the .MDF and
.LDF files but nothing else.  How can I restore these files to another SQL

does the SQL Server 2005 or 2008 have an API for the programming language C?
Regards, Domenic

I wonder whether you may have some hints and pointers. I'm trying to
create an ODBC User/System DSN but can't see the SQL server in the
ODBC New Connection Wizard drop-down. The client machine is in a
different domain than the server. I can ping the server and resolve by