Problem with Jobs

Hello all,

I am having a problem with the sql

DB on the company that I work for.

I got message under job history

on Enterprise manager is :

"The job failed.The Job was invoked by Schedule 15 (Replication

agent schedule.).The last step to run

was step 1 (Run agent.)"

and in the event log is:

Event ID: 208

Source: SQLAgent$(company DB)

"sql server Schedule (company DB)

status:Failed"

Please advice.

Thanks in advance

Kind regards

This relates to replication issues, which can be quite complex depending on what you're trying to do. You should review your replication scheme to ensure that all the data is going where it should. If the replication isn't happening, your files will grow on the distributor until it runs out of room.

If you're new to replication, check here:

http://msdn2.microsoft.com/en-us/library/ms151198.aspx

Problem with installing SQL2KASP3 in SP3a

In SQL Server Service Manager, I stopped the server, Installed SQL2KSP3
fine, but
when installing SQL2KASP3 in SP3a it gets to 99% and says SEVERE:An Error
occurred during
the move data process:-145.
Any help would be appreciated.
Do you actually have Analysis Services installed and running?
If not, you shouldn't be installing SQL2KASP3, which is meant only for
Analysis Services.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Daniel Callahan" <djcallahan@.cox.net> wrote in message
news:u9$kFfxIEHA.3248@.TK2MSFTNGP12.phx.gbl...
> In SQL Server Service Manager, I stopped the server, Installed SQL2KSP3
> fine, but
> when installing SQL2KASP3 in SP3a it gets to 99% and says SEVERE:An Error
> occurred during
> the move data process:-145.
> Any help would be appreciated.
>
>
|||Daniel,
As a followup to what Aaron mentioned, see
PRB: Analysis Services 2000 Service Pack 3 Setup Is Not Successful Because
the RootDir Value Is Missing
http://support.microsoft.com/?id=814462
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Daniel Callahan" <djcallahan@.cox.net> wrote in message
news:u9$kFfxIEHA.3248@.TK2MSFTNGP12.phx.gbl...
> In SQL Server Service Manager, I stopped the server, Installed SQL2KSP3
> fine, but
> when installing SQL2KASP3 in SP3a it gets to 99% and says SEVERE:An Error
> occurred during
> the move data process:-145.
> Any help would be appreciated.
>
>

Problem with installing SQL2KASP3 in SP3a

In SQL Server Service Manager, I stopped the server, Installed SQL2KSP3
fine, but
when installing SQL2KASP3 in SP3a it gets to 99% and says SEVERE:An Error
occurred during
the move data process:-145.
Any help would be appreciated.Do you actually have Analysis Services installed and running?
If not, you shouldn't be installing SQL2KASP3, which is meant only for
Analysis Services.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Daniel Callahan" <djcallahan@.cox.net> wrote in message
news:u9$kFfxIEHA.3248@.TK2MSFTNGP12.phx.gbl...
> In SQL Server Service Manager, I stopped the server, Installed SQL2KSP3
> fine, but
> when installing SQL2KASP3 in SP3a it gets to 99% and says SEVERE:An Error
> occurred during
> the move data process:-145.
> Any help would be appreciated.
>
>|||Daniel,
As a followup to what Aaron mentioned, see
PRB: Analysis Services 2000 Service Pack 3 Setup Is Not Successful Because
the RootDir Value Is Missing
http://support.microsoft.com/?id=814462
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Daniel Callahan" <djcallahan@.cox.net> wrote in message
news:u9$kFfxIEHA.3248@.TK2MSFTNGP12.phx.gbl...
> In SQL Server Service Manager, I stopped the server, Installed SQL2KSP3
> fine, but
> when installing SQL2KASP3 in SP3a it gets to 99% and says SEVERE:An Error
> occurred during
> the move data process:-145.
> Any help would be appreciated.
>
>sql

Problem with installing SQL2KASP3 in SP3a

In SQL Server Service Manager, I stopped the server, Installed SQL2KSP3
fine, but
when installing SQL2KASP3 in SP3a it gets to 99% and says SEVERE:An Error
occurred during
the move data process:-145.
Any help would be appreciated.Do you actually have Analysis Services installed and running?
If not, you shouldn't be installing SQL2KASP3, which is meant only for
Analysis Services.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Daniel Callahan" <djcallahan@.cox.net> wrote in message
news:u9$kFfxIEHA.3248@.TK2MSFTNGP12.phx.gbl...
> In SQL Server Service Manager, I stopped the server, Installed SQL2KSP3
> fine, but
> when installing SQL2KASP3 in SP3a it gets to 99% and says SEVERE:An Error
> occurred during
> the move data process:-145.
> Any help would be appreciated.
>
>|||Daniel,
As a followup to what Aaron mentioned, see
PRB: Analysis Services 2000 Service Pack 3 Setup Is Not Successful Because
the RootDir Value Is Missing
http://support.microsoft.com/?id=814462
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Daniel Callahan" <djcallahan@.cox.net> wrote in message
news:u9$kFfxIEHA.3248@.TK2MSFTNGP12.phx.gbl...
> In SQL Server Service Manager, I stopped the server, Installed SQL2KSP3
> fine, but
> when installing SQL2KASP3 in SP3a it gets to 99% and says SEVERE:An Error
> occurred during
> the move data process:-145.
> Any help would be appreciated.
>
>

