Search results for query: *

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.

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.

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?

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...