Hello Gila,

Is this not a valid command to run?

Below the code I wrote to run tlog bkp when the full bkp job runs..."was testing in my local place".

EXECUTE [servername].[master]..xp_cmdshell 'BACKUP...

Thnx

:w00t::w00t:

🙂

Thnx...That is how it works. I will pass on the links to d other db champs..

Very Nice Question!

Nice Question - Thanks Steve!

DDL triggers do not fire in response to events that affect local or global temporary tables and stored procedures.

HI Steve/Gila

Any suggestions pleaase

Nice Easy question. Thanks Steve

Any advise may be?

Awesome. It all depends upon case to case. Perhaps, I too don't believe that it is a mandatory flag to enable in all SQL Servers.

Any further advise by other experts?

So if that gives most benefit to tempdb, whether there is any symptom of high tempdb usage, can we go ahead and apply that? I was wondering that trace flags...

Thnx ScottPletcher...

It worked for me. Thnx guys..

I wanted to generate databases with auto seq no.