Problem with identity user in a report

Hi,

I use forms authentication with my Report manager. The problem is that I can't display the same information to all the users into the report. For example, in my report, i have one dataset that give me a list of all the store of a compagny. And i have to display only the store onto the user is working. If the user is a boss, he can see the information of all the stores. So i have to know in my report what is the login he uses in the form authetication and i don't know how to do.

Excuse me for my bad english and thank you.

Regards,

Shaouk.

Well Shaouk what i have understand from your point is that for that you must have your data base structure like that you must know which company is the user associated to. Means your company table should have column of user id Or if user can be associated with mulitiple companies then third table with comanyID and UserID should exist SO you may know that the logged in user is dealing with this or those comapnies.

Then after user logged in send userID to the stored procedure from which you are geting the company list so you may filter them on basis of that userId or if using dataset with already populated companies with userId's associated with them then filter that dataset on the basis of that logged in UserID

I Hope that works

Regards

Nabil Khalid

|||

Hello Shaouk,

From within your report, you can make use of User!UserID to determine who is running the report.

Hope this helps.

Jarret

Problem with Enterprise manager and authentication

Hi
I recently upgraded my infrastructure to Active Directory 2003.
Since then I'm having two problems when I start Enterprise Manager and
connect on 2003 sever member with SQL2000 sp3a:
1 On non-member machine, I use SQL authentication to register the server and
in the security log I keep getting dozens of Event ID 529 (unkown username
or bad password) every minutes.
The user in the event is the local account logged on the workstation.
2 on member machines, I have three successfull events (logoff/privilges
assigned/logon) every 10 seconds
In the first case, why does it try to log on with the local account ?
In the second case why does it logoff/logon every 10 seconds ?
I can't remove this audit (international group security policy...) and the
security logs are full in about 2 weeks with 600,000+ events!! I can't
manage that!
Thanks in advance for your help.
Regards,
Christophe Niel
Thats an odd one, have you seen http://support.microsoft.com/?kbid=890477 ?,
looks similar to your problem.
Peter
"Facts are stupid things."
Ronald Reagan
"Christophe Niel" wrote:

> Hi
> I recently upgraded my infrastructure to Active Directory 2003.
> Since then I'm having two problems when I start Enterprise Manager and
> connect on 2003 sever member with SQL2000 sp3a:
> 1 On non-member machine, I use SQL authentication to register the server and
> in the security log I keep getting dozens of Event ID 529 (unkown username
> or bad password) every minutes.
> The user in the event is the local account logged on the workstation.
> 2 on member machines, I have three successfull events (logoff/privilges
> assigned/logon) every 10 seconds
> In the first case, why does it try to log on with the local account ?
> In the second case why does it logoff/logon every 10 seconds ?
>
> I can't remove this audit (international group security policy...) and the
> security logs are full in about 2 weeks with 600,000+ events!! I can't
> manage that!
> Thanks in advance for your help.
> Regards,
> Christophe Niel
>
>
|||Both are probably due to polling services that is
automatically set to check every 10 seconds.
In the first case, because you are logged in as the local
account and it is trying to poll the services from the
workstation using that account.
In Enterprise Manager, go up to the menu to Tools, Options.
You can deselect the checkbox to poll the services.
-Sue
On Wed, 9 Mar 2005 11:25:01 +0100, "Christophe Niel"
<Christophe.niel@.removetomail.fr.abnamro.com> wrote:

>Hi
>I recently upgraded my infrastructure to Active Directory 2003.
>Since then I'm having two problems when I start Enterprise Manager and
>connect on 2003 sever member with SQL2000 sp3a:
>1 On non-member machine, I use SQL authentication to register the server and
>in the security log I keep getting dozens of Event ID 529 (unkown username
>or bad password) every minutes.
>The user in the event is the local account logged on the workstation.
>2 on member machines, I have three successfull events (logoff/privilges
>assigned/logon) every 10 seconds
>In the first case, why does it try to log on with the local account ?
>In the second case why does it logoff/logon every 10 seconds ?
>
>I can't remove this audit (international group security policy...) and the
>security logs are full in about 2 weeks with 600,000+ events!! I can't
>manage that!
>Thanks in advance for your help.
>Regards,
>Christophe Niel
>
|||Wow! it worked!!
and "Doh!"... I've been using enterprise manager for years and I had never
seen an "option" menu (or let's say the polling option didn't strike me as
the cause of my problem)
Well, as I said: it worked and my logs are clean again.
Thanks a lot
Christophe
"Sue Hoegemeier" <Sue_H@.nomail.please> a crit dans le message de news:
3dtt21pbu974t8584n2ae5tifdhca95st0@.4ax.com...
> Both are probably due to polling services that is
> automatically set to check every 10 seconds.
> In the first case, because you are logged in as the local
> account and it is trying to poll the services from the
> workstation using that account.
> In Enterprise Manager, go up to the menu to Tools, Options.
> You can deselect the checkbox to poll the services.
> -Sue
> On Wed, 9 Mar 2005 11:25:01 +0100, "Christophe Niel"
> <Christophe.niel@.removetomail.fr.abnamro.com> wrote:
>

