Recent content by TomSark

Why don't you simply create one proc that builds the sql statement you are executing into a varchar variable, then use the EXECUTE statement to run it? You would dynamically build the where clause based on the parameters you pass into the proc. Ex: CREATE PROCEDURE new_proc (@ReportType...

Have you looked at the hotfix for this: Hotfix build 8.00.0601 ftp://ftp.microsoft.com/bussys/sql/transfer/sql80/olap/s80601i.exe Password: 8.00.0601 Please follow the setup instructions in readme.txt Tom Davis tdavis@sark.com www.sarkdallas.com

Ok fine, I'll answer my own post. We have worked with Microsoft and have made a few determinations. Do NOT issue VBA function calls in MDX queries. The Analysis Services parser serializes the sections of the queries (with then select then from then where). This serialization in itself is a...

Hi, SQL 2000, SP2, etc. We are issuing MDX queries via a COM+ object in an ASP application using ADO (not ADOMD). We are noticing major CPU spikes when the component issues MDX queries to the cube. Analysis services reports that queries aren't consuming any time. NICs are OK. We are the only...

BTW... the stats have been computed with full_rescan... Tom Davis tdavis@sark.com www.sarkdallas.com

Hi All, Does anyone know how to get rid of an Eager spool in a query plan? I've got an INSERT SELECT and SQL Server has determined to spool the clustered index on the inserted table to tempdb (using the eager spool step). This is slowing the query way down. I don't want to drop the index...

Looks like a problem with the COM interface (SQL Namespace, SQL DMO, something else?). Coinitialize is a COM method. You may need to reinstall EM. Tom Davis tdavis@sark.com www.sarkdallas.com

I'm missing something here, but I'm guessing that you want to join the ID in a real table to the ID in a temp table, you could try: IF EXISTS ( SELECT R.ID FROM RealTable R INNER JOIN #tblIDs T ON R.ID = T.ID AND R.Amount > 0 ) BEGIN...

Try using brackets arounf the column name as in: SELECT [propnumber] FROM tablename Tom Davis tdavis@sark.com www.sarkdallas.com

What is the owner of the proc and the table? Tom Davis tdavis@sark.com www.sarkdallas.com

If you are having trouble with a date format, you could easily write an active-x transformation in vbscript that deals with this in your DTS package. You could also set up a linked server to your access database and do something like this: INSERT MYNEWTABLE ( GoodDate ) SELECT...

Check out the capabilities of SQL Mail. SQL Server can respond to queries via e-mail and send the results in e-mail as well.. Tom Davis tdavis@sark.com www.sarkdallas.com

BACKUP LOG DBNAME WITH TRUNCATE_ONLY will only remove the inactive portion of the log. The active portion cannot be truncated. And, if you are using an earlier version of SQL Server like 7.0, you may have to fill up a virtual log segment before you can truncate that virtual log. Tom Davis...

SQL 6.5 has a SQL Trace utility... Tom Davis tdavis@sark.com www.sarkdallas.com

And... @@rowcount WILL contain the count of the rows that were deleted when your trigger code begins. I usually set a variable to it in the beginning of the trigger before I have any other code so I don't have to query for the rowcount as stated above... If at all possible, avoid coding...