Viewing 15 posts - 6,766 through 6,780 (of 7,429 total)
You cannot restore a SQL 6.5 backup to anything other than 6.5 as they made changes in the backup file structure. You have to restore to a 6.5 server the...
March 19, 2002 at 3:36 pm
What delimiter are you using, and are you sure it doesn't exist in the column of data that is truncating?
"Don't roll your eyes at me. I will tape them in...
March 19, 2002 at 3:34 pm
This should do it.
UPDATE calltable
SET ct.country = cc.country
FROM calltable ct
INNER JOIN
countrycodes cc
ON
left(ct.callnumber,len(cc.prefix)) = cc.prefix
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
March 19, 2002 at 1:24 pm
Transcenders always seem to be the best, the only problem though is they almost mirror the exam and you may pass by memory of the question alone with no real...
March 19, 2002 at 1:18 pm
Unless you have a column that updates when changes occurr or something else to hook, then the tranasaction log would be your only help and I don't know of and...
March 19, 2002 at 1:16 pm
You want to use IF UPDATE ( column ), see CREATE TRIGGER in SQL BOL.
IF UPDATE (column)
Tests for an INSERT or UPDATE action to a specified column and is not...
March 19, 2002 at 1:14 pm
The reg file and at the most you will need to install the MDAC to get the drivers installed for SQL server on th client. But you do not even...
March 19, 2002 at 11:29 am
Glad to hear you found your answer. I will have to keep this in mind next time someone has a similar issue.
"Don't roll your eyes at me. I will tape...
March 19, 2002 at 9:51 am
That is odd, what version and sp level are you running?
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
March 19, 2002 at 9:47 am
Usually only happens when the item being twisted does not exist the say as on your local machine. Try build the package agin on the server (not your local machine)...
March 19, 2002 at 9:02 am
I vote 1 partition also.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
March 19, 2002 at 8:59 am
Is the SQL Mail client you are using MAPI? Also have you sent the message thru the client directly to see what happens? Lastly can you post how you are...
March 19, 2002 at 6:15 am
1) This can be found by drilling down thru Enterprise Manager to SQL Server Agent under Management. Right click on SQL Server Agent and choose properties and the login will...
March 19, 2002 at 6:12 am
Yes your leak could exist and be acually coming from the delphi object. Was this built inhouse or third party, if third party check with the vendor on this or...
March 19, 2002 at 5:21 am
Sounds like a permissions error, and yes SQL Agent must have rights on the object in order to use. To test try logining in as SQL Agent on the box...
March 19, 2002 at 5:15 am
Viewing 15 posts - 6,766 through 6,780 (of 7,429 total)