Problem with Enterprise manager and authentication

Hi
I recently upgraded my infrastructure to Active Directory 2003.
Since then I'm having two problems when I start Enterprise Manager and
connect on 2003 sever member with SQL2000 sp3a:
1 On non-member machine, I use SQL authentication to register the server and
in the security log I keep getting dozens of Event ID 529 (unkown username
or bad password) every minutes.
The user in the event is the local account logged on the workstation.
2 on member machines, I have three successfull events (logoff/privilges
assigned/logon) every 10 seconds
In the first case, why does it try to log on with the local account ?
In the second case why does it logoff/logon every 10 seconds ?
I can't remove this audit (international group security policy...) and the
security logs are full in about 2 weeks with 600,000+ events!! I can't
manage that!
Thanks in advance for your help.
Regards,
Christophe NielThats an odd one, have you seen http://support.microsoft.com/?kbid=890477 ?,
looks similar to your problem.
Peter
"Facts are stupid things."
Ronald Reagan
"Christophe Niel" wrote:
> Hi
> I recently upgraded my infrastructure to Active Directory 2003.
> Since then I'm having two problems when I start Enterprise Manager and
> connect on 2003 sever member with SQL2000 sp3a:
> 1 On non-member machine, I use SQL authentication to register the server and
> in the security log I keep getting dozens of Event ID 529 (unkown username
> or bad password) every minutes.
> The user in the event is the local account logged on the workstation.
> 2 on member machines, I have three successfull events (logoff/privilges
> assigned/logon) every 10 seconds
> In the first case, why does it try to log on with the local account ?
> In the second case why does it logoff/logon every 10 seconds ?
>
> I can't remove this audit (international group security policy...) and the
> security logs are full in about 2 weeks with 600,000+ events!! I can't
> manage that!
> Thanks in advance for your help.
> Regards,
> Christophe Niel
>
>|||Both are probably due to polling services that is
automatically set to check every 10 seconds.
In the first case, because you are logged in as the local
account and it is trying to poll the services from the
workstation using that account.
In Enterprise Manager, go up to the menu to Tools, Options.
You can deselect the checkbox to poll the services.
-Sue
On Wed, 9 Mar 2005 11:25:01 +0100, "Christophe Niel"
<Christophe.niel@.removetomail.fr.abnamro.com> wrote:
>Hi
>I recently upgraded my infrastructure to Active Directory 2003.
>Since then I'm having two problems when I start Enterprise Manager and
>connect on 2003 sever member with SQL2000 sp3a:
>1 On non-member machine, I use SQL authentication to register the server and
>in the security log I keep getting dozens of Event ID 529 (unkown username
>or bad password) every minutes.
>The user in the event is the local account logged on the workstation.
>2 on member machines, I have three successfull events (logoff/privilges
>assigned/logon) every 10 seconds
>In the first case, why does it try to log on with the local account ?
>In the second case why does it logoff/logon every 10 seconds ?
>
>I can't remove this audit (international group security policy...) and the
>security logs are full in about 2 weeks with 600,000+ events!! I can't
>manage that!
>Thanks in advance for your help.
>Regards,
>Christophe Niel
>|||Wow! it worked!!
and "Doh!"... I've been using enterprise manager for years and I had never
seen an "option" menu (or let's say the polling option didn't strike me as
the cause of my problem)
Well, as I said: it worked and my logs are clean again.
Thanks a lot
Christophe
"Sue Hoegemeier" <Sue_H@.nomail.please> a écrit dans le message de news:
3dtt21pbu974t8584n2ae5tifdhca95st0@.4ax.com...
> Both are probably due to polling services that is
> automatically set to check every 10 seconds.
> In the first case, because you are logged in as the local
> account and it is trying to poll the services from the
> workstation using that account.
> In Enterprise Manager, go up to the menu to Tools, Options.
> You can deselect the checkbox to poll the services.
> -Sue
> On Wed, 9 Mar 2005 11:25:01 +0100, "Christophe Niel"
> <Christophe.niel@.removetomail.fr.abnamro.com> wrote:
>>Hi
>>I recently upgraded my infrastructure to Active Directory 2003.
>>Since then I'm having two problems when I start Enterprise Manager and
>>connect on 2003 sever member with SQL2000 sp3a:
>>1 On non-member machine, I use SQL authentication to register the server
>>and
>>in the security log I keep getting dozens of Event ID 529 (unkown username
>>or bad password) every minutes.
>>The user in the event is the local account logged on the workstation.
>>2 on member machines, I have three successfull events (logoff/privilges
>>assigned/logon) every 10 seconds
>>In the first case, why does it try to log on with the local account ?
>>In the second case why does it logoff/logon every 10 seconds ?
>>
>>I can't remove this audit (international group security policy...) and the
>>security logs are full in about 2 weeks with 600,000+ events!! I can't
>>manage that!
>>Thanks in advance for your help.
>>Regards,
>>Christophe Niel
>

