Viewing 15 posts - 7,906 through 7,920 (of 9,715 total)
Active / Active has a SQL instance on both nodes. Active / Passive has the instance only on one node. If you have instances on both nodes, you're running A/A...
June 3, 2010 at 5:52 am
It amazes me that someone would expect you to restore backups with no alternative cataloging system to identify this information. Automated backups through the maintenance plan or a third party...
June 3, 2010 at 5:50 am
Depends on what kind of cluster you have set up. If it's Active / Active, then yes, you shouldn't have a problem. If it's Active / Passive, you have a...
June 3, 2010 at 5:39 am
Job_ID is not an int. You have to use uniqueidentifier or char / varchar data types for your variable.
EDIT: And yes, what you want to do is possible. Just adjust...
June 3, 2010 at 5:36 am
Google that first sentence. There are tons of responses from 2008 and 2009.
First one on the list is this one about 64 bit OS patches.
June 3, 2010 at 5:34 am
Check out this link on how to read the dump log. It might help you track down your problem child.
June 2, 2010 at 10:26 am
Check the dump log, and the server's event viewer. What are they saying?
The usual "fix" in SQL 2000 for me (when it came to problems like this) was re-initializing the...
June 2, 2010 at 8:40 am
It's been forever since I've used replication. I have this bizarre, vague memory that there's a setting in one of the properties windows that needs to be set in order...
June 2, 2010 at 8:35 am
I don't know if there will be a problem if you move your databases without changing your SQL Server install from 32bit to 64bit. Have you upgraded the SQL Server...
June 2, 2010 at 8:23 am
Check your server's Event Viewer for errors and warnings from around the time of this error.
June 2, 2010 at 8:22 am
Describ the steps you're taking to read the error log, please.
Also, is the log file hard drive full? Have you recently run a diskscan to verify all the sectors are...
June 2, 2010 at 8:21 am
Tara-1044200 (6/1/2010)
June 2, 2010 at 8:18 am
So I guess the answer depends on how the linked server is setup. I'm betting the impersonate permission is causing your ability to use it.
June 2, 2010 at 8:12 am
Chances are your uninstall didn't uninstall cleanly or completely. Or the install upgraded a SQL Server component. I'd advise googling "Uninstall Deklarit" and see if you find any articles on...
June 2, 2010 at 8:09 am
I don't know what settings Marco used, but I created a Test sql account on a server, using Master as the default and granted no permissions.
The linked server does not...
June 1, 2010 at 11:32 am
Viewing 15 posts - 7,906 through 7,920 (of 9,715 total)