|
Hi,
I have an application A which runs a stored procedure. I want that stored procedure to get and send data to another application B. What can be the efficient ways, currently we are using temporary table and using pooling on that table by application B.
Regards
Shajeel
|
|
|
|
|
SQL Server doesn't offer any support for that. If you want to pass messages between applications, and have them persist in the case of software or hardware failure, Microsoft's solution is Microsoft Message Queueing[^].
The temporary table is one solution, but do remember that true temporary tables (named with a # or ## prefix) are stored in tempdb, which is not persisted across SQL Server runs. It is recreated from scratch every time SQL Server starts up. I believe it is also recreated whenever a SQL Server cluster fails over to a different node, though I'm not sure about that.
SQL Server 2005 and .NET Framework 2.0 offer the SqlDependency class, which can be used to send a query to the database and the database to then call the application back when the results of that query would change. For more information, look up "query notifications" in the index in Books Online.
DoEvents: Generating unexpected recursion since 1991
|
|
|
|
|
Thanks for the reply. We are actually using Oracle and VC 6 services and table is not actually temporary, it is simple table but data in it is only stored for message passing and then removed. I just wanted to know whether there is any better solution but it seems like our solution is the best we can get as we cannot modify first application.
Regards
Shajeel
|
|
|
|
|
in my application i'm using sql login to allow the users to log in .in this process i have to send the password and the user name which is risky, through the network , i want to encrypt the password and username,how can i do this,if i use encrypt =true , Is this enough....
|
|
|
|
|
can i protect my sql server2000 data bases (ldf - mdf files)
from attach or open by
password or any thing
ahmed eldeghedy
|
|
|
|
|
What sort of attack are you envisioning?
SQL Server 2000, and it successors are designed to run in a server environment. The access to the machines they are running on should be restricted. The servers will normally be in a secured server room.
|
|
|
|
|
Colin Angus Mackay wrote: What sort of attack are you envisioning?
My guess is that he's concerned that some one might make a copy of the database files and run with them.
Colin Angus Mackay wrote: access to the machines they are running on should be restricted
That would solve his problem...
Colin Angus Mackay wrote: The servers will normally be in a secured server room.
Yes, with machine gun totting security guys and vicious guard dogs :->
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
|
Please keep your replies on the forum.
ahmed eldeghedy wrote: thank you
i am not thanking of that
that is good but that a small thanking some Project like windows base- application (accounting for small company) small to run @ server that make some developer set up sqlserver2000 to the local computer to the company
so that open the data base for any developer
A developer usually has rights to the database anyway. They are supposed to be sufficiently trusted for such access.
|
|
|
|
|
Hi,
I need a help about deletion of records.
I am using MS acces, and using recordset.Addnew() to add records into a table.if iam going on adding records it is adding at end only and the order of records is fine..but if i delete some existing records bu using recordset.Delete(), and then add some records the order is shuffling, and the new records are not added at end. Can anyone explain why it is happening and a solution for the records in order.
Thanks for suggestions
Regards
vijay
|
|
|
|
|
Not sure, it sounds like Access is placing the data where ever it feels like it. Shouldn't really matter from a developer's stand point, as long as the logical correctness of your application is in place.
"Try asking what you want to know, rather than asking a question whose answer you know." - Christian Graus
|
|
|
|
|
I wish to generate a sequence number in vb.net 1.1 based on the record count of a table.If more than one user want to create sequence number as abobe by accesing the same database and table concurrently, the table should be locked for the second user till the sequence number for the first user is created .
Please help me.
J Rasal Doss Solomon
|
|
|
|
|
Rasal doss Solomon wrote: I wish to generate a sequence number in vb.net 1.1 based on the record count of a table.If more than one user want to create sequence number as abobe by accesing the same database and table concurrently, the table should be locked for the second user till the sequence number for the first user is created .
What happens if data is deleted? You will end up with rows with the same sequence number.
The efficient way of doing this is to make column an IDENTITY column that starts at 1 with an increment of 1. If you delete data, however, it will no longer be based on the number of rows as it is based on an increment since the last insert.
|
|
|
|
|
Hi,
I have a description column in database in which description is storing. I want to retrive only initial words.
|
|
|
|
|
How many words? Assuming that the word boundary is a white-space character, you could do some string manipulation with the CHARINDEX and SUBSTRING functions to find the nth word boundary character and then select all the text up to but not including that character.
However this seems more like an issue of flawed design. Consider storing the short description for your text in a separate column rather than deriving it from your long description if you need to query on it often.
Regards
Paul
|
|
|
|
|
I want to delete some postings(records)automatically when it expiry date comes ,those are in the database table.How can i schedule this.I am using sqlserver 2000 and Asp.Net with C#.
Please help me
Thanks in advance.
Krishna Prasad
|
|
|
|
|
Create a DTS task in SQL Server that deletes these records based on the expiry date. Then, you create a job that wraps the task and schedule it to run every day. I don't have SQL Server 2000 installed anymore so I can't give you the exact steps, but it's easy enough to figure out with the aid of Books Online.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
You can create a trgger on insert if this table is not large or heavy used
CREATE TRIGGER trg_DelOldRec
AS
DELETE FROM [tbl name] WHERE DateCreated < DATEADD(mm, -3,GETDATE())
|
|
|
|
|
I have an database application and I want to add a button to Back Up the data, and another button to revert to saved databases(Load Archives). Im using VS Studio 2005, ADO.
I need an explanation of how the procedure of adding this functionality to an application goes.If you use bindingsources, or tablesAdapter and also the SQL statements that achieve this.
Thank you in advance
Is this chair taken
|
|
|
|
|
You want to program using SMO. There is a sample app located in the samples that come with SQL 2005 C:\Program Files\Microsoft SQL Server\90\Samples\Engine\Programmability\SMO\BackRest
|
|
|
|
|
Hi
Can any one out there help me? I have got a database table which contains sessions that are in progress. Each session has a session balance and this session balance is meant to change after every month. The session balance should be deducted by the going rate at the end of every month.
What am I suppose to use and how can I go about this?
Any help will be most appreciated.
|
|
|
|
|
I am using below sql
SELECT CategoryId,CategoryDesc
FROM TB_CategoryMaster AS Category
WHERE CategoryActive=0
ORDER BY CategoryDisplayOrder
FOR XML AUTO, ELEMENTS, TYPE
and output comes like ...
Buy * Sell instead of Buy & Sell... where * stands for amp
How i can handle the same at sql end before sending to client end,,,,
Thanks!!
|
|
|
|
|
Hi,
Can u tell me to download an SQL server 2000 ebook/pdf from the net free?
Can u?
Senthil S
Software Engineer
|
|
|
|
|
I would not ask for that at this website. Many of our contributors have written books. When you download a free book, it is basically stealing.
_____________________________________________
Flea Market! It's just like...it's just like...A MINI-MALL!
|
|
|
|
|
leckey wrote: When you download a free book, it is basically stealing.
Unless the author allows a free watered down version of the book to be available. I don't know of very many who do.
"Try asking what you want to know, rather than asking a question whose answer you know." - Christian Graus
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
