Viewing 15 posts - 16 through 30 (of 68 total)
got it....
DBCC SHRINKFILE(<DatabaseName>, 1)
BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY
DBCC SHRINKFILE(<DatabaseLogName>, 1)
August 5, 2003 at 1:55 pm
i thought you had to enter in a certain order repeating one action twice.
August 5, 2003 at 1:50 pm
Nevermind this , i will use PC Anywhere to hit the server instead of installing Query Analzyer , thanks
matt
June 19, 2003 at 7:05 am
wehre do i find the registry to change it? i will post the log tomorrow. thanks
June 18, 2003 at 3:48 pm
I run the installer, click SQL Server 2000 Componets and then click Install Database Server (not Anaylsis services). Then i get an error...
"Microsoft SQL Server 2000 Standard Edition...
June 18, 2003 at 12:26 pm
this happens when executing a vb ap that is hitting the db
June 3, 2003 at 5:45 am
where do you make it? is it a stored procedure?
May 30, 2003 at 12:17 pm
narrie, does you code actually create and send email using a trigger?
thanks,
matt
May 30, 2003 at 11:42 am
narrie, does you code actually create and send email using a trigger?
thanks,
matt
May 30, 2003 at 11:42 am
i want to create a procedure that shows deletions, just like this.
May 30, 2003 at 11:19 am
Viewing 15 posts - 16 through 30 (of 68 total)