Viewing 5 posts - 1 through 5 (of 5 total)
SELECT *
FROM ::fn_trace_getinfo(default)
From Books on Line:
If a trace_id is specified, fn_trace_getinfo returns a table with information about the specified trace. If no trace_id is specified, this function returns information...
March 21, 2006 at 6:15 am
Add a new datafile and logfile on the e: drive.
This can be done through Enterprize Manager
right click the database
select properties
Go to the Data files tab
Type in a name for your...
July 11, 2005 at 12:13 pm
After you sucessfully reclaim the log space, back up your trans log regularly. Otherwise your log will grown again. Do not just do full backups- do trans log backups as well.
I always...
June 6, 2005 at 8:44 am
March 5, 2004 at 7:59 am RE: Storing ImagesWe looked into it, and decided to store the file location in the db, and the image outside. Easier! But you can store the image in the database... December 24, 2003 at 6:40 am Viewing 5 posts - 1 through 5 (of 5 total) |