You might want to use

SELECT Title + SPACE(@maxtitle - LEN(Title)) + ' | '

FROM dummycompany

changing to use the SPACE function for Title and company...

Temporary meaning you will only perform this task one time?

It has been my experience that with good results you will be asked to do it again, and then again and...

Can you supply a create statement for the table dbo.productscost, some sample data which can be fictional - that is not reveal a real product identification, or reveal any other...

Jdshabat

Good luck I shall look forward to your question, with clear concise choices. Let me point out what I believe is the most important portion of any question...

Gail,

Attempted to use Google to translate this and all it would turn up was an Amazon page with the translation to Japanese.

I give up ? What...

Jdshabat refer to my post on the 2nd page of this forum:

So I offer this challenge to you: WRITE AND SUBMIT A QUESTION OF THE DAY Frame it...

Webrunner

I suggest you go to BOL (The link is in my...

Can not take Snapshot backups seems to be the prevelant accepted answer but how do you reconcile that with the following from BOL fpr 2005

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/9b5720a9-93df-421f-b854-33e4656762e0.htm

Quoting from the above BOL entry:

SQL...

May I suggest that you may want to start learning how to use the Import Export Wizard in SQL Server Integration Service from Books On Line (BOL) using:

http://msdn.microsoft.com/en-us/library/ms365330(SQL.90).aspx

Then again using...

You might also want to try:

fn_trace_gettable

as:

SELECT *

FROM fn_trace_gettable

('C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\log.trc', default)

The location above is the default location for traces, yours may have been altered.

Many ways. Read the following from Books On Line (BOL)

OpenDataSource:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/5510b846-9cde-4687-8798-be9a273aad31.htm

OpenRowSet:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/f47eda43-33aa-454d-840a-bb15a031ca17.htm

Using a linked server:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/164b20dd-cd51-4eed-bec9-26134e20a8ad.htm

If you have specific problems with any of these methods, come on back and post a specific...

Jeff

Jeff should I be proud of this nomination and start...

What is your value for "nested triggers" option (ON or OFF)

Are they any other triggers on this table which update the table?

You might want to check BOL (Nested triggers)...

Cliff Jones

Both.

Steve

Been trying to work up a couple of more, but hey if I supply an incorrect / incomplete...