Problem with Enterprise manager and authentication

Hi
I recently upgraded my infrastructure to Active Directory 2003.
Since then I'm having two problems when I start Enterprise Manager and
connect on 2003 sever member with SQL2000 sp3a:
1 On non-member machine, I use SQL authentication to register the server and
in the security log I keep getting dozens of Event ID 529 (unkown username
or bad password) every minutes.
The user in the event is the local account logged on the workstation.
2 on member machines, I have three successfull events (logoff/privilges
assigned/logon) every 10 seconds
In the first case, why does it try to log on with the local account ?
In the second case why does it logoff/logon every 10 seconds ?
I can't remove this audit (international group security policy...) and the
security logs are full in about 2 weeks with 600,000+ events!! I can't
manage that!
Thanks in advance for your help.
Regards,
Christophe NielThats an odd one, have you seen http://support.microsoft.com/?kbid=890477 ?,
looks similar to your problem.
Peter
"Facts are stupid things."
Ronald Reagan
"Christophe Niel" wrote:

> Hi
> I recently upgraded my infrastructure to Active Directory 2003.
> Since then I'm having two problems when I start Enterprise Manager and
> connect on 2003 sever member with SQL2000 sp3a:
> 1 On non-member machine, I use SQL authentication to register the server a
nd
> in the security log I keep getting dozens of Event ID 529 (unkown username
> or bad password) every minutes.
> The user in the event is the local account logged on the workstation.
> 2 on member machines, I have three successfull events (logoff/privilges
> assigned/logon) every 10 seconds
> In the first case, why does it try to log on with the local account ?
> In the second case why does it logoff/logon every 10 seconds ?
>
> I can't remove this audit (international group security policy...) and the
> security logs are full in about 2 weeks with 600,000+ events!! I can't
> manage that!
> Thanks in advance for your help.
> Regards,
> Christophe Niel
>
>|||Both are probably due to polling services that is
automatically set to check every 10 seconds.
In the first case, because you are logged in as the local
account and it is trying to poll the services from the
workstation using that account.
In Enterprise Manager, go up to the menu to Tools, Options.
You can deselect the checkbox to poll the services.
-Sue
On Wed, 9 Mar 2005 11:25:01 +0100, "Christophe Niel"
<Christophe.niel@.removetomail.fr.abnamro.com> wrote:

>Hi
>I recently upgraded my infrastructure to Active Directory 2003.
>Since then I'm having two problems when I start Enterprise Manager and
>connect on 2003 sever member with SQL2000 sp3a:
>1 On non-member machine, I use SQL authentication to register the server an
d
>in the security log I keep getting dozens of Event ID 529 (unkown username
>or bad password) every minutes.
>The user in the event is the local account logged on the workstation.
>2 on member machines, I have three successfull events (logoff/privilges
>assigned/logon) every 10 seconds
>In the first case, why does it try to log on with the local account ?
>In the second case why does it logoff/logon every 10 seconds ?
>
>I can't remove this audit (international group security policy...) and the
>security logs are full in about 2 weeks with 600,000+ events!! I can't
>manage that!
>Thanks in advance for your help.
>Regards,
>Christophe Niel
>|||Wow! it worked!!
and "Doh!"... I've been using enterprise manager for years and I had never
seen an "option" menu (or let's say the polling option didn't strike me as
the cause of my problem)
Well, as I said: it worked and my logs are clean again.
Thanks a lot
Christophe
"Sue Hoegemeier" <Sue_H@.nomail.please> a crit dans le message de news:
3dtt21pbu974t8584n2ae5tifdhca95st0@.4ax.com...
> Both are probably due to polling services that is
> automatically set to check every 10 seconds.
> In the first case, because you are logged in as the local
> account and it is trying to poll the services from the
> workstation using that account.
> In Enterprise Manager, go up to the menu to Tools, Options.
> You can deselect the checkbox to poll the services.
> -Sue
> On Wed, 9 Mar 2005 11:25:01 +0100, "Christophe Niel"
> <Christophe.niel@.removetomail.fr.abnamro.com> wrote:
>
>

Problem with Enterprise Manager 2000

