Viewing 15 posts - 31 through 45 (of 77 total)
No, it was running from a batch file.
August 27, 2013 at 5:10 am
You are right: that was the issue then. Fox came afterwards but installing the 32 bit OLE DB fixed that. Now the problem is the following:
Error: 2013-08-27 06:15:11.12
...
August 27, 2013 at 5:06 am
Thanks, but I don't restore master and I am not planning to. Only the user databases will be restored. My guess is that would change the importing of the certificate....
January 28, 2013 at 6:23 am
I am trying to achieve that by replacing those tables with viewes in the other database and granting SELECT access to the common login. That should work but time will...
January 25, 2013 at 3:23 am
But I have found a problem with table value functions and views that go across databases. When trying to ADD SIGNATURE, I get the following error:
Msg 15560, Level 16, State...
January 23, 2013 at 12:52 pm
Please ignore this message, I panicked too fast. It was just a password mismatch. 🙂
January 23, 2013 at 5:38 am
I have found a way that I am currently exploring by using certificates. It is explained in the "Cross Database Access" section of the following article:
January 23, 2013 at 4:06 am
Thanks, that's what I thought but my users insist there is a way other than that. It would save them coding time but... that would be only if that is...
January 22, 2013 at 9:45 am
I am using the Wizard but that is basically what happens.
April 29, 2011 at 8:59 am
That will make it impossible for us to use that new feature because I know that I would not be able to get them to upgrade to Enterprise. We will...
February 3, 2011 at 10:58 am
I sure will but it is kind of difficult to upgrade around here. It might take a year or more before we do that. We still haven't upgraded to 2008,...
February 2, 2011 at 8:54 am
The secondary server is going to be located in the same room. We don't have an away data center.
February 2, 2011 at 8:51 am
I've been considering setting curfews for the extraction that takes the most time to run, which is OLAP. Since it starts at 23:00 and should be done within two hours,...
February 2, 2011 at 8:50 am
I use SQLsafe for my backups and they suggested checking off the disconnect users when doing restores which will prevent the restore from stopping a running transaction but that would...
February 1, 2011 at 5:21 am
What about stopping log shipping restores when processes are running and restoring them after they are complete?
January 31, 2011 at 7:51 am
Viewing 15 posts - 31 through 45 (of 77 total)