Allright, I found some stuff in BOL that I modified and I got it to work perfectly with the free ASPEmail from Persists: ALTER Procedure sp_SMTPMail...
In the demoscript provided from sqlteam the object reference is "SMTPsvg.Mailer" while the object reference for aspemail is "Persits.MailSender" and...
Well, in order to use the ASPmail-component you would need to purchase it but I have always used the free ASPEmail instead and I'm quite sure that...
Just a quick question; would using asp/html, sql-server stored procedures and the sql-server be considered as a 3-layer structure?? -- Frettmaestro...
Using Conn.execute in a lopp is something you *definetly* should not do...I'm positive that there are better ways to solve this but some code would...
To elaborate on Chappys post...wouldn't this be possible: CREATE TRIGGER <<TriggerName>> ON GRN FOR INSERT AS BEGIN USE master EXEC xp_cmdshell...
*totally embarassed!*<br /><br />Feel like a total rookie...I managed to do a search after a string that was not present in the test-database, only...
Do I really have to make this into a dynamic sql to get it to work?? ->declare @search varchar(30) -- Method 1: doesn't work set @search = '%up%'...
I must apologize but I was in sort of a hurry yesterday so I aslo posted the same question on dbforums.com and I recieved the following code which...
In my database I have a table called "users" with a varchar-field that holds categori-id's commaseparated, collected from my other table "category"....
This could maybe have been acomplished but the problem is that I don't know the which currency to use at the time of initializing the transaction...
I have an app that uses exchangerates for different currencies that get updated once every day at 3pm from the european central bank. The...
tmarko: search & raplace with regular expressions can work miracles <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br />--<br...
Ok, I missed the part about the 200 formulas actually, I must read more carefully the next time I guess <img src='/community/emoticons/emotion-5.gif'...
No offence Frank, your solution will most definitely work, but I find it to be unnecessarily complicated for the task at hand. The IsNull built-in...
This will do the trick: SELECT IsNull(Field1, 0) + IsNull(Field2, 0) -- Frettmaestro "Real programmers don't document, if it was hard to write it...
Hm, I'm not 100% sure on this but wouldn't something like this do the trick? -> SELECT * FROM sometable WHERE DATEDIFF(m, SomeDate,...
I have never tried this before but I'm still quite sure you can use the following connection-string: "Provider=sqloledb;" & _ "Data...
There you go <img src='/community/emoticons/emotion-1.gif' alt=':)' /> I almost feel stupid for not thinking about this...thanx!<br /><br />--<br...
I thaught I would ease my lazy self off the "hassle" of going through the job history every day and try to get sql-server to send me an email if a...
Separate names with a comma.
