Okay, Gathered that from original post. Can you provide us with an example?

Did you try the Union Method I posted earlier?

what does sp_helpfile reveal?

Are you connected to the database your trying to shrink the file on?

use Northwind

DBCC SHRINKFILE(pubs_log,TRUNCATEONLY)

-- Results

-- Could not locate file 'pubs_log' in sysfiles.

-- DBCC execution completed. If...

Here Ya go, Thx to mikedouglas

http://www.sqlservercentral.com/scripts/contributions/1260.asp

I'm sure your not interested in reading this but for all to enjoy

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx

You should be able to do that in BCP With field terminator switch, you can use anything from '(tics) to |(Pipes) whatever

usage: bcp {dbtable | query} {in | out |...

Although we love helping, we can't do everything.

A bit of light reading may be in order.

From Sql Books online.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ga-gz_8dri.asp

Just performing nightly backups on your database should help.

But if for example you have a table with Static data that you want to preserve, then you can use BCP to...

A, A

What do you mean you need headers and footers?

Is your header the column names? Is it some other derived value.

U can try the union statement. Use the NULLS TO...

When you use a derived table you need to give it a name or alias.

CREATE PROCEDURE sp_getInfo

AS

--Begin

Select Office, tab, title,

round(SUM(curno),2) as CurNo,

round(sum(prevno),2) as PrevNo, TabOrder, SortOrder

from

(select...

Has the size of the database changed significantly? Bigger db, longer Backup time. I don't know that there is anything you can do to improve the performance of the backup....

The basic jist.

when records are changed or added to the databse they are first written to the transactoin log then every so often sql server posts transactions from transaction log to...

I'm not sure There is a way to tell,

If you don't mind me asking, why do you need this information?

Ahh, I hate it why my post doesn't post

This looks like a classic case of parameter sniffing. I have seen it on very rare occasion, and can't explain it. There...

If you want to assign a value to a parameter use sp_executeSQL

set @SQLString = 'SELECT top 1 @uidEventID = MCONVERT(VARCHAR(50),SLOTID)' +

     ' FROM ' + @in_vchServer + '.' + @in_vchDBName...

To insert a record into the class table when a record is inserted into the brances table.

CREATE TRIGGER branch_branchID_class_branchID

ON branches

FOR INSERT

AS

INSERT into Class (BranchID)

Select BranchID

from Inserted

This...