Viewing 15 posts - 3,721 through 3,735 (of 6,216 total)
July 22, 2002 at 4:53 pm
De's are truly horrible IMO. Just as easy to write just a little more code and no headaches. Anyway, to figure out what should go there you need to examine...
July 22, 2002 at 4:50 pm
Also depends on the complexity of the transactions. Given that you have 24 hours to update I think you'll do better than 10-20 transactions per server before hitting a limit....
July 22, 2002 at 4:46 pm
Sure. The caveat is that you're granting them greater access than they need. If you're ok with that go for it!
Andy
July 21, 2002 at 7:40 pm
July 21, 2002 at 6:47 pm
Havent ever looked, cant imagine letting my users do it! Looking at sp_fulltext_table I see this:
Permissions
Only members of the sysadmin fixed server role, db_owner and db_ddladmin fixed database roles, and...
July 21, 2002 at 6:46 pm
Steve Jones has a series of articles on using strings in TSQL, you should try those, he probably has some ideas. One way would be replace all the search text...
July 21, 2002 at 6:59 am
So the objects were correctly owned by the user? Or you changed them?
Andy
July 21, 2002 at 6:56 am
Have to admit I didnt test it on 200 dbs. I wouldnt use it for 200 anyway, easier to write a little code to detach and reattach, do it all...
July 19, 2002 at 2:40 pm
Dont see why you cant just change the permissions on sysjobs and sysjobhistory. Let them query directly or put a simle asp page that will show them.
Andy
July 19, 2002 at 10:54 am
You cant move system databases using the wizard. You can detach/copy/move both model and msdb if you want to.
Andy
July 19, 2002 at 10:52 am
I wish!
You're just moving the testing from one place to another arent you? It's the same code, only difference is how you get there. Or you could even just pass...
July 19, 2002 at 9:52 am
Interfaces are an in interesting topic to be sure. The advantage that "bigger" languages have is that they can enforce the interface - in VB using the implements statement. That...
July 19, 2002 at 7:01 am
Create a temporary db on the same server, send a snapshot to it, then script out the procs. Dont know if there is a hidden proc in SQL7 that will...
July 18, 2002 at 9:10 pm
How about just turning off the transaction while you debug? I always add them last so I dont have to fight them while working through the design/initial testing.
Andy
July 18, 2002 at 11:27 am
Viewing 15 posts - 3,721 through 3,735 (of 6,216 total)