Search results for query: *

I ended up running the job in two steps, step one runs sp_spaceused on the 12 tables I check and sends the result to a file. Step 2 sends the results file to me (see below). EXEC xp_sendmail 'e-mail address', @subject = 'space used results', @attachments = 'E:\Program Files\Microsoft SQL...

Thanks that worked, but I had to put in WITH COUNT_ROWS. Syntax; DBCC UPDATEUSAGE ('<DB>','<TABLE_NAME>') WITH COUNT_ROWS Thanks, Manny

I DTS data from sybase ASE to SQL server2000. When I check the row size on the two tables using sp_spaceused I get diffenent results than using select count(*). I disconnect from the SQL server to make sure I refresh. Sybase contains the correct row count, the SQL row count is always lower with...

I have a job setup that runs sp_spaceused. How can I e-mail the results of the job?

Thanks guys

Greg, That worked!! Thank you. The next question is why. What does the 112 do? Manny

Hi guys any more ideas? Thanks

sp_help history_master Name Owner Type ---- ----- ---- history_master dbo user table...

Tried this too. select date_index from history_master where date_index = getdate() It returned column heading, but no data. I also tried, select date_index from history_master where date_index = convert(char (8),getdate()) It returns, date_index ----------...

Tried it, got below error. select date_index from history_master where date_index = today(*) Server Message: Number 195, Severity 15 Line 3: 'today' is not a recognized built-in function name.

I have a simple select statement (see below). All i want is to pass the current date as an argument in my where clause. below does not work. Any ideas? select date_index from history_master where date_index = (select getdate()) Thanks

http://manuals.sybase.com/onlinebooks/group-as/asg1150e/sag/@Generic__BookView/39873;cs=default;ts=default This should help you out.

0 0,4,8,12,16,20,24 * * *

I'm still getting the same error.

I get the msg. &quot;Arguments too long&quot; when I run below script. Can someone help? Thanks find /tmp/edi/imp/mci/* -mtime +30 -exec rm {} \;