Viewing 15 posts - 2,731 through 2,745 (of 6,216 total)
Does is make sense to replicate the data then? How about just setting up a linked server to the publisher, creating a view? Or how about putting it in a...
January 7, 2003 at 5:03 am
I think the code is ok, but I think you need to consider if the user really cares. If Joe was already in the list and they add again, when...
January 6, 2003 at 6:54 pm
Sure. Following code should do it. The owner name seems to be case sensitive.
Dim oserver As SQLDMO.SQLServer
Dim odb As SQLDMO.Database
Dim otable As SQLDMO.Table
'create standard server object first
Set oserver = New...
January 6, 2003 at 3:47 pm
Books Online shows you how. Look in EM under security, has a nice GUI for doing it.
Andy
January 6, 2003 at 2:21 pm
Sorry, log jam just an expresssion. Dont think worker threads matter. 48 in a day way too many. TDS runs (I think) on top of TCP. I'd be surprised if...
January 6, 2003 at 11:52 am
Havent tried it, but it should be doable. The log jam will be in the distribution agent posting changes to the subscriber, you may need to decreate the batch and...
January 6, 2003 at 8:00 am
Merge should handle it for you. It adds a guid to the table to make sure its unique and it has a facility for handing out identity ranges to subscribers.
Andy
January 6, 2003 at 7:57 am
Ebook/CD is possible. We'll go the extra mile on copyright, no author approval, it wont go to print. We'll try to make a little profit to cover hardware upgrades, etc.
Only...
January 6, 2003 at 7:55 am
Copyright is an issue. Between Steve, Brian, and myself we have about 120 articles from last year. Other authors hold the copyright to their own, we would have to get...
January 6, 2003 at 5:57 am
You sure the proc name is correct? Could have wrong db, wrong owner (remember the default tries the specified owner (or dbo), then you, if not found, quites), proc name...
January 6, 2003 at 5:00 am
You should be able to run the job using sp_start_job. Shutdown doesnt work in a proc (or in a transaction, according to the error message). Possibly you could use xp_cmdshell...
January 5, 2003 at 2:53 pm
We've got a few posts here on the site about this issue. All have their merits, comes down to your specific needs. I use replication because I also use it...
January 5, 2003 at 9:41 am
You can't use VBS directly, the best you can do is either run it via xp_cmdshell, or if you compile to a dll, you can use the sp_oacreate and related...
January 5, 2003 at 8:21 am
I'd check the compatibility level one more time, no other reason for it not to work.
Andy
January 5, 2003 at 8:20 am
There are two settings, one for connection timeout and one for command timeout - you've set the command one?
Andy
January 5, 2003 at 5:34 am
Viewing 15 posts - 2,731 through 2,745 (of 6,216 total)