Recent content by sfriedman451

I have created a package which uses the datapump to create an excel file from the a table and then sends this by email to clients as an attatchment. I have run this two days in a row now in different forms Run directly from package utilizing execute command Succeeds. Run from command line...

What steps are involved in setting up a trace on A DTS job? Which options do I pick - objects? I'd like to be able to be able to trouble shoot a failing DTS job.

a datetimedata type.

What is the best way to get values in a where clause from a datatime stamp data type without having to enter the full 2002-05-10 10:00:00. Is there a syntax that just allows me to enter a "where = '5/10/2002' or something like that?

I am trying to decifer some code from a trace file run from SQL server 7.0. sp_cursoroption 1232076892, 3, 55 sp_cursor 1232076892, 40, 1 sp_cursor 1232076892, 40, 1 sp_cursoroption 1232076892, 3, 33 sp_cursor 1232076892, 40, 1 sp_cursor 1232076892, 40, 1 Can anyone tell me what the...

It is my understanding that the non-clustered indexes are not automatically updated with new row inserts. Is there anyway to tell SQL server 7.0 how frequently to rebuild the indexes? Is there any way to know when it was last rebuilt?

Is there a utility or something available that can capture the events and description of the event from the Windows event viewer. Right now the only way I can see is to copy it to the clipboard and paste it.

Is it true that If I use the Insert #temp, I have to have already created the schema for it based upon the SPROC. Is there a quicker way to do this without having to manaully figure out the number, length and data types for the columns returned in the SPROC?

There are some great stored procdures that permit me to get meta data about a database. Is there some way that I can filter the results of a stored procedure using a where clause?

Terry's solution works like a charm. Is there a way I can pass what database to use as a parameter in the execute statement. It tells me that I cannot use "USE" in a trigger or SPROC, so to use this I either have give the USE db statement first, or find a way to pass that parameter.

I am trying to create a SPROC to get row counts from all the tables in a database. To experiment I've created one that works (or I should say doesn't work) with the PUBS database. Use Pubs GO Create Table #Tblnames (tblename varchar(60)) GO Select name into #Tblenames from sysobjects where...