Abdu Rafeeq
alter
@Dbname nvarchar(1000)BEGINDECLARE@qry nvarchar(4000)SET@qry='dbcc shrinkfile('+@Dbname+'_Log,TRUNCATEONLY) 'exec(@qry)ENDbut i got error"Cannot perform a shrinkfile operation inside a user transaction. Terminate the transaction and reissue the statement."how possible?
BEGIN
DECLARE
SET
exec
END
but i got error
"
Cannot perform a shrinkfile operation inside a user transaction. Terminate the transaction and reissue the statement."
how possible?
As