Hi,
After installing XP SP2 security patches on my box, I can not open
Enterprise Manager. It crashes when I click on icon to bring the analyzer up.
I get two error in event log,
========================
1. Event Type:Error
Event Source:Application Error
Event Category:None
Event ID:1000
Date:1/18/2005
Time:3:30:09 PM
User:N/A
Computer:WXPP-LT_AMINH
Description:
Faulting application mmc.exe, version 5.1.2600.0, faulting module mmc.exe,
version 5.1.2600.0, fault address 0x0000bb5b.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 41 70 70 6c 69 63 61 74 Applicat
0008: 69 6f 6e 20 46 61 69 6c ion Fail
0010: 75 72 65 20 20 6d 6d 63 ure mmc
0018: 2e 65 78 65 20 35 2e 31 .exe 5.1
0020: 2e 32 36 30 30 2e 30 20 .2600.0
0028: 69 6e 20 6d 6d 63 2e 65 in mmc.e
0030: 78 65 20 35 2e 31 2e 32 xe 5.1.2
0038: 36 30 30 2e 30 20 61 74 600.0 at
0040: 20 6f 66 66 73 65 74 20 offset
0048: 30 30 30 30 62 62 35 62 0000bb5b
0050: 0d 0a ..
2.
Event Type:Error
Event Source:Application Error
Event Category:None
Event ID:1001
Date:1/18/2005
Time:3:30:22 PM
User:N/A
Computer:WXPP-LT_AMINH
Description:
Fault bucket 02874011.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 42 75 63 6b 65 74 3a 20 Bucket:
0008: 30 32 38 37 34 30 31 31 02874011
0010: 0d 0a ..
=======================
I removed the patches using reollback option of XP, but after removal even
explorer crashes. I re-installed SQL client tools, but result is same...
Any one has idea how to resolve this?
Thanks,
Hiten
Maybe the snap-in has become corrupt or damaged.
Try renaming the existing SQL Server Enterprise Manager.MSC
file.
Then copy the SQL Server Enterprise Manager.MSC file from
the your SQL Server CD to the same location.
-Sue
On Tue, 18 Jan 2005 12:39:11 -0800, "Hiten"
<Hiten@.discussions.microsoft.com> wrote:

>Hi,
>After installing XP SP2 security patches on my box, I can not open
>Enterprise Manager. It crashes when I click on icon to bring the analyzer up.
>I get two error in event log,
>========================
>1. Event Type:Error
>Event Source:Application Error
>Event Category:None
>Event ID:1000
>Date:1/18/2005
>Time:3:30:09 PM
>User:N/A
>Computer:WXPP-LT_AMINH
>Description:
>Faulting application mmc.exe, version 5.1.2600.0, faulting module mmc.exe,
>version 5.1.2600.0, fault address 0x0000bb5b.
>For more information, see Help and Support Center at
>http://go.microsoft.com/fwlink/events.asp.
>Data:
>0000: 41 70 70 6c 69 63 61 74 Applicat
>0008: 69 6f 6e 20 46 61 69 6c ion Fail
>0010: 75 72 65 20 20 6d 6d 63 ure mmc
>0018: 2e 65 78 65 20 35 2e 31 .exe 5.1
>0020: 2e 32 36 30 30 2e 30 20 .2600.0
>0028: 69 6e 20 6d 6d 63 2e 65 in mmc.e
>0030: 78 65 20 35 2e 31 2e 32 xe 5.1.2
>0038: 36 30 30 2e 30 20 61 74 600.0 at
>0040: 20 6f 66 66 73 65 74 20 offset
>0048: 30 30 30 30 62 62 35 62 0000bb5b
>0050: 0d 0a ..
>2.
>Event Type:Error
>Event Source:Application Error
>Event Category:None
>Event ID:1001
>Date:1/18/2005
>Time:3:30:22 PM
>User:N/A
>Computer:WXPP-LT_AMINH
>Description:
>Fault bucket 02874011.
>For more information, see Help and Support Center at
>http://go.microsoft.com/fwlink/events.asp.
>Data:
>0000: 42 75 63 6b 65 74 3a 20 Bucket:
>0008: 30 32 38 37 34 30 31 31 02874011
>0010: 0d 0a ..
>=======================
>I removed the patches using reollback option of XP, but after removal even
>explorer crashes. I re-installed SQL client tools, but result is same...
>Any one has idea how to resolve this?
>Thanks,
>Hiten
|||Someone with the same problem before SP2 found this to be a workaround:
http://groups-beta.google.com/group/...e66a3e81c65f5e
[I opened] mmc.exe in the Windows/system32 folder and add[ed]
the Enterprise Manager snap-in. Now I can just run enterprise
manager that way! It's not ideal, but it works :-)
Steve Kass
Drew University
Hiten wrote:

