Viewing 15 posts - 41,266 through 41,280 (of 49,558 total)
Nicholas Cain (2/2/2009)
ARCServe (and most backup solutions) have an open file agent which allows you to backup files that are in use by the OS or other programs.
That should...
February 2, 2009 at 12:30 pm
john (2/2/2009)
I need to add this records quickly and I don't have time to add the UI right now.
Use a query window and write insert statements?
What's the definition...
February 2, 2009 at 10:57 am
Nested triggers means that an update to a table in a trigger can fire triggers on that table, providing it's not the same table. So, say you have Table1 that...
February 2, 2009 at 10:56 am
karthikeyan (2/2/2009)
whether choosing 'DB' as a research topic is the best option or not. is there any limitations in choosing...
February 2, 2009 at 10:50 am
john (2/2/2009)
To be clear I am not doing this via code. I am typing directly into the table row.
Why?
Any triggers on the table?
February 2, 2009 at 10:45 am
idrees.butt (2/2/2009)
am I supposed to read the whole book or just the relavant chapters? which are relavant chapters?
Since you're new to this, read them all. The books are...
February 2, 2009 at 10:35 am
Marios Philippopoulos (2/2/2009)
Wow, would the trigger feed on itself that way? I hadn't thought of that...
That's only possible if recursive triggers are enabled. It's a database-level option and it's disabled...
February 2, 2009 at 10:23 am
myst.black (2/2/2009)
February 2, 2009 at 8:02 am
I'd also recommend T-SQL Fundamentals by Itzik Ben-Gan. I've only glanced through it, but it looks good.
February 2, 2009 at 7:59 am
2 Tim 3:16 (2/2/2009)
"If the page has not yet been updated on the source database, a read operation on the snapshot reads the original page from the source database".
Yup. That's...
February 2, 2009 at 7:53 am
2 Tim 3:16 (2/2/2009)
I'd like to just add that only changed pages get read from the Snapshot. Non-Changed pages still get read from the original database.
Unless I'm badly misreading,...
February 2, 2009 at 7:12 am
Chris Morris (2/2/2009)
Gail - nice weapon! Horrible haircut:P
I'll change the avatar back in a few days. That's the second comment about the haircut.
Funny thing is, it's not far different from...
February 2, 2009 at 7:09 am
Arun (2/2/2009)
For this when we configure log shipping, it contradicts with the backup plan in the production server. Thats the problem. 🙁
Why? There shouldn't be any problem. Take full backups...
February 2, 2009 at 6:30 am
From a quick glance, this doesn't need a cursor at all.
One question - if all 5 of the carrier names are blank, do you want 5 records in the table...
February 2, 2009 at 6:27 am
Viewing 15 posts - 41,266 through 41,280 (of 49,558 total)