Viewing 15 posts - 30,901 through 30,915 (of 39,824 total)
Does another user have the file open on their desktop?
October 31, 2007 at 8:47 pm
Surprisingly, we have more important things. I noticed it and a few people have pointed it out, but there's not really any other choice that makes sense, so hopefully it's...
October 31, 2007 at 8:46 pm
I see the article. What browser are you using? Do you see what's attached below?
October 31, 2007 at 8:45 pm
You want this stuff written to the log. It is how you can ensure that there are no integrity issues, like if the power dropped in the middle of your...
October 31, 2007 at 1:54 pm
I haven't. HAve you checked the security on the files created each way?
October 31, 2007 at 9:19 am
I think I noticed #2 as a bug. The task actually builds the code at runtime and if you delete the databases, you can't undo this. I believe you need...
October 31, 2007 at 9:18 am
I should have remembered that. Good idea, George!
October 31, 2007 at 9:08 am
If you are planning on using SQL Mail, I'm not sure the transaction log comes into effect. The log is used to record changes to data, not mailings, alerts, or...
October 31, 2007 at 9:05 am
The job doesn't contain the steps for the plan. The job just runs a "package" that's set up with the plan. The job is just a trigger for the maintenance...
October 31, 2007 at 8:57 am
Thanks for the update.
Is this strictly a security issue? I'm wondering why someone can be a sysadmin in one db and not another? Are you a sysadmin in the other...
October 31, 2007 at 8:54 am
Antares is right in that you can't determine this after the fact.
You can set up a trace for logins and just track this over time. If you only get logins,...
October 31, 2007 at 8:51 am
Keep in mind a couple facts. Jobs aren't re-entrant, so if two people do this and the job is running for the backup, the second person might not get their...
October 31, 2007 at 8:46 am
The issues with the ZIP file were the editor's (my) fault. They have been corrected and my apologies.
October 30, 2007 at 12:11 pm
Do you mean you're taking a full backup or creating a database snapshot? I assume the former as there is no "snapshot backup".
Is there a particular period of time or...
October 30, 2007 at 12:09 pm
You can also potentially move all the objects from the NDF into the MDF and then remove the NDF from the database. You can move tables by moving the clustered...
October 30, 2007 at 12:07 pm
Viewing 15 posts - 30,901 through 30,915 (of 39,824 total)