Viewing 7 posts - 46 through 52 (of 52 total)
Thanks for all the tips. I know it is not a timing issue, because I can enter debug and wait as long as i wish, it still will not find...
October 21, 2004 at 12:09 pm
It also may be a mapped drive problem. When you run a DTS package from your system, it runs on your system and uses your client's mapped drives. The server...
October 19, 2004 at 7:20 am
If you are getting rid of ALL data in the table, use the TRUNCATE TABLE command.
October 15, 2004 at 2:30 pm
Thanks! I knew it was a Dummies question, but it was elusive to me.
October 12, 2004 at 7:30 am
I think I found this script on this web site:
--List Table Names and Sizes
declare @id int
declare @type character(2)
declare @pages int
declare @dbname sysname
declare @dbsize dec(15,0)
declare @bytesperpage dec(15,0)
declare @pagesperMB dec(15,0)
create table #spt_space
(
objid int null,
rows int null,
reserved dec(15) null,
data dec(15)...
October 8, 2004 at 7:42 am
I always use BACKUP LOG DataBaseName WITH TRUNCATE_ONLY
Seems to work great for me.
September 17, 2004 at 7:49 am
What about Time zones? I have an Access DB which is 3 hours away. When I add a record and look at the record creation date, it shows me that...
August 27, 2004 at 7:44 am
Viewing 7 posts - 46 through 52 (of 52 total)