Viewing 15 posts - 2,716 through 2,730 (of 3,221 total)
You might want to use
SELECT Title + SPACE(@maxtitle - LEN(Title)) + ' | '
FROM dummycompany
changing to use the SPACE function for Title and company...
December 18, 2008 at 6:04 pm
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...
December 18, 2008 at 5:00 pm
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...
December 18, 2008 at 2:43 pm
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...
December 18, 2008 at 1:07 pm
Gail,
Hoekom nie?
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...
December 18, 2008 at 12:57 pm
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...
December 18, 2008 at 10:04 am
Webrunner
It helped me, in the sense that I was reminded that you can't take a backup of a snapshot
I suggest you go to BOL (The link is in my...
December 18, 2008 at 9:56 am
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...
December 18, 2008 at 8:38 am
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...
December 17, 2008 at 5:05 pm
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.
December 17, 2008 at 4:11 pm
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...
December 17, 2008 at 3:55 pm
Jeff
I particularly liked ol' Bit Bucket's response... I'm gonna have to add him to the pork chop hall of fame.
Jeff should I be proud of this nomination and start...
December 16, 2008 at 8:26 pm
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)...
December 16, 2008 at 6:42 pm
Cliff Jones
but what would the point of that be? To reduce the load on Steve or to reduce the complaining?
Both.
December 16, 2008 at 3:37 pm
Steve
Feel free to send me some with a note you don't want credit.
Been trying to work up a couple of more, but hey if I supply an incorrect / incomplete...
December 16, 2008 at 3:34 pm
Viewing 15 posts - 2,716 through 2,730 (of 3,221 total)