>Hi,
>After installing XP SP2 security patches on my box, I can not open
>Enterprise Manager. It crashes when I click on icon to bring the analyzer up.
>I get two error in event log,
>========================
>1. Event Type:Error
>Event Source:Application Error
>Event Category:None
>Event ID:1000
>Date:1/18/2005
>Time:3:30:09 PM
>User:N/A
>Computer:WXPP-LT_AMINH
>Description:
>Faulting application mmc.exe, version 5.1.2600.0, faulting module mmc.exe,
>version 5.1.2600.0, fault address 0x0000bb5b.
>For more information, see Help and Support Center at
>http://go.microsoft.com/fwlink/events.asp.
>Data:
>0000: 41 70 70 6c 69 63 61 74 Applicat
>0008: 69 6f 6e 20 46 61 69 6c ion Fail
>0010: 75 72 65 20 20 6d 6d 63 ure mmc
>0018: 2e 65 78 65 20 35 2e 31 .exe 5.1
>0020: 2e 32 36 30 30 2e 30 20 .2600.0
>0028: 69 6e 20 6d 6d 63 2e 65 in mmc.e
>0030: 78 65 20 35 2e 31 2e 32 xe 5.1.2
>0038: 36 30 30 2e 30 20 61 74 600.0 at
>0040: 20 6f 66 66 73 65 74 20 offset
>0048: 30 30 30 30 62 62 35 62 0000bb5b
>0050: 0d 0a ..
>2.
>Event Type:Error
>Event Source:Application Error
>Event Category:None
>Event ID:1001
>Date:1/18/2005
>Time:3:30:22 PM
>User:N/A
>Computer:WXPP-LT_AMINH
>Description:
>Fault bucket 02874011.
>For more information, see Help and Support Center at
>http://go.microsoft.com/fwlink/events.asp.
>Data:
>0000: 42 75 63 6b 65 74 3a 20 Bucket:
>0008: 30 32 38 37 34 30 31 31 02874011
>0010: 0d 0a ..
>=======================
>I removed the patches using reollback option of XP, but after removal even
>explorer crashes. I re-installed SQL client tools, but result is same...
>Any one has idea how to resolve this?
>Thanks,
>Hiten
>

Problem with enterprise manager ( image attached )

Hi,
I have been having a problem for a couple of weeks, for some reason the
"Create Date" column of both the tables and SP views appear with weird
characters (as shown in the attached image) , This happen both on a local
server as well as on a remote server.
When I connect to the remote server using TS and see the same view the
"Create Date" column appear normally.
What could have happen? and even it's not a big issue I would like to know
how to solve it.
Thanks,
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
Did you by chance install YUKON Beta on the same box ?
"Ignacio Machin ( .NET/ C# MVP )" wrote:

> Hi,
> I have been having a problem for a couple of weeks, for some reason the
> "Create Date" column of both the tables and SP views appear with weird
> characters (as shown in the attached image) , This happen both on a local
> server as well as on a remote server.
> When I connect to the remote server using TS and see the same view the
> "Create Date" column appear normally.
> What could have happen? and even it's not a big issue I would like to know
> how to solve it.
>
> Thanks,
> --
> Ignacio Machin,
> ignacio.machin AT dot.state.fl.us
> Florida Department Of Transportation
>
>
|||Nop,
I haven't installed it, I have VS.NET 2005 installed , though.
Cheers,
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"Umut Nazlica" <UmutNazlica@.discussions.microsoft.com> wrote in message
news:F4BA581B-F664-469D-8C7B-301E72D72292@.microsoft.com...[vbcol=seagreen]
> Did you by chance install YUKON Beta on the same box ?
>
> "Ignacio Machin ( .NET/ C# MVP )" wrote:
local[vbcol=seagreen]
know[vbcol=seagreen]
|||Probably that is the problem..
"Ignacio Machin ( .NET/ C# MVP )" wrote:

> Hi,
> I have been having a problem for a couple of weeks, for some reason the
> "Create Date" column of both the tables and SP views appear with weird
> characters (as shown in the attached image) , This happen both on a local
> server as well as on a remote server.
> When I connect to the remote server using TS and see the same view the
> "Create Date" column appear normally.
> What could have happen? and even it's not a big issue I would like to know
> how to solve it.
>
> Thanks,
> --
> Ignacio Machin,
> ignacio.machin AT dot.state.fl.us
> Florida Department Of Transportation
>
>

Problem with enterprise manager ( image attached )

Hi,
I have been having a problem for a couple of weeks, for some reason the
"Create Date" column of both the tables and SP views appear with weird
characters (as shown in the attached image) , This happen both on a local
server as well as on a remote server.
When I connect to the remote server using TS and see the same view the
"Create Date" column appear normally.
What could have happen? and even it's not a big issue I would like to know
how to solve it.
Thanks,
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of TransportationDid you by chance install YUKON Beta on the same box ?
"Ignacio Machin ( .NET/ C# MVP )" wrote:

