Viewing 15 posts - 61 through 75 (of 104 total)
I have a similar requirement. Having provided an emailing ability for my client using xp_sendmail, they are now talking about needing formatted output, for example using HTML.
Is there a...
August 29, 2002 at 8:21 am
No - reverse your comparison operator !!
So change <= to >=
Actually, I wouldn't ever SELECT * from a table - better to use a column list, which you can...
August 23, 2002 at 4:27 am
Well actually I wouldn't declare the variable either, just put the expression in the SELECT statement - saves code and overhead of variable declaration as it's only being used once....
August 23, 2002 at 4:14 am
I just went to their site for the first time. It definitely mentions SQL Server, so I see no reason why not, but I haven't looked at all the...
August 23, 2002 at 3:20 am
This is not a recommendation!! Try a look at : http://www.storesmarter.com (Princeton Softech), they advertise in SQL Server magazine. This is an Active Archiving solution - not...
August 23, 2002 at 2:52 am
I'm afraid this is going backwards - you just don't need line numbers any more. Gone are the days of GOTO and GOSUB...
Regards
Simon
August 22, 2002 at 1:55 pm
One thing I would add which you need to be aware of is that putting multiple queries in a stored procedure like this is OK, but unless you use the...
August 15, 2002 at 5:02 pm
There was an article about this a while back, I think it's on the SQL part of microsoft.com as a white paper. Basically, because you're offloading the processing of...
August 13, 2002 at 5:04 pm
This seems a trivial sort of request - there must be a good reason for it? The simple answer is that you need a parameters table and a column...
August 13, 2002 at 6:11 am
Be very, very careful!! SQL's support for COM is not very good at all, and in my experience is extremely unreliable. Oh the COM works, and you get...
August 12, 2002 at 5:28 pm
All things are relative!! I don't call 30 stored procedures a large application, even mine with 750 stored procedures is not particularly big I don't think.
The short answer I...
August 9, 2002 at 12:18 pm
Caveat!! Caveat!! I am *not* an AD expert, however...if you go to: Domain Controller Security Policy in Admin Tools, then open the tree: Windows Settings...Security Settings...Local Policies...User Rights Assignment, scroll...
August 8, 2002 at 10:16 am
Some more on this, having this time expected my overnight proc to fail...
I get error 18031, which according to the KB means that xp_sendmail cannot send mail to a "personal...
August 7, 2002 at 4:51 pm
Sounds like something that should be co-developed with a US partner, regardless of how good they really are.
This might be who you spoke to :
Eyal Aharon [Eyal@incepto.co.il]
Simon
August 6, 2002 at 4:10 pm
Ah, I never got as far as asking about pricing...
That is rather a lot for something so proprietary. Did the developer say anything about service level agreements and guaranteeing...
August 6, 2002 at 12:24 pm
Viewing 15 posts - 61 through 75 (of 104 total)