Viewing 15 posts - 37,846 through 37,860 (of 49,569 total)
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic749033-147-1.aspx
July 8, 2009 at 12:16 am
Delete that 'fake' ldf that you created and then follow the advice given here.
http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/
The database is recovery-pending because it wasn't shut down cleanly. In that case the log file is...
July 7, 2009 at 2:46 pm
Not all errors roll the transaction back. You should use begin transaction and rollback/commit if it needs to be an atomic operation (all succeeds or none succeeds)
On 2005, Try.. catch...
July 7, 2009 at 10:40 am
frecal (7/7/2009)
I would of thought that when i would of changed my windows password it would update the credentials automatically.
You changed the password in AD. That doesn't automatically mean that...
July 7, 2009 at 10:26 am
GSquared (7/7/2009)
That means you have to force table locks whenever you access it.
Exclusive table locks.
Sequence table has much the same problems as the MAX(ID)+1 solution. Either you get...
July 7, 2009 at 6:57 am
Sudeepta (7/7/2009)
Now, I want to proceed towards the next level of certification MCITP on SQL Server 2005, however, I am confused which track should I choose?
Are you a developer...
July 7, 2009 at 6:50 am
Log shipping really is the way to do this. The only other way I can think of (other than DB mirroring) is to use a 3rd part log reader. However...
July 7, 2009 at 2:36 am
jai verma (7/6/2009)
What is the difference in SQL 2005 RTM and SQL 2005.
RTM is Release to Manufacturing. The original release version of SQL 2005 before any service packs. Logon triggers...
July 7, 2009 at 1:48 am
GSquared (7/6/2009)
GilaMonster (7/6/2009)
Paul White (7/6/2009)
Yr stoopid M$. Yr updats rooning SQL. Im quitting!!!!!11111!!!!!!!🙂
k thx bye
Isn't that supposed to be all one word? (Alloneword, even.)
Depends. I've seen both versions.
July 6, 2009 at 3:23 pm
Lynn Pettis (7/6/2009)
I don't think any further responses are necessary here, but here is an "interesting" omg moment.
I saw it. :rolleyes:
I'd say I'm shocked, but it's hardly the first time...
July 6, 2009 at 3:14 pm
Paul White (7/6/2009)
Yr stoopid M$. Yr updats rooning SQL. Im quitting!!!!!11111!!!!!!!🙂
k thx bye
July 6, 2009 at 3:09 pm
At least the data's recoverable. May I suggest that you play around a bit with point-in-time recovery (and check books online).
July 6, 2009 at 3:08 pm
GSquared (7/6/2009)
July 6, 2009 at 3:05 pm
Do you have a backup of master? What's the exact errors that you're getting? What's in the SQL error log?
July 6, 2009 at 1:04 pm
Viewing 15 posts - 37,846 through 37,860 (of 49,569 total)