> Hi,
> I have been having a problem for a couple of weeks, for some reason the
> "Create Date" column of both the tables and SP views appear with weird
> characters (as shown in the attached image) , This happen both on a local
> server as well as on a remote server.
> When I connect to the remote server using TS and see the same view the
> "Create Date" column appear normally.
> What could have happen? and even it's not a big issue I would like to kno
w
> how to solve it.
>
> Thanks,
> --
> Ignacio Machin,
> ignacio.machin AT dot.state.fl.us
> Florida Department Of Transportation
>
>|||Nop,
I haven't installed it, I have VS.NET 2005 installed , though.
Cheers,
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"Umut Nazlica" <UmutNazlica@.discussions.microsoft.com> wrote in message
news:F4BA581B-F664-469D-8C7B-301E72D72292@.microsoft.com...[vbcol=seagreen]
> Did you by chance install YUKON Beta on the same box ?
>
> "Ignacio Machin ( .NET/ C# MVP )" wrote:
>
local[vbcol=seagreen]
know[vbcol=seagreen]|||Probably that is the problem..
"Ignacio Machin ( .NET/ C# MVP )" wrote:

> Hi,
> I have been having a problem for a couple of weeks, for some reason the
> "Create Date" column of both the tables and SP views appear with weird
> characters (as shown in the attached image) , This happen both on a local
> server as well as on a remote server.
> When I connect to the remote server using TS and see the same view the
> "Create Date" column appear normally.
> What could have happen? and even it's not a big issue I would like to kno
w
> how to solve it.
>
> Thanks,
> --
> Ignacio Machin,
> ignacio.machin AT dot.state.fl.us
> Florida Department Of Transportation
>
>

Problem with enterprise manager ( image attached )

Hi,
I have been having a problem for a couple of weeks, for some reason the
"Create Date" column of both the tables and SP views appear with weird
characters (as shown in the attached image) , This happen both on a local
server as well as on a remote server.
When I connect to the remote server using TS and see the same view the
"Create Date" column appear normally.
What could have happen? and even it's not a big issue I would like to know
how to solve it.
Thanks,
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of TransportationNop,
I haven't installed it, I have VS.NET 2005 installed , though.
Cheers,
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"Umut Nazlica" <UmutNazlica@.discussions.microsoft.com> wrote in message
news:F4BA581B-F664-469D-8C7B-301E72D72292@.microsoft.com...
> Did you by chance install YUKON Beta on the same box ?
>
> "Ignacio Machin ( .NET/ C# MVP )" wrote:
> > Hi,
> >
> > I have been having a problem for a couple of weeks, for some reason the
> > "Create Date" column of both the tables and SP views appear with weird
> > characters (as shown in the attached image) , This happen both on a
local
> > server as well as on a remote server.
> > When I connect to the remote server using TS and see the same view the
> > "Create Date" column appear normally.
> >
> > What could have happen? and even it's not a big issue I would like to
know
> > how to solve it.
> >
> >
> > Thanks,
> >
> > --
> > Ignacio Machin,
> > ignacio.machin AT dot.state.fl.us
> > Florida Department Of Transportation
> >
> >
> >

Problem with Enterprise Manager

When in em, I try to open a table and return all rows, I get a weird error:
"The query cannot be executed because some o fthe files are missing or not
registered."
Also, I cannot connect to the database with a dataadapter in vs (2003)
I can, however, execute an SQL in Query Analyzer.
I have reinstalled several times. Some of the Google articles suggest that
it might be MDAC. I cannot install MDAC either. It says that the operation
is not supported by the OS (xp Pro) The components are already installed.
Any input would be greatly appreciated.
Hi
A few questions!
Did you try and remove the software before re-installing?
Did you rung the MDAC component checker to see if it says your installation
is consistent?
Have you tried to apply any service packs?
You may wish to un-register/re-register all the dlls in {Installation
Directory}\80\Tools\Binn?
John
"walter1234" wrote:

> When in em, I try to open a table and return all rows, I get a weird error:
> "The query cannot be executed because some o fthe files are missing or not
> registered."
> Also, I cannot connect to the database with a dataadapter in vs (2003)
> I can, however, execute an SQL in Query Analyzer.
> I have reinstalled several times. Some of the Google articles suggest that
> it might be MDAC. I cannot install MDAC either. It says that the operation
> is not supported by the OS (xp Pro) The components are already installed.
> Any input would be greatly appreciated.
|||I just ran into this issue myself, I've tried the reinstall etc. I'm going
to try and un-register/re-register all of the DLLs in that directory but
there are 46 of them. Any suggestions on an easy way to do that?
I also tried the suggestions in Article ID: 315868.
Cory Blythe
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> A few questions!
> Did you try and remove the software before re-installing?
> Did you rung the MDAC component checker to see if it says your installation
> is consistent?
> Have you tried to apply any service packs?
> You may wish to un-register/re-register all the dlls in {Installation
> Directory}\80\Tools\Binn?
> John
> "walter1234" wrote:

Problem with Enterprise Manager

