A simple reboot.....I found a lot of people on google groups talking about this. A couple of them said it was a conflict between the cache on the controller and disk. Problem occured while doing a check point. Any normal reading of the page was ok. Anyway, rebooted, changed from simple to full and backed up […]
2005-03-10
You can rename indexes and other objects:use pubsif object_ID('test_rename_HIS') is not null drop table test_rename_HIS if object_ID('test_rename_ARC') is not null drop table test_rename_ARCcreate table test_rename_HIS (ID int Not Null constraint PK_HIS Primary Key, Name varchar(255))go create index I_HIS on test_rename_HIS (Name)go exec sp_rename @objname = 'test_rename_HIS' , @newname = 'test_rename_ARC' , @objtype […]
2005-03-08
Can anyone tell me why example #1 fails, but example 2 and 3 will run?--Example 1: DOES NOT WORK DECLARE @tmp1 TABLE (RID INT IDENTITY (1,1) NOT NULL, EmpID CHAR(9), PubID CHAR(4), Amt1 DECIMAL(9,2), Amt2 DECIMAL(9,2), f1 CHAR(2), Pct1 DECIMAL(9,2), Pct2 DECIMAL(9,2)) INSERT @tmp1 SELECT e.emp_id, t.pub_id, 0, 0, 'A1', 0, 0 FROM employee e […]
2005-01-14
1 reads
First you should remove all the subscriptions to the publication (check sp_dropsubscription, sp_subscription_cleanup, sp_droppullsubscription), then you should drop the publications (with sp_droppublication) and then you can disable replication in the distributor/publisher, you should use the wizard here.Check in BOL for exact parameters.
2004-10-20
2004-09-28
1 reads
Which VPN? I'm not sure the overhead is substantially worse in one v the other. I'm sure a hardware VPN works better than PPTP in software, but bandwidth is likely the big limiting factor. What type of connnections do you have?
2004-09-03
I was able to serve at his second inaugaration while in the military. I was proud to serve in the military under him. It hasn't been until I grew up a little more to finally realize what an incredible man he was who had clear ideas of right and wrong and was able to work […]
2004-06-08
Look into the command line switches for MSDE2000 setup. I believe DISABLENETWORKPROTOCOLS=0 will install MSDE with tcp/ip enabled. Mike
2004-05-28
By Steve Jones
mottleheaded – adj. feeling uneasy when socializing with odd combinations of friend and family,...
By Rob Sewell
In the WordPress community, badges aren’t just for scouts.
By James Serra
The new data governance features in Microsoft Purview are now being made generally available...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers