Viewing 15 posts - 31 through 45 (of 69 total)
thanks again
fyi
in case you wondering
http://download.microsoft.com/download/.../SQL2005SecBestPract.doc
June 7, 2011 at 12:00 am
Sorry dude one last thing, I came across this document: SQL Sever 2005 security best practices - operative and administrative tasks
which mentions under Database ownership and trust that not all...
June 6, 2011 at 11:43 pm
Thanks alot, havn't tried it as yet will do though, as there is no developement enviro here only production. Rather gather enough info before I break something. 🙂
Thanks again
June 6, 2011 at 5:01 am
So sorry but confusion has struck, So db owners can be sa but account disabled, but wont disabling the sa account render objects owned by sa unsable.
June 6, 2011 at 4:37 am
Well from what I read, because sa is a widely used SQL admin account, there's possiblities of it being hacked easily. Well would you advise changing owner to sa....
June 6, 2011 at 4:18 am
Thanks alot fo everyones response I really appreciate it, just one last thing to increase my knowledge, You said add the fill factor to 60 -70, can you please let...
February 4, 2010 at 10:16 pm
Thanks I actually told them that, but how is it possible that 4 days later after a defragged the fragmentation occurs again. Does defragmentation have to be done daily which...
February 4, 2010 at 12:28 am
Yes it does delete records, but it deletes records for the current month, and then reloads it
Amount of records deleted for current month = +- 110000 records
February 3, 2010 at 11:56 pm
This table is getting data loaded into t from a DB2 database, yes its a target table
February 3, 2010 at 11:34 pm
Nope they did not have any passwords on the Packages, but I found a solution thanks alot though
December 2, 2009 at 10:10 pm
This is totally unsupported by microsoft and you should only make this modification on a development box.
1. Script the sp_add_dtspackage sproc in the msdb database to a file.
2. Edit...
December 2, 2009 at 4:11 am
Actually managed to grant the TargetServerRole to the User, but I'm still getting the same error
December 1, 2009 at 5:22 am
Your database files yes you'll be able to attach them easily, your system db file I'm not too sure,because your SQL Versions will have to be the exact same as...
December 1, 2009 at 5:16 am
Good day I seem to be having the same problem does anyone have a solution to the problem, I do have virtual directories set up as well as the IIS...
November 23, 2009 at 10:25 pm
Understandable, but what I mean is, like a notification popup when using the production db, a popup occurs warning you that you are on production. Why I ask, is that...
August 12, 2009 at 7:01 am
Viewing 15 posts - 31 through 45 (of 69 total)