Adriaan,<br /><br />I dont need to, the engine does it for me. <img src='/community/emoticons/emotion-1.gif' alt=':-)' /> That's why to use set...
Hey vitaly, <br /><br />Sorry about the delay. Since the post is old - and had no replies - I've stopped checking it.<br /><br />Actually, you are...
Adriaan, Actually I was doing some inserts in a table with a foreign key, whose column was sometimes being set with undefined values. Whenever this...
Folks, I'm doing a big insert (many rows being inserted), and I dont want it to stop the whole process due to a couple of errors. I'd like it to...
Thanx Mohammed, I am gonna check them out!
Yes Satya, it returned "No active open transactions." - before shrinking, dont worry <img src='/community/emoticons/emotion-1.gif' alt=':-)' />. <br...
Thanx mmarovic! This really helped. Using a slight variation of what is used in that thread solved the problem: DBCC SHRINKFILE ('bd_log', 1 ,...
mmarovic, Thanx, but this thread goes much further than what I need or have in mind. It's more about data archiving (and recovery) strategy than...
Thanx Mohammed... The problem is: the initial sizes in model are 3mb for data files and 1mb for log files. Still, some databases kept growing, and...
Folks: Is there a way to decrease the initial size of a database/log file? I've noticed you can increase it, but if you decrease it, after you...
Thanx a lot Adriaan!
Adriaan, thanx for the reply. Actually I didnt know where to post this, and hence a part of the problem is related to performance, I've decided to...
Nobody? Well, thanx anyway guys.
Maybe you can help me folks:<br /><br /> I have 3 tables (for now) which (may) have 0,N phone numbers. <br />* Agent (AgentID, AgentType, etc.);...
Separate names with a comma.
