Viewing 15 posts - 16 through 30 (of 94 total)
The result for this is now zero, having ran the update. I know it has not done a blanket update on the whole table as there are many more...
February 16, 2009 at 9:21 am
Yes, it is a 3rd party app, so I can't tell what access rights the .NET prograsm will have. It doesn't seem to be causing any problems as such...
October 27, 2008 at 3:15 am
Thanks for this. It looks as though it may be an application which is opening and closing connections to the database constantly. When that happens it runs sp_reset_connection,...
October 23, 2008 at 8:41 am
Many thanks.
Now all I need to do is get my linked server working!
September 2, 2008 at 7:44 am
Forgot to say, I know there are a lot of posts around this topic in this forum, and I don't wish for people to repeat everything, but I couldn't find...
September 1, 2008 at 7:20 am
Thanks for this. Apparently there can be problems with detaching and re-attaching, but in the end I used the Import wizard and made sure I specified all indexes etc so...
September 24, 2007 at 2:03 am
Hi,
I have now tried to use the copy database wizard to move the database (I have done this on a test server which does not have replication, to keep it...
September 20, 2007 at 7:42 am
Thanks for that. Don't know why I thought that wouldn't work - it just seemed too simple somehow!
Thank you!
July 18, 2007 at 3:59 am
That's the one! Lovely,thanks. Just couldn't quite squeeze it out of my head, and didn't know where else to look!
June 11, 2007 at 6:42 am
Many thanks for this. I'll have a think around it and see what will work best for us.
Thanks,
Paula.
April 18, 2007 at 6:13 am
Ok, it's fixed. I changed the SQLSERVERAGENT login to a standard login which exists on both servers, and changed the scheduled owner on the job, and also added that same...
February 6, 2007 at 7:27 am
Ok, I checked the security. It is 'Be made without using a security context'. I have three local logins set up, all with remote user and passwords for the Oracle database.
Any...
February 6, 2007 at 6:29 am
Ok thanks for this. I checked and it just has System Account ticked. It won't allow me to change it to sa. So I'm still not sure how I check...
February 1, 2007 at 4:24 am
Viewing 15 posts - 16 through 30 (of 94 total)