Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
sp_spaceused vs select count(*)
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...- mannymo
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Setup and Administration
-
e-mail job results
I have a job setup that runs sp_spaceused. How can I e-mail the results of the job?- mannymo
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Data Transformation Services
-
selecting current date
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- mannymo
- Thread
- Replies: 12
- Forum: Sybase: Adaptive (SQL) Server
-
Arguments too long
I get the msg. "Arguments too long" when I run below script. Can someone help? Thanks find /tmp/edi/imp/mci/* -mtime +30 -exec rm {} \;
