it states

the such as is the tricky part overhere.

I would start perfmon and check...

Good advise Ken Garrett ! 😎

Apart from solving the 4Gb problem, the real question should be ..;

Is it considered normal that a single table can consume 2Gb in a size...

isn't it stating a location for the log files it searches ?

Can you post the results of sp_helpdb 'yourdb'

Which is the location sqlserver is trying to write the audit trace file to ?

By default that would be the sqlserver instance \log folder (where you can also find errorlog,...

Ol'SureHand (2/15/2009)

---

Hope this question does not need its own thread ...

Data warehousing practitioners seem to have a constraint on EVERY single column. The above code will only preserve necessary constraints,...

Back in the days we used to use this before restoring an EUC database:

CREATE PROCEDURE sp_DB_SendAndKill

@database char(25),

@contact varchar(100) ,

@reden varchar(300) = ' ** reden werd niet opgegeven **...

Did you try to use "net send" to the windows users or workstation ids ?

However, in some shops they shut of this service.

Or you could query AD to fetch the...

Did you our SQL Server Configuration Manager to perform the service account change ?

if not... change it back the way you did and then use SCM to configure the...

I don't think the view designer shows up in the connection info of the spid.

So I guess you cannot restrict its usage.

did you read the full MS doc on it ?

http://support.microsoft.com/kb/231619

and the docs it refers to ?

IMO your connection between primary and mirror isn't stable.

Hence the restoring state from time to time.

If it can form a quorum it will pull over the log entries of the...

do you make LOG backups ?

That's the only way to clear the log file entries.

Gail has posted a nice article on this matter.

http://www.sqlservercentral.com/articles/64582/

best is to revoke you bosses ddl-admin privileges :hehe:

Many of our devs use that view-GUI because they find it easy, but then again,they don't get to clean up the mess...

If this is a single shot operation , just to get a little insight, maybe a log-analyser tool can help out. (at least if you have full recovery model).

My guess is , if you want to know exact figures, you'll have to implement a trigger for insert, update, delete and have a counter per PK value in your...