Viewing 15 posts - 2,266 through 2,280 (of 6,216 total)
You have to do explicit denies on each. Generally you want to do the grant/deny on a role, then drop the users into a role.
Might look in the script library,...
April 16, 2003 at 11:24 am
Not answering your question, but I like deleting x records at a time. Delete a million records in one transaction, transaction log gets huge. Better to do in chunks.
Andy
April 16, 2003 at 8:24 am
I dont have sample code handy, but there are a couple ways. One is to just poll the folder in a job, if you find a file, start the package....
April 16, 2003 at 8:21 am
Yes, triggers are set based. Ideally you write your code to do what you need in a single set based operation, but there are times when you need to process...
April 16, 2003 at 8:16 am
Agreed. Use dynamic without AWE, use static with AWE.
Andy
April 16, 2003 at 7:12 am
You can do add/drop using sp_repladdcolumn/drop column.
Andy
April 16, 2003 at 7:10 am
My real answer is I don't know - but you could always use OpenXML. Isn't there a bulk load for XML now as well?
Andy
April 15, 2003 at 8:41 am
Read the upgrade docs, then just run the upgrade wizard. Pretty painless.
Andy
April 15, 2003 at 8:38 am
No, it's all or nothing. You could modify the trigger so that it would ignore changes from a particular user or host, that way you could leave the trigger enabled.
Andy
April 15, 2003 at 7:01 am
In most cases there are only two things to worry about. If you've changed the server name, you have to either recompile all your apps, change all the DSN/UDL's being...
April 15, 2003 at 6:01 am
As far as SQL is concerned it works exactly the same. The storage is part of the cluster group, when you install SQL it detects the cluster, you just select...
April 15, 2003 at 5:59 am
Couple different ways you could do it. One would be to replicate the one db back, using either merge or transactional with updates. The other is once you move the...
April 15, 2003 at 5:56 am
Interesting idea. For my money you'd be better off upgrading to Win2K or higher, get a better platform all around.
Andy
April 15, 2003 at 5:53 am
Seems like it might be interesting. We'll put on the list - be patient with us, the list keeps growing!
Andy
April 15, 2003 at 5:50 am
On the contrary, what I meant to say - and said poorly - is that our solution is low tech compared to yours! I've got three production and one dev...
April 14, 2003 at 12:04 pm
Viewing 15 posts - 2,266 through 2,280 (of 6,216 total)