Viewing 15 posts - 1,621 through 1,635 (of 1,790 total)
Jeff,
Have you tried using the sp_attach_single_file_db method. That way you can forget about the log that is giving you fits for now. The attach will recreate the log in the...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 11, 2002 at 3:35 pm
You may have already assumed this but it needs to be a server of the same version.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 10, 2002 at 10:36 am
No, that is valid syntax and it should work fine. Sounds to me like the machine you are trying to write to either doesn't like the permissions that SQL is...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 10, 2002 at 7:21 am
Andy,
I haven't tested this yet but I will be. I had thought that the "two log file, missing one" scenario was one of those issues that you just had to...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 8, 2002 at 8:15 am
The following will work for you;
if exists
(
select name from tempdb..sysobjects where name like '#YourTable%'
)
drop table #YourTable
Hope this helps.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 29, 2002 at 3:38 pm
I would try a restore of the MTSDE database from a backup off the other server. Sounds like master is not referenced right to that db and the only way...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 13, 2002 at 1:45 pm
Just to make this nice and clean the solution they provided for Neil worked for me as well. See the post that is referenced in my previous post for more...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 6, 2002 at 9:27 am
Well, it appears that the fix they gave to Neil is going to work for me as well. Although, not to give bad press, it seems like they were hesitant...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 6, 2002 at 9:24 am
Working on a similar issue as well. Hopefully we can arrive at the same solution at the same time as this is getting old. See the following post;
http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=2348
Nice to know...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 22, 2002 at 2:56 pm
Cancel that. Had to try it once more with xp_sendmail and it failed. Thanks again. I may burn an MS call on this one. Thanks.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 23, 2002 at 3:37 pm
I attach the results of a sum query for customer review. What is the article num?
Not sure that I will need it because after running the Office SR1 update...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 23, 2002 at 3:35 pm
No helpers, no changes, and no on the MTS usage.
The only thing that is even a remote possibility is a network outage over the weekend affecting that server but,...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 23, 2002 at 3:12 pm
Jody - I probably should have made this clear before and looking back at the posts, it doesn't appear that I have. Each time I restart the services, I am...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 23, 2002 at 2:47 pm
Yes on the account. This is a previously working installation that has suddenly decided to fail. Did verify account was working properly and reset all services appropriately.
Not sure how...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 23, 2002 at 2:29 pm
More notes on this issue;
Once a mail task fails I can't repeat can't kill the process. Once I stop SQLServerAgent, it won't restart, stays in starting mode perpetually. Have...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 23, 2002 at 2:17 pm
Viewing 15 posts - 1,621 through 1,635 (of 1,790 total)