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!

Register Log in
  • Congratulations Rhinorhino 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: Mich
  • Order by date
  1. Mich

    Gracefully kill all open IE

    I own several asp/jsp systems that tend to get, for lack of a better word, "clogged" with cache. When a problem is reported the first response is "Have you closed all browsers and cleared all cookies (CABACAC)?" Unfortunately many of my users will have a dozen sessions open with mutliple tabs...
  2. Mich

    Script to change db connections

    I'll check that out. Thanks for the tip. The server isn't retiring, we're just being moved to another one. -If it ain't broke, break it and make it better.
  3. Mich

    Script to change db connections

    We are migrating to a new SQL box and have to point hundreds of reports to the new server. Is there a way to script this? -If it ain't broke, break it and make it better.
  4. Mich

    Orphaned connection?

    I have a package that executes successfully, but throws up the following error: Error: The connection "050262" is not found. This error is thrown by Connections collection when the specific connection element is not found. Now, I may have set up connection "050262" at some point during...
  5. Mich

    Cannot connect to msde sql 2000

    You should upgrade from MSDE. Can you connect via EM using mixed authentication? -If it ain't broke, break it and make it better.
  6. Mich

    Restore multiple DBs from single BAK file

    I've never seen, or heard of, more than one database in a BAK. However, you can run this to make sure, restore headeronly from disk = '<filename>' -If it ain't broke, break it and make it better.
  7. Mich

    Sql db server locks up daily at same time

    Is that enough? The situation I ran into happened because large amounts of data was being added to the db between 3 and 4 pm every day. The db had been set to a small initial size and Autogrowth was set to 2% (don't ask me why). That meant the db was bogging down every day between 3 and 4...
  8. Mich

    Sql db server locks up daily at same time

    Do you have 'Autogrowth' enabled on the db's in question? I've run into situations where this has caused problems similar to this. -If it ain't broke, break it and make it better.
  9. Mich

    Launch multiple VBS simultaneously

    Ahhh, I'm onto you now. The extract scripts are vendor generated and I have been trying to test with a caller script. I need to modify the extract scripts to write to a file reporting when their done. Let me test this. -If it ain't broke, break it and make it better.
  10. Mich

    network username in Sysprocess tablee?

    What is the code for your trigger? -If it ain't broke, break it and make it better.
  11. Mich

    Launch multiple VBS simultaneously

    Well, it isn't so much to test the server's CPU performance or the database's performance as it is to test the script's performance. The determining factor is time to run which includes the performance of the server, db, etc. If I run all of the scripts against the same db then I'm introducing...
  12. Mich

    Launch multiple VBS simultaneously

    Yeah, that is what I'm doing right now. I was trying to avoid it because now I have to install 140 instances of SQL. -If it ain't broke, break it and make it better.
  13. Mich

    Linked server issue

    Profiler might work, but you'd need to have it running 24/7 to catch the "perp". That or know exactly when they are going to drop the linked server. You can use DDL triggers. Here is some good info => http://www.sql-server-performance.com/articles/audit/ddl_triggers_p1.aspx -If it ain't...
  14. Mich

    Launch multiple VBS simultaneously

    They are all connecting to separate databases and writing their own files. The concern I have is the load that will be placed on the server launching the scripts when they are all ran at the same time. It's been my experience that scripts, especially those that write to text files, tend to be...
  15. Mich

    SQL Server Agent &gt; Jobs

    msdb.sysjobs_view A little script I use often. select sjv.name as Name, max(sjh.run_date) as LastExecution, sjh.run_status as ExitCode from sysjobhistory sjh join sysjobs_view sjv on sjh.job_id = sjv.job_id group by sjv.name, sjh.run_status -If it ain't broke, break it and...
  16. Mich

    Launch multiple VBS simultaneously

    I'm currently testing an application that extracts data from SQL to text files then FTPs the data. All of that works fine, but I need to determine if it is better to set the extracts up in sequence or if I can run them all at once OR where is the line that determines one process is better than...
  17. Mich

    replication conflict monitoring

    Right-click on your publication and select 'View Conflicts'. Select the table with the conflicts you want to look at, press OK, and you'll be taken to the Conflict Viewer. There is some pretty good info there. -If it ain't broke, break it and make it better.
  18. Mich

    Deleting logins on SQL 2005

    Here are the schemas that are currently being utilized, select distinct(s.name)from sys.schemas s join sys.tables t on s.schema_id = t.schema_id -If it ain't broke, break it and make it better.
  19. Mich

    Deleting logins on SQL 2005

    Correct. I was referring to the original poster. I need to clarify my post a little to address data access specifically. SQL Server logins provide access to the instance while database users provide access to the data. A good way to detect orphaned users is by running...
  20. Mich

    Optimize the Database before software upgrade?

    As Kusch points out, optimization can mean so many different things. When I hear "optimize the db" I think of normalization, index design, query design, etc. Sounds like your IT guy wants to pin you down and cover his butt. Do as Kusch suggests and ask a simple question, "Optimize the db in...

Part and Inventory Search

Back
Top