Database

Member 10752578 wrote: but how to get the body of the message is what i am stuck with It is one of the parameters to the stored proc. Member 10752578 wrote: which can be triggered when there is failure Might want to be careful with that. One failure is that it just didn't run. If it didn't run there is no way to generate a failure. Safer is to base results on missing successes.

appreciate if you update that post if you have a solution, Thank you so much Technology News @ www.JassimRahma.com

can anyone help please... Technology News @ www.JassimRahma.com

so in this case you pefer to do it through SPs? Technology News @ www.JassimRahma.com

I suggest you get someone to help with your english first. The question needs some interpreting. The forum does not supply service so the someone is not going to happen. Converting between databases will depend on the vendor of the database so know which source and target database is going to help us help you. http://www.sqlservercentral.com/[^] is another good resource for SQL Server and all the big vendors have similar support sites. Never underestimate the power of human stupidity RAH

Marco Bertschi wrote: I was thinking about something that needs a previous authentication, and then SQL commands can be sent... Which is how every database that uses SQL works. The MS SQL Server Management Studio manages the server which is not and cannot be the same as managing a database. Same is true of tools like sqlplus, Toad, MySQL Workbench, etc. One can use those to process SQL but other functionality cannot be controlled via SQL (because that isn't what SQL does.)

Sea_Sharp wrote: My thoughts were to restrict non-techie access completely from the database. Ditto; the Access-frontend would link purely to readonly-views on their own version of the database; a simple restored backup of the production-database (on Sql Server). Then again, most people would not offer Access to an end-user and claim that it's the UI they should work with. Sea_Sharp wrote: I found on the last project, having many people access the database at once resulted in many issues. Yes and no. Access does it's job well, but it was never meant to store a lot of data and be accessed by multiple users simultaneous. A database-server is meant for that job, and Acces isn't a server-application - "just" a desktop app. Sea_Sharp wrote: I guess my wording here was awkward. Sorry for my tone/wording; it'll be equally (if not more) awkward (or hostile) at some points. Sea_Sharp wrote: I know Excel can do it via exports but then it becomes the issue of everyone wasting their time trying to make the reports look professional, consistent, and legible ..aaah, yes, users are resourceful. Sea_Sharp wrote: As mentioned earlier I was completely unimpressed with the UI for Access's report builder but looking around I have not seen any alternatives that seem any better. The Query-Builder looks scary, but is a very powerful tool; combine that with the reporting, and you have a "simple" UI - although others will certainly disagree there. Combine that with the free runtime-version of Access, and you got a UI that will be hard for the end-user to "break". Sea_Sharp wrote: You should have seen how bad our MS Access db got corrupted just by having 2-3 people working on it simultaneously. Yes, especially when they're mucking in the same tables. When moving to SQL Server, be sure to read up on locking and transactions - though the concept does exist in Access, it doesn't help to improve multi-user access. Locking is what keeps the data consistent in a multi-user db, but it also introduces a bottleneck. Sea_Sharp wrote: I mentioned earlier I think it would make a lot more sense to do it HTML and CSS or XML and XSLT for professi

What is the expected average size? How many will there be? What is the estimated growth rate?

Write your own code! Never underestimate the power of human stupidity RAH

Thank you :)

yeah but my questions is how to start with it? if today is 10th April 2014 and I want list of every Sunday until 10th April 2020? Do you I need to loop?! what's the best way in terms of performance? Technology News @ www.JassimRahma.com

Jassim Rahma wrote: Is is possible to create a trigger ON SELECT in MySQL? No. That's why you added the second question, ain't it? Jassim Rahma wrote: If not, any other way to do it? No. You can fetch from a SP and add that functionality yourself. Triggers aren't meant as an audit-trail, that's hardly secure. Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

Quote: passive income online

Sounds like SQLite will work perfect, plus easy integration with PHP should make my life easy. Thanks a lot!

A Quick Google shows me this one as the top reference SQL Comparison for Mango DB[^] Every day, thousands of innocent plants are killed by vegetarians. Help end the violence EAT BACON

You can start by asking the question only once ========================================================= I'm an optoholic - my glass is always half full of vodka. =========================================================

You can't downgrade using a backup file. The only way is to use scripting: How To Convert SQL Server 2008 Database To SQL Server 2005?[^] or some comparison tools like Red Gates's SQL Compare and SQL Data Compare: SQL Compare 10[^] SQL Data Compare 10[^].

Your DataView doesn't contain a column called "name"; it contains a column called "(أسم)". Either change your RowFilter to match the column alias, or change the column alias to match your RowFilter. "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

That is not how the forum works, there are a bunch of volunteers who try and answer SPECIFIC question on a subject. Maybe you can get a book on MangoDB. Never underestimate the power of human stupidity RAH

I'd use a text editor. But why would you want to do that anyway? You'll never get very far if all you do is follow instructions.