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 gmmastros 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: *

  1. ptheriault

    Refreshing 200+ Passwords

    Using sp_help_rev_logins would have been my suggestion. I don't think you have any other option. - Paul - Experience is the name every one gives to their mistakes.
  2. ptheriault

    xa_start (40000) returns -7 error message coming from SQL Server 2000

    Take a look at this post, it may be helpful. http://forums.bea.com/thread.jspa?threadID=400004068 xa_start is not a sql server procedure. - Paul - Experience is the name every one gives to their mistakes.
  3. ptheriault

    xa_start (40000) returns -7 error message coming from SQL Server 2000

    Have you checked weblogic? That is definetly a weblogic error. - Paul - Experience is the name every one gives to their mistakes.
  4. ptheriault

    Reinstalling SQL Server 2005

    Steve, You really shouldn't give out sysadmin admin rights to users or application logins. That is a very bad practice to get into. Did you delete the Built-in admin user? That login will make all the local server admins 'sa' in the database server. But only if you haven't deleted it or...
  5. ptheriault

    Replication or Transaction log shipping for Reporting?

    Well that gives you another option. I haven't used SAN replication as of yet, but I've heard good things about it and if you have a good SAN admin should be easy to set up. I think Denny could offer you more advice on that than I can. - Paul - Experience is the name every one gives to their...
  6. ptheriault

    SQL2005 Backup Failing When Envoked By Client

    Does the login have one of the following permissions? - Paul - Experience is the name every one gives to their mistakes.
  7. ptheriault

    Replication or Transaction log shipping for Reporting?

    If your requirement is one refresh a day then snap shot is what you want. It will script out the database and the data in each table and run the scripts where ever your reporting db is. So yes the data is static in that sense. So, if you schedule your snap shot for 12 AM. then your reporting...
  8. ptheriault

    Role of a user in server

    If this is for 2005 this will show you the user roles. SELECT p.name, s.name as Role, create_date, modify_date , CASE WHEN is_disabled = 0 THEN 'Enabled' ELSE 'Disabled' END as Status FROM sys.server_principals p JOIN ( select...
  9. ptheriault

    requirement for sql clustering

    http://www.sql-server-performance.com/articles/clustering/clustering_intro_p1.aspx - Paul - Experience is the name every one gives to their mistakes.
  10. ptheriault

    Replication or Transaction log shipping for Reporting?

    Given your new requirements I would definetly go with snap shot replication. With log shipping I believe the db must be left in a state of restoring, which means you can use the db for reports. Also, snap shot replication would have the least impact on performance if the snapshot can be run...
  11. ptheriault

    Replication or Transaction log shipping for Reporting?

    My first suggestion would be to take a serious look at your indexes. If you have a db that is 12 gb of data and 14 gb of indexes then you have way to many indexes! Believe it or not but to many indexes is a bad thing. They will kill your inserts. updates and deletes. What are the...
  12. ptheriault

    Login expire problem

    Connect to the server instance with SSMS (SQL Server Managment Studio). Drill down into the Security and open the account that you are having issues with. You will see security options on the first page. - Paul - Experience is the name every one gives to their mistakes.
  13. ptheriault

    Login expire problem

    Most likely your admin has set your account to enforce password policy and password expiration. Ask your DBA to confirm what policies he has in effect for your account. - Paul - Experience is the name every one gives to their mistakes.
  14. ptheriault

    Put MDX Query?

    You should post any questions you have about SSAS in this forum: forum960 - Paul - Experience is the name every one gives to their mistakes.
  15. ptheriault

    Clone box/SQL Manager problem

    You need to change the name of the sql instances. You can't have a sql server of the same name on the network, its like having two pc's with the same IP. Look up sp_dropserver and sp_addserver in BOL. Here is a proc to rename a server. Create proc uspRenameServer @pNewName...
  16. ptheriault

    Find the liar in the SQL Server 2005

    You can also read the Tlog with the following command. DBCC LOG(db_name, 3) Also, There is a great tool by lumigent called log explorer. It can read the log and recreate transactions. So if some idiot does delete data you can undo the transaction. - Paul - If at first you don't succeed...
  17. ptheriault

    message in error log

    It would help with performance to have 8 datafiles for tempdb but you don't have to set them to 1 gb each. - Paul - If at first you don't succeed, find out if the loser gets anything.
  18. ptheriault

    Security question - which permissions do what

    Sys Admins or 'sa' have full control over the whole database server and supersede any other permission you can grant. Be very carefull to who you grant the 'sa' role to. It is not to be taken lightly. - Paul - If at first you don't succeed, find out if the loser gets anything.
  19. ptheriault

    message in error log

    take a look at this kb, it should be helpful. http://support.microsoft.com/kb/897284 - Paul - If at first you don't succeed, find out if the loser gets anything.
  20. ptheriault

    How do you backup your Transaction logs?

    Yes, If you don't init your log backup will have all your backups (since you started the job) in it. If you ever had to restore you would have to search through that backup for the correct file (log sequence) to start at. I personally feel it's a best practice to init the log after you have...

Part and Inventory Search

Back
Top