Viewing 15 posts - 661 through 675 (of 687 total)
I had tried that when I ran into the same problem. Unfortunately, that fix didn't work for me. That's the reason I installed the standalone to get the browser account.
June 29, 2010 at 12:22 pm
Without knowing the application, if it uses an ODBC connection you can add a mirror database server through the ODBC configuration in windows.
If the application uses an ADO .NET connection,...
June 29, 2010 at 12:20 pm
hehe, I couldn't wait to use this answer 😀
It depends.
It depends on whether or not you are using a witness in your setup. With a witness, High Safety, either mirror...
June 29, 2010 at 6:15 am
Don't delete it from the registry, you'll just get yourself into more trouble.
A clustered instance cannot be removed through add/remove programs. You must use the installation media. Once you start...
June 29, 2010 at 5:55 am
Use the GUI, worry about scripting it later.
Start with the principal. Right click > tasks > mirror, click configure security. The wizard will walk you through specifying each database (and...
June 24, 2010 at 9:53 am
you had it right the first time.
1.full then log backup on principal.
2.restore full then log with norecovery on mirror
3.establish mirroring
when you restore with norecovery, the database will be in a...
June 24, 2010 at 6:33 am
I think you're having the same problem I ran into a while ago.
I had a 2005 standalone on server A. I then wanted to install a 2005 cluster on server...
June 24, 2010 at 5:45 am
SSMS is not a clustered tool.
Trying using the "Install a Standalone" and just choosing SSMS in the shared feature group.
June 17, 2010 at 7:48 am
Double post.
Please do not reply in this thread.
Direct replies to
http://www.sqlservercentral.com/Forums/Topic938797-391-1.aspx
June 17, 2010 at 6:40 am
With the fear of answering this "wrong", I'll throw it out there anyway.
When I try to use a database dynamically, it's usually within a procedure. Then I can use dynamic...
June 15, 2010 at 10:56 am
Ensuring your tables are properly indexed and using inner joins where possible would help performance.
I'm pretty sure it's very dependant on the structure of the tables and the format...
June 8, 2010 at 5:29 am
perhaps posting the trigger script will get you more feedback? This will make it easier to troubleshoot your problem.
June 3, 2010 at 10:54 am
I apologize for not being able to explain in detail how to accomplish this, but it seems like you might be able to do it with SSIS.
Create a package that...
June 2, 2010 at 10:17 am
Might you be able to right click and script the job? Then just run the script through SSIS or run it manually on the server?
good luck
June 2, 2010 at 8:51 am
Viewing 15 posts - 661 through 675 (of 687 total)