Viewing 15 posts - 6,436 through 6,450 (of 7,429 total)
Sounds like the log file may have been corrupted in some way. Try sp_attach_single_file_db and reattach the data file back that way. From this a new log file will be...
April 12, 2002 at 5:56 am
Sorry the only work around is to split into multiple varibles and concatinate into the text field. unfortunately the largest available datatype that a variable can exist as is CHAR...
April 12, 2002 at 4:59 am
Thanks for the bug post, when I get it corrected I will send you an updated copy.
"Don't roll your eyes at me. I will tape them in place." (Teacher on...
April 12, 2002 at 4:48 am
It shouldn't make any difference. Did you switch back to make sure was not due to caching? Also did you compare the execution plans?
"Don't roll your eyes at me. I...
April 11, 2002 at 1:20 pm
Here this is from BOL and may explain what you are asking best.
Using the DB-Library Automatic ANSI to OEM Conversion Option
When enabled, the Automatic ANSI to OEM conversion option converts...
April 11, 2002 at 11:47 am
This will get it but you have to have the Table ID which I have scripted to get then get group. Note: only shows Table filegroup not Text Filegroup.
DECLARE @id...
April 11, 2002 at 11:34 am
This question is better answered by Remedy but as far as I know it should not but as we use Oracle with out Remedy servers I have not had a...
April 11, 2002 at 10:23 am
Ok so I guess rtrim got it (must be a char field). The reason you would ever get "String or binary data would be truncated" would be if the field...
April 11, 2002 at 9:47 am
UPDATE tblName SET [Name] = [Name] + ' 3213'
Thsi si based on your example, if this is not what is being done please specify.
"Don't roll your eyes at me. I...
April 11, 2002 at 9:21 am
No but you can do CONVERT(VARCHAR,GETDATE(),101) or parse it manually.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 11, 2002 at 8:59 am
What error did you get if you happen to rememeber so I can test for this and correct the script?
"Don't roll your eyes at me. I will tape them in...
April 11, 2002 at 8:41 am
Saw your code in the other thread before it disappeared but try this.
/*
*This should work fine in making sure they are unique and get changed.
*Also this works...
April 11, 2002 at 6:04 am
On your first backup also are you doing a FORMAT for the media with INIT.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 10, 2002 at 6:14 pm
SOme reasons these might fail are , truncate log on checkpoint is flushing the logs (rare but does happen to throw errors for this) or bulk insert (no logged transactions)...
April 10, 2002 at 6:11 pm
Or if the field must have an entry, make GetDate() the default of the field.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 10, 2002 at 6:07 pm
Viewing 15 posts - 6,436 through 6,450 (of 7,429 total)