Pre-summer Sale - Save hundreds of dollar$ now - 15%Pearl Knowledge Solutions, Inc. is having a Pre-Summer Sale! From now, through July 15, 2004, we are offering a 15% (fifteen percent) discount on SQLCentric server license kits, which will save you hundreds, even thousands, of dollars on the cost of monitoring your SQL Servers.For more details […]
2004-06-08
1 reads
I think the troubleshooting steps already given will help you isolate the problem.As a side note, SQL 2005 (Yukon) will have an SMTP based mail solution which will eliminate the need for Outlook on your SQL Server and the associated problems of MAPI running in the SQL address space.
2004-06-08
Presumably you have an ordering sequence?Without details of your table structure the only way that I can think of doing it is by using a cursor, however I would tend to do running totals in a front end app, rather than within the stored procedure.
2004-05-20
Hello!Is it possible to have a delete syntax in sql with inner join inside it? it's possible in access - so I can't make it work in SQL. Am I right about this one. Here is the Access syntax - was hoping anyone could help me to do this in SQL!sSQL = "DELETE PIPES.*, ITEM.SWCode […]
2004-02-04
re: Scripting tools, if you have the SQL Server Resource Kit there is a MetaDataScripter that is an (VB6 dll) add-in to the AS (MMC) console and generates VBScript file/s that can be used to recreate the scripted object.
2004-01-04
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