Create the stored procedure on the server where the linked server is created. Access all the data from the linked server in the stored procedure. Call the stored procedure from asp.net.If I have understood your question correctly this should do the trick.Yash
2005-03-21
Hi,So you see these grayed options on the server where you are not local admin... In this case it should be so. If you want to change these options you must be one of the local admin. I tested it on my servers
2005-02-14
Sounds like you've already gotten some good advice. I would suggest that you might want to make your Broker & Assistant tables date sensitive, i.e., with a StartDate and EndDate. This way you don't loose any data when an Assistant is promoted to a Broker status you just record the EndDate as an Assistant and […]
2005-01-21
NOT ALL numbers can be EXACTLY REPRESENTED in the FLOAT format and you may get errors if you try to compare floats to integers.The safest bet if to use the same TYPE for comparison purposes
2004-02-16
You can eliminate the drop table statement by chosing the formatting tab and removing the top two check boxes.For dropping the indexes you will again have to use the sql Drop index table_name.index,table_name.index but they can go in one line Hope it helpsThanks
2004-02-16
Using a monopoly in one market to influence competition in another is not illegal. It's only illegal if and only if the consumer is negatively affected. Now, that's something that can be argued about. For instance, if I'm the only one to make a particular product in a niche category, it isn't illegal for me […]
2004-01-30
I would like to grant some of the developers access to see the scheduled jobs under SQL Agent, without granting them permissions to create or delete jobs. I made changes to our security to not to allow anyone to create DTS packages or jobs, following standard SQL Server security guideleines posted at this site. Only […]
2004-01-29
2 reads
You could use an INSTEAD OF trigger and check the text column(s) using IF UPDATE() and then joining the table to deleted on the primary key and sending the text value to the log table. Then just do the update and other logging operations in the subsequent trigger code. If you use WRITETEXT to overwrite text […]
2004-01-07
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