Lowell (12/2/2011)

---

the app probably recognizes the TEXT or IMAGE datatypes.

I've got applications that *think* they are storing in an TEXT column or an IMAGE data field , but i had...

MyDoggieJessie (12/2/2011)

---

Yes there is ample space.

That's what I was afraid of...having to restore from a full backup and basically starting over with logshipping from that database...can I restore...

info 58414 (12/2/2011)

---

Hi,

is there a way to check constraints before the INSERT INTO command is executed?

I would like inserts only valid data before a Bulk Insert fails complete (Rollback). Not...

I wouldn't argue on it... After all it's SSC...

Ooops... it's not WOTD...

No-Hi-Bye-Net

cfradenburg (12/2/2011)

---

There are some very good reasons to use a...

Also...

Performing File Restores (Full Recovery Model)

http://msdn.microsoft.com/en-us/library/ms190710.aspx

Partial Backups

http://msdn.microsoft.com/en-us/library/ms191539.aspx

Backing Up Specific Files or Filegroups

BACKUP DATABASE { database_name | @database_name_var }

<file_or_filegroup> [ ,...n ]

TO <backup_device> [ ,...n ]

[ <MIRROR TO...

cfradenburg (12/2/2011)

---

Dev (12/2/2011)

---

If the DB is really critical and has to be up 24/7 I would be surprised if you say you don’t have any High Availability options...

cfradenburg (12/2/2011)

---

Unless reindex hasn't been doing it's job I'm not worried about internal fragmentation. I'll update this post with how it goes (or if we decide to do a...

Oh Noooo... You tooo :unsure:

I appreciate it very much. It's something we see very rarely... 😀

So you guys don’t want to share your jokes with us :crazy:... BTW which language it is?

Divine Flame (12/2/2011)

---

Yes Log Shipping is possible between SQL Server 2000 (Primary) & SQL Server 2008 (Secondary). However, secondary server would be in "NoRecovery" mode only. If we use same...