Viewing 15 posts - 931 through 945 (of 7,429 total)
I do not believe you can register it thru EM. Although I can't say I have actually tried to see if could be done. Haven't done anything with replication from...
April 28, 2006 at 7:51 am
The fatest way I can think of is open EM, right click th DB and choose "Generate SQL Script...", next press "Show All" button then select "Script All" checkbox. Now...
April 28, 2006 at 7:46 am
I would say it has to be Andy did it in the Yellow office with the spare change in his pocket.
Howevr I am the third gunman on the grassy knoll...
April 28, 2006 at 7:33 am
Generally on see this when package has references the environment cannot resolve.
April 25, 2006 at 1:15 pm
They will be more than happy to lincense SQL Sever 2000 Developers Edition (about $40-$60) or MSDN. No matter your best bet is to call and ask MS to be...
April 25, 2006 at 1:09 pm
From experience the fixes generally now are cumulative post SP. So to goto 878 you need to install SP3a then 878. You cannot go to 878 without SP3a in any...
April 25, 2006 at 1:06 pm
Did you allow nulls then col IS NULL or are you looking to see if = like 0x0000000000000000, in that case you should be able to say where column =...
April 21, 2006 at 8:32 am
I can vouch as well. The key is to make sure you don't have active users in it beforehand. Replication happens to be an active user so you just stop...
April 20, 2006 at 6:57 pm
I actually just went thru a mock test of mine with flying colors. We use transactional replication and I have scripts built to make the DR server 100% equal to...
April 19, 2006 at 3:39 pm
Assuming you are using SQL 2000 you could always setup a trace via the stored procedures or purchase another app such as ProAcitve http://www.whitesands.com/Home/home.htm which is a packet sniffer and...
April 19, 2006 at 12:46 pm
The problem could lie in Supplyrequest_Updateoktoprocessexceptions and not here. Nothing is jumping out to me here.
I would suggest usign Profiler to watch the sql statements ran and the stroed procedures...
April 18, 2006 at 2:48 pm
In your example this join really cannot be improved on by placement in most all cases (this doesn't mean an exception couldn't occurr).
April 18, 2006 at 10:21 am
I concur with David. In fact you should look at past threads on this site about that debate.
April 17, 2006 at 9:44 am
Viewing 15 posts - 931 through 945 (of 7,429 total)