Profiler...sorry for the multi-post

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Kevin3NF (KHill_at_NopeIDontNeedNoSPAM3NF-inc.com)
Date: 06/10/04 

Date: Thu, 10 Jun 2004 13:43:07 -0500

Needed the visibility....seems the .tools group is a little light today :-)

I have a trace file that I captured from my production server that I want to replay on my dev box. The database on dev is a restore of the production backup, but the DB_ID of the two is different, which I believe is causing these errors:

No matching connection to execute this on. Will auto-create one.
and
Failed to set proper user name ('empireapi') for the connection

the empireapi username is in the Dev database. I have also dropped and re-created it.

Question:
Is the different databaseid the source of the problem? can I change it somehow? Do you have enough info to determine?

Thanks, 

-- 
Kevin Hill
President 
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

Relevant Pages

  • Profiler
    ... I have a trace file that I captured from my production server that I want to replay on my dev box. ... The database on dev is a restore of the production backup, but the DB_ID of the two is different, which I believe is causing these errors: ... No matching connection to execute this on. ...
    (microsoft.public.sqlserver.tools)
  • Re: Profiler
    ... the DEV box is completely under my control for at least another ... > that the database ids need to be the same. ... Then set all the users captured in the trace to ... >>I have a trace file that I captured from my production server that I want ...
    (microsoft.public.sqlserver.tools)
  • Re: What is your database application development environment?
    ... development, then switch to the Test or QA database for optimization, ... both our Dev and QA processes used smaller databases. ... have DEV boxes or CPU cycles that closely resemble QA and production. ... each running SQL Server Developer. ...
    (borland.public.delphi.non-technical)
  • Re: SQL SERVER 2005 Structural changes monitor with C#
    ... Does your process of communicating database changes ... dev team. ... scripts logged on my development database and execute them on a new ... So the key issue I am trying to figure out is how SQL Server Profiler ...
    (microsoft.public.dotnet.general)
  • Re: Need help with copy database
    ... Because when coping to the production server I don't have access to moving ... called Copy Database, it should be usable. ... the number of errors reaches the number specified in MaximumErrorCount. ...
    (microsoft.public.sqlserver.dts)