TomThomson (3/27/2016)

---

Yes, this...

Hi Grant,

Hope you are still in this thread,

A few days ago, I tried backing up using 2 files/devices.

What does it really means to do a backup with a mediaset containing...

TomThomson (3/27/2016)

---

Here's one way of looking at it (if you have time for a lot of heavy reading it might be useful to learn to understand it in terms of...

thank you! would greatly appreciate if you can see my 2nd post on implicit transaction - with insert blocking select.

Thanks!

Hi Eirikur,

Thanks for your reply!

So actually SELECT will start a transaction as well...

q1) can you actually let me know what does @@option & 2 means ? ( i know...

Thank you grant!

thank you Lowell, guess I just got to play around with it more.

it seems like some sys.objects are database dependant,

select * from sys.sysusers; -- show only those users in...

Anyone ;~~):-D

Eddie Wuerch (3/22/2016)

---

szejiekoh (3/22/2016)

---

Hi all,

Specifies the TCP/IP authentication requirements for connections for this endpoint.

Does the "for" actually means "to" ?

-- means that client connections to this endpoint must be...

Lowell (3/20/2016)

---

szejiekoh (3/20/2016)

---

SQLSlammer (3/17/2016)

---

Hi,

The answer to the second question is because the sys.databases is marked as a system object meaning it can be called from any database, so no matter...

SQLSlammer (3/17/2016)

---

Hi,

The answer to the second question is because the sys.databases is marked as a system object meaning it can be called from any database, so no matter which database...

Thank you gila!

GilaMonster (3/18/2016)

---

szejiekoh (3/17/2016)

---

Does it literally means that a truncate will happen after a logbackup (provided there is a checkpoint after the last backup) ,but , the truncation will only truncate...

Hugo Kornelis (3/17/2016)

---

szejiekoh (3/17/2016)

---

But given that the checkpoint has run, there might be still uncommitted / active transactions inside the transaction log, can the log be truncated then (even...

Hi GilaMonster,

Nice to hear from you.

Think about it.

If the last log backup truncated the log (marked log records no longer needed as reusable) and now a log backup runs and...