Viewing 15 posts - 1,381 through 1,395 (of 1,790 total)
I would push a bit harder with the vendor. Theoretically (I would not do this) you can run the OS on SAN storage so, if they are accepting this as...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
July 17, 2008 at 3:07 pm
Have you disabled that server from being a distributor yet? Right click on replication folder, "Disable Publishing and Distribution"
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
July 17, 2008 at 11:10 am
You should start looking at the execution plans (from SSMS Query>Display Estimated Execution Plan - or - CONTROL L) and the DISK IO (SET STATISTICS IO ON / OFF). Additionally,...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
July 17, 2008 at 11:07 am
There are many questions to be answer prior to coming up with a solution so, any input you can provide to the following will greatly aid those in providing recommendations....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
July 17, 2008 at 11:04 am
sultankahut (7/15/2008)
Cannot connect to...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
July 17, 2008 at 4:32 am
Just to make sure the horse is dead...
You should also be able to see the trace start / stop in the SQL Server Log.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
July 16, 2008 at 8:20 pm
Sounds like your SQL Server instance is part of a cluster and the service broker service is one of the clustered resources. If so, then that would be pretty standard...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
July 16, 2008 at 7:41 pm
As with anything related to business, it has to be about the bettering the company. I don't say that with any malice, that is just economics. No business is in...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
July 15, 2008 at 9:50 pm
You really shouldn't have any issues changing the model. I haven't had to go from 65 to 80 but I have gone from 70 and have had no issues.
It...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
July 15, 2008 at 1:48 pm
Agree Jeff. That would definitely keep me sharp... Just might have to try that soon. :w00t:
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
July 15, 2008 at 1:45 pm
Well, testing revealed that you can't do this. I was unable to add columns to the subscriber table. Sorry, new to merge replication.... : )
I guess it is a...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
July 15, 2008 at 1:02 pm
If you can post the code that would help a lot in providing an answer. Thanks in advance.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
July 13, 2008 at 5:21 am
Yes, you will have to walk through the Windows feature install to get IIS installed but then you should be all set. When you go through the reporting services install...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
July 13, 2008 at 5:18 am
There are a few things unclear from your post so, a few questions along with a few inputs;
It appears that you are able to present storage from your new...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
July 13, 2008 at 5:11 am
You can use sp_who2 to get all processes and any that are blocking will be in there. There are several variations of how to handle that output to get the...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
July 13, 2008 at 4:53 am
Viewing 15 posts - 1,381 through 1,395 (of 1,790 total)