When in em, I try to open a table and return all rows, I get a weird error:
"The query cannot be executed because some o fthe files are missing or not
registered."
Also, I cannot connect to the database with a dataadapter in vs (2003)
I can, however, execute an SQL in Query Analyzer.
I have reinstalled several times. Some of the Google articles suggest that
it might be MDAC. I cannot install MDAC either. It says that the operation
is not supported by the OS (xp Pro) The components are already installed.
Any input would be greatly appreciated.Hi
A few questions!
Did you try and remove the software before re-installing?
Did you rung the MDAC component checker to see if it says your installation
is consistent?
Have you tried to apply any service packs?
You may wish to un-register/re-register all the dlls in {Installation
Directory}\80\Tools\Binn?
John
"walter1234" wrote:
> When in em, I try to open a table and return all rows, I get a weird error:
> "The query cannot be executed because some o fthe files are missing or not
> registered."
> Also, I cannot connect to the database with a dataadapter in vs (2003)
> I can, however, execute an SQL in Query Analyzer.
> I have reinstalled several times. Some of the Google articles suggest that
> it might be MDAC. I cannot install MDAC either. It says that the operation
> is not supported by the OS (xp Pro) The components are already installed.
> Any input would be greatly appreciated.|||I just ran into this issue myself, I've tried the reinstall etc. I'm going
to try and un-register/re-register all of the DLLs in that directory but
there are 46 of them. Any suggestions on an easy way to do that?
I also tried the suggestions in Article ID: 315868.
Cory Blythe
"John Bell" wrote:
> Hi
> A few questions!
> Did you try and remove the software before re-installing?
> Did you rung the MDAC component checker to see if it says your installation
> is consistent?
> Have you tried to apply any service packs?
> You may wish to un-register/re-register all the dlls in {Installation
> Directory}\80\Tools\Binn?
> John
> "walter1234" wrote:
> > When in em, I try to open a table and return all rows, I get a weird error:
> > "The query cannot be executed because some o fthe files are missing or not
> > registered."
> > Also, I cannot connect to the database with a dataadapter in vs (2003)
> > I can, however, execute an SQL in Query Analyzer.
> > I have reinstalled several times. Some of the Google articles suggest that
> > it might be MDAC. I cannot install MDAC either. It says that the operation
> > is not supported by the OS (xp Pro) The components are already installed.
> > Any input would be greatly appreciated.

Problem with Enterprise Manager

When in em, I try to open a table and return all rows, I get a weird error:
"The query cannot be executed because some o fthe files are missing or not
registered."
Also, I cannot connect to the database with a dataadapter in vs (2003)
I can, however, execute an SQL in Query Analyzer.
I have reinstalled several times. Some of the Google articles suggest that
it might be MDAC. I cannot install MDAC either. It says that the operation
is not supported by the OS (xp Pro) The components are already installed.
Any input would be greatly appreciated.Hi
A few questions!
Did you try and remove the software before re-installing?
Did you rung the MDAC component checker to see if it says your installation
is consistent?
Have you tried to apply any service packs?
You may wish to un-register/re-register all the dlls in {Installation
Directory}\80\Tools\Binn?
John
"walter1234" wrote:

> When in em, I try to open a table and return all rows, I get a weird error
:
> "The query cannot be executed because some o fthe files are missing or not
> registered."
> Also, I cannot connect to the database with a dataadapter in vs (2003)
> I can, however, execute an SQL in Query Analyzer.
> I have reinstalled several times. Some of the Google articles suggest tha
t
> it might be MDAC. I cannot install MDAC either. It says that the operatio
n
> is not supported by the OS (xp Pro) The components are already installed.
> Any input would be greatly appreciated.|||I just ran into this issue myself, I've tried the reinstall etc. I'm going
to try and un-register/re-register all of the DLLs in that directory but
there are 46 of them. Any suggestions on an easy way to do that?
I also tried the suggestions in Article ID: 315868.
Cory Blythe
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> A few questions!
> Did you try and remove the software before re-installing?
> Did you rung the MDAC component checker to see if it says your installatio
n
> is consistent?
> Have you tried to apply any service packs?
> You may wish to un-register/re-register all the dlls in {Installation
> Directory}\80\Tools\Binn?
> John
> "walter1234" wrote:
>

problem with enterprise manager

I have a problem with SQL Server 7 Standard edition, when i select a database in Enterprise Manager and i want to see the content of tables, i can't see anything: I can see all tables but when i choice "Open Table " and "Return all rows", i see only the menu bar on the top, and all page is blank. :confused:
This problem is on all database, and on all tables, include the system database (as Master).
If i use query analyzer i can work without probems.

Thank in advance

FrancescoSounds like you need to do a reinstal of the client tools.

Why not so a trace for the crack using sqltrace(profiler)?

something is busted though.

Problem with deleting connection from Connection Manager

Hallo,

I have deleted one of my file connection from Connection Manager (and

Executed ProcessTask which used it), however

trying to load the package I always get the error:

"Error loading MyPackage.dtsx: The connection "MyDeletedConnectionName" is not found.
This error is thrown by Connections collection when the specific connection element is not found."

I tried to Clean, Rebulid my project, but it doesn't help.

Does anybody know, how to solve it? Where this reference is saved?

Thank you.

Anna

Try to open the package XML in a text editor and look for that connection name.

HTH,

Bob

|||

I am sorry, it was my mistake -

I forgot to delete the configuration file...

it works fine now.

Anna