I do a lot of file processing and I usually run a little script I copy
and paste to read directory information to see if a new file it there
and then process the file if it is.  So, I decided to wise up and make
a stored procedure to automate a lot of that.

Hello experts,
I'm trying the run the following query with specific intentions.
I would like the query to return 5 results; i.e., 4 distinct and one
duplicate.  I am only getting, however, 4 distinct records.  I would

I want my application to create a new database/tables when run for the
first time.  I have created a stored procedure to create the new
database named "budget".  When I run the stored procedure, it creates
the budget database but the tables are created in the "master"

Does anyone know how to purge old data in a MS SQL server 2000
database?

I am in desparate need of assistance. We are using an application
called PaperVision Enterprise which takes scanned invoices and puts
them into a database for the purpose of easy reference to any scanned
invoice in the db. 2 weeks ago while trying to perform a 'match and

I need a way to view all existing triggers in our MS Server database
especially since I don't know what tables are involved.
Thanks,
kwilla

I am creating a web services application in Visual Studio Dot net
which links to  a MS SQL database.
I need to create a form which lets the user pick his field of
choice(doesnt matter what it is..) using drop down boxes,radio buttons

I have a situation where I want to filter records for a given day.  The
field that stores the date/time uses the date() function as a default value,
kind of a date/time stamp for the record.
The problem is when I want to filter records for a given day instead of a

I backed up (full backup) a table service.mdf without the service.ldf
(size 10Gb) from the live server. However, whn I restore the table to a
test server it also give me a service.ldf (same size, 10Gb) together
with the service.mdf. Is this normal? Does the contents of the

I have one table like :
MyTable {field1, field2, startdate, enddate}
I want to have the count of field1 between startdate and enddate, and
the count of field2 where field2 = 1 between startdate and enddate,

I'm trying to setup a website using asp and sql.  For the time being I'm
doing it on my home computer but when finished I'll be moving it to another
server.  Will it be possible to do this considering all the database stuff
will be pointing to a differnt database?

What are the ways to export/import data in/out of SQL Server 2005? I
used to use DTS for 2000 to do such thing and now I can't even find
the wizard in 2005!

I have a table with several million rows.
Each row is simply the date and time a certain page was viewed.
eg
page1   1-1-00

I have a Text(datatype) column in one of my table and it contains word
document in binary format and I wanna search text in that column, Can I do
that through any techniques or its not possible through SQL Server 2000
database?

Hey yall,
I have a problem, I'm a DBA for about 250 databases.  I currently have
ZERO means of notification on them.  I put together an entire plan for
using SQL mail, got a pop3 account set up and all that jazz, but when