Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: katgirl
  • Order by date
  1. katgirl

    current database and its confiuration

    Hi AlwaysWilling, What you need to tell your boss is - you need to hire a good consultant, plain old. The extra costs up front MORE THAN OUTWEIGH the headache later down the road from having a less-than-adequate system designed by someone who really didn't know what they were doing. Visting a...
  2. katgirl

    Diff Utility in SQL Server?

    AdeptSQL is another very good tool and is compatible with 2000 and 2005 and it works very well, I have no complaints whereas I've had issues with other products hanging
  3. katgirl

    2005 schema question

    from bol: Every database you create has a predefined sys XML schema collection in the sys relational schema. It reserves these predefined schemas, and they can be accessed from any other user-created XML schema collection. The prefixes used in these predefined schemas are meaningful in XQuery...
  4. katgirl

    Job to restart Replication jobs?

    Hi Catadmin, I've never used snapshots myself b/c I don't like the idea of dropping and recreating tables - I think that's how the snapshots work (I could be wrong though). We have this tool called AdeptSQL that allows us to sync by hand when things occasionally go out of sync. Usually it's...
  5. katgirl

    Job to restart Replication jobs?

    I forgot to mention, we are running SQL Server 2005
  6. katgirl

    another annoying lack of features

    I finally got the import done - I have done this exact same import hundreds of time in 2000 - we often have to import data for our clients - but for some reason 2005 does not do it the same way. I was just frustrated is all :-)
  7. katgirl

    Job to restart Replication jobs?

    Hi, In the event that the server that hosts replication goes down and then comes back up - do the replication jobs start automatically? Or say, the SQL Server Agent is stopped and started for any reason? Do the replication jobs re-start? I can't remember. So, my question is, do I need to...
  8. katgirl

    another annoying lack of features

    in SQL Server 2005 why is it I am constantly discovering annoying lack of features in 2005 - that is, things that used to work perfectly fine in 2000 suddenly have no functionality in 2005 take import, for instance - you can no longer import to an existing table... you get an error... so each...
  9. katgirl

    object owner "dbo"

    Hi, I have a developer here, that when she logs into and creates tables in the database, the owner of the table is her login, not dbo. How can I change the settings so that the tables she creates belongs to dbo instead? Or alternatively, she needs to be able to run: execute...
  10. katgirl

    Granting VIEW permissions

    Hi mrdenny, So you're saying - if all the stored procedures are owned by dbo, for example, I need only grant permissions to view the dbo schema? Do you have an example of how to do this? I don't fully understand schemas, but they give me a lot of grief. Thanks much
  11. katgirl

    Help - user permissions

    From my other post: I would like to grant VIEW stored procedure permissions to a user in the database. I would like the user to see ALL the stored procedures in the database, just not change them in any way. So far I have determined I can use this stmt to accomplish this task: GRANT VIEW...
  12. katgirl

    Granting VIEW permissions

    Hi, I would like to grant VIEW stored procedure permissions to a user in the database. I would like the user to see ALL the stored procedures in the database, just not change them in any way. So far I have determined I can use this stmt to accomplish this task: GRANT VIEW DEFINITION ON...
  13. katgirl

    Help - changing services accounts on a 2005 cluster

    thanks mrdenny actually as it turns out, the password not being accepted through configuration manager problem was a group policy issue. the group policy was overriding the local policies, so the password didn't work for some reason... anyhow our ops guy figured it out
  14. katgirl

    Help - user permissions

    Hi, I have a database user with read-only permissions in the database. The user would like to be able to display a list of stored procedures in the database. I would like to grant this user the permission to do this, but without granting permission to *change* the sp's in any way. Is there a...
  15. katgirl

    Help - changing services accounts on a 2005 cluster

    mrdenny, From what i understand, you are *not* supposed to use services to change the service accounts, because certain permissions won't get set... and in fact, the other dba here did just that (as an experiement) and it broke the cluster. It took the password, though... but it didn't help...
  16. katgirl

    Help - changing services accounts on a 2005 cluster

    Hi, Using SQL Server 2005 Standard Edition, sp1 Here is my problem. When I try to use "SQL Server Configuration Manager" on the active node of a 2-server cluster to change the service accounts, I get the following error: "specified network password is not correct" I am trying to change the...
  17. katgirl

    2005 Service Accounts - help

    yes, tricky even the microsoft guy i spoke with today told me to set up the services domain user as an administrator - funny eh. i find that once you understand something in sql server, it's simple - but before that - horribly complicated to the point of wanting to strangle the person who...
  18. katgirl

    2005 Service Accounts - help

    thanks catadmin yes, after re-reading bol, i came to the same conclusions you explain above sysadmin fixed server role - didn't quite register the first time... duh
  19. katgirl

    2005 Service Accounts - help

    Hi, This is a topic that I've researched and researched and still can't find a decent answer to. That is, what permissions are needed for the SQL Server and SQL Server Agent accounts?? To make things more complicated, we are running a 2005 cluster. However, I am assuming you change the service...

Part and Inventory Search

Back
Top