My ldf file is damged. How can i rebuild that file?

I design computer-based training for intranets.  The training files currently
use an Access database to store user results.  The training files send SQL
commands to an ASP page that relays them on to the Access database.  Access
responds by sending data to the ASP page and back ...

I am a complete beginner to SQL server. I 've downloaded Visual Studio (VB
2005) on my machine along with SQL database option, which now I can create
database inside VB.NET. I like to work and learn the SQL server RDBM itself.
What I can see on my Start>Programs menu are only SQL ...

Is there a way that I can get a resultset that contains unique dates in
a given date range without the need to have a temporary table and a
cursor?
perhaps something like:

i have created some (test) Web Services in a Sql Server 2005 via the
Create Endpoint Statement. Now i look for a node in the "Managment
Studio" where i can see these Web Services. But i dont found that. What
is the plainest way to do that? What alternatives are existent?

SQL 2000 SP3
================================================
In reviewing this screen, I have SPIDS > 100 that have a status of
sleeping, command = AWAITING COMMAND and login/batch dates that are

I am trying to insert Comma (,) into the cost field in my application
which is of money data type.How can I insert Commas(,).Can some one
help me out.
Here is the sample query what i am trying to write.

I've got the following problem
I'm using DTS to transfer fata from csv files into a table
In the file there are often duplicated rows, therefore I made
trigge

i have a table:
RECORDS1
fields:
DATE1,NAME1

Howdy guys.
I have the pleasure of assisting a friend with some changes to his
system. One thing he needs is a new SQL setup that will scale.
I was thinking of a quad exon box, 32 bit win2003 enterprise, 12 gig

I have two queries which will yield me the same result.
Is there a way in SQL Server(Query analyzer or Enterprise Manager) to
check the performance of both these queries and select one.
I have heard of performance plans.... all those things. I am not

I need a sql statment that will fetch 1000 rows at a time
for example i have got a table called customer which consist of 7500 rows
in my first fetch i need
1 fetch -- 0 -1000 rows

This looks simple but I couldn't get it right
For eg.
Table1 has
1 ABC

How do i know whihch MDAC version i am using in my computer.
I need to know the version of it and the driver fiile names stored in my
computer .
Thanks in advance

I know how to use MS Access's 'IIf' statement to test one field and
get different results in another field.  Is there some way of doing
the same thing in SQL Server's Enterprise Manager and store it as a
view?  My SQL Server Admin class instructor showed me the UNION query,