RE: DTS package password
Asfar as I know, there is no way to do this. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-08-01
SQL Source Control
RE: delta processing: alternative to cursor
Jay, This is the code for the set based update statement: declare @row int, @increment int, @start datetime, @update_count int set @start = getdate() set @row = 1 set @increment = 5000 set @update_count = 0 set rowcount 0 while @row <= 5000 begin update [claims_2002] with (tablockx) set mdl_yr = left(col001,4), vin_cd = col002, […]
2003-07-30
2003-07-29
1 reads
RE: procedure
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-07-25
RE: Table Changes Don't Take
Hi scking, quote: I've recently created a SQL Server 2000 database which allows changes to some of the tables but not others. The public role is set to allow changes to all the tables. Any assistance would be appreciated. just out of curiosity, what are you doing this for? Are temporary tables an alternative? Cheers, […]
2003-07-22
RE: Snap Shot Replication
Also think that transactional would be the best. You will only have to create a snapshot one time, and also with transactional replication, you can configure the snapshot agent not to lock the tables that is bcping out, because it uses the log reader. Remember that transactional will only replicate the transactions made to the […]
2003-07-17
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers