Search results for query: *

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...

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

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...

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...

I forgot to mention, we are running SQL Server 2005

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 :-)

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...

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...

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...

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

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...

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...

2005

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

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...

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...

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...

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...

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

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...