Change management is one of the most difficult issues to deal with for a development dba.

The tools do not help you maintain versions of code or table schema.

What you should...

But what makes you want to pick the first row?

is it because the second value is zero? the combination of the three values?

you just want to delete the first row?...

Please elaborate on your problem

are you trying to delete duplicates?

does your table have a primary key?

Please show us an example of what your table looks like,

and what your data looks...

yes

use sp_addarticle in t-sql to add articles.

The Agents will automatically pick up and make snapshots of only the new articles. and transfer them over.

I believe you also have to...

Create a date table that has all the dates you need.

then query the table.

Create table t_Dates (id int identity PRIMARY KEY CLUSTERED,

                               [Date] smalldatetime NOT NULL Default('01/01/2005'))

SELECT TOP 8000...

As suggested reading is in order.

transaction log grows according to your recovery model

Read selecting a recovery model

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_4l83.asp

The transaction log is where all transactions against your database are written down...

Why would you want to do this?

Look for Dynamic sql. But you shouldn't use it if you don't understand it.

I would not recommend to implement as you have suggested.

It is the same reason why you don't store first name last name, and middle initial in the same field.

also what...

Declare @Site char(1)

set @Site = '1'

select Calldate,Project, sum(hours) as TotalHours

from #Table1

where (right(project,1) = '5'

       or

       site = @Site)

group by Calldate,Project

set @Site = '2'

select Calldate,Project, sum(hours) as TotalHours

from #Table1

where (right(project,1) =...

Look up transaction isolation levels in books online.

You can set your transaction isolation level to read uncommited as you see necessary.

It is a connection level property

From BOL:

SET TRANSACTION...

Not a biker, fishing, and golf are my interests.

You are going to have alot of problems trying to do this.

Most users will not have ddladmin permissions, you cannot grant users just create view permissions.

So the security chain will...

Reporting services has absolutely no ability to do "AdHoc" querying.

the only/best option is query analyzer .

Access works well. But you still have to teach...

Notice how the Command is stating Killed/RollBack.

Sql is rolling back all the transactions it had completed. Your just going to have to wait for it to finish.

As a rule of...

When you saved your files, what do you mean by saved?

My guess is you have to re attache the mdf, and ldf files.

use enterprise manager to attach, or use sp_attach...