novalhendra, if you want actual "Real-Time" updates I have no idea how you would do that across platforms. The best I could do would be to do updates to the data on a regular schedule. DTS would be the obvious choice for this, but you may need some additional sybase plug-ins. cl
2003-08-11
I donn think SQL server places lock on the parent table if the child table is being updated.If that is the case then there would be too much of load on the server. Correct me If I am wrong. Relationships are like Banks.You Invest the Principal and then get the Interest.
2003-08-08
2003-08-08
If they are using cdonts for mailing you should check to make sure they are cleaning up the objects correctly in the stored proc. You can also change the procs to run "in process" or "out of process" meaning whether it spawns within the sql server process instance or out by itself. It's been awhile […]
2003-08-01
1 reads
found a round about Update the sysobjects and set the xtype to 'U', add the trigger and set the xtype back to 'S'
2003-08-01
1 reads
You can always convert a varchar field to a decimal field.I have tested this by creating a Test Table with a decimal field with length=5,precision=9,scale=3. And then running the follwing query: insert into <test_table>(<col_name>)values (CAST('121212.3' AS decimal(9,3))) In this case 121212.3 is a varchar value.And it is working fine.I think it will help you to […]
2003-07-30
If the databases are the same, and therefore the stored procedures are also the same, depending on the complexity of you application model (i.e. n tier architecture) you could simply change the database that you asp calls the sp from and run the same thing twice. If your app is a relatively straight forward one, […]
2003-07-30
Rather than using the drop down list, can you try typing in the same parameters and credentials that the server is registered under in Enterprise Manager? Cheers, - Mark
2003-07-29
You have to be a sysadmin to start it up, according to this page: http://dbforums.com/arch/71/2003/6/832887 also, this KB article says something about the Certificate Authority name... http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q302/4/09.ASP&NoWebContent=1&NoWebContent=1 any help?
2003-07-28
2 reads
Jpipes, thanks for your reaction, but I don't think that's the issue here. I tried it remotely and logged on locally. At least after restarting the machine I would expect the SQL Agent to start.
2003-07-28
1 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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