Managed index in Fuzzy Lookup Error

If we run the package with fuzzy lookup without selecting the "manage index" option it runs great and select the data and inserts data within the table as expected.

If we run the sam package after selecting the option for "manage index" it gives error:

Error: 0xC0202009 at Data Flow Task, Composite Lookup [15209]: An OLE DB error has occurred. Error code: 0x80040E14.

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "A .NET Framework error occurred during execution of user defined routine or aggregate 'sp_FuzzyLookupTableMaintenanceInstall':

OK this becasue there is a known issue in SQL server 2005 June CTP. Its not there in Sep CTP

Managed index in Fuzzy Lookup Error

If we run the package with fuzzy lookup without selecting the "manage index" option it runs great and select the data and inserts data within the table as expected.

If we run the sam package after selecting the option for "manage index" it gives error:

Error: 0xC0202009 at Data Flow Task, Composite Lookup [15209]: An OLE DB error has occurred. Error code: 0x80040E14.

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "A .NET Framework error occurred during execution of user defined routine or aggregate 'sp_FuzzyLookupTableMaintenanceInstall':

OK this becasue there is a known issue in SQL server 2005 June CTP. Its not there in Sep CTP

Making an Access - SQL db solution portable

I have an Access application which runs in a server enviroment where I have
an SQL server that the Access connects to. The customer is so happy with my
soultion and told another company about it, they would like something like
that, so I need to make a copy of the setup to a cd to send to the other
company - as a demo. They have no employees with enough IT knowledge to
install a SQL Server/MSDE and the import the database and setting up Access
to connect to the new server. Remote control is not an option, neither is
"local control" since they will not pay for my trip (transatlantic) unless
they want me to make a soultion for them...
I need to take the solution and make it portable. But I am not sure how to
do it, I need a "downsizing" wizard or something? A solution could be to
make "some kind of installer" which installes a MSDE and loads the data into
it and connects the Access database to the new db server. Probably the best
solution, if there is no easy way to make it portable.
I would asume there are some tools available for this or similar purposes,
but I don't know any...
My concern is also the fact that there are some views in the SQL database
and also a lot of the VBA code in forms and reports has been modified to fit
the SQL, during upsizing some years back... I wouldn't like to re-write the
rewritten code, just for a demo.
I'm pretty sure I'm not the only one who has ever wanted to do this, if you
have done it, please let me know how. I welcome any suggestions. :o)
Thanks in advance
Martin Gregersen
martin@.gregersen.dkHow about a simple mssql backup of the database?
Then they could just import the backup database on their system
Pieter
"Martin Gregersen" <martin@.gregersen.dk> wrote in message
news:eWiKjFUlGHA.2420@.TK2MSFTNGP04.phx.gbl...
>I have an Access application which runs in a server enviroment where I have
>an SQL server that the Access connects to. The customer is so happy with my
>soultion and told another company about it, they would like something like
>that, so I need to make a copy of the setup to a cd to send to the other
>company - as a demo. They have no employees with enough IT knowledge to
>install a SQL Server/MSDE and the import the database and setting up Access
>to connect to the new server. Remote control is not an option, neither is
>"local control" since they will not pay for my trip (transatlantic) unless
>they want me to make a soultion for them...
> I need to take the solution and make it portable. But I am not sure how to
> do it, I need a "downsizing" wizard or something? A solution could be to
> make "some kind of installer" which installes a MSDE and loads the data
> into it and connects the Access database to the new db server. Probably
> the best solution, if there is no easy way to make it portable.
> I would asume there are some tools available for this or similar purposes,
> but I don't know any...
> My concern is also the fact that there are some views in the SQL database
> and also a lot of the VBA code in forms and reports has been modified to
> fit the SQL, during upsizing some years back... I wouldn't like to
> re-write the rewritten code, just for a demo.
> I'm pretty sure I'm not the only one who has ever wanted to do this, if
> you have done it, please let me know how. I welcome any suggestions. :o)
> Thanks in advance
> Martin Gregersen
> martin@.gregersen.dk
>
>|||How about a simple mssql backup of the database?
Then they could just import the backup database on their system
Pieter
"Martin Gregersen" <martin@.gregersen.dk> wrote in message
news:eWiKjFUlGHA.2420@.TK2MSFTNGP04.phx.gbl...
>I have an Access application which runs in a server enviroment where I have
>an SQL server that the Access connects to. The customer is so happy with my
>soultion and told another company about it, they would like something like
>that, so I need to make a copy of the setup to a cd to send to the other
>company - as a demo. They have no employees with enough IT knowledge to
>install a SQL Server/MSDE and the import the database and setting up Access
>to connect to the new server. Remote control is not an option, neither is
>"local control" since they will not pay for my trip (transatlantic) unless
>they want me to make a soultion for them...
> I need to take the solution and make it portable. But I am not sure how to
> do it, I need a "downsizing" wizard or something? A solution could be to
> make "some kind of installer" which installes a MSDE and loads the data
> into it and connects the Access database to the new db server. Probably
> the best solution, if there is no easy way to make it portable.
> I would asume there are some tools available for this or similar purposes,
> but I don't know any...
> My concern is also the fact that there are some views in the SQL database
> and also a lot of the VBA code in forms and reports has been modified to
> fit the SQL, during upsizing some years back... I wouldn't like to
> re-write the rewritten code, just for a demo.
> I'm pretty sure I'm not the only one who has ever wanted to do this, if
> you have done it, please let me know how. I welcome any suggestions. :o)
> Thanks in advance
> Martin Gregersen
> martin@.gregersen.dk
>
>
---
I am using the free version of SPAMfighter for private users.
It has removed 4026 spam emails to date.
Paying users do not have this message in their emails.
Get the free SPAMfighter here: http://www.spamfighter.com/len|||I would say tell them to install MSDE and be done with it. If that's not an
option maybe you could set up a remote demo over the internet? Run it
locally on your computer and let them view it in the web browser using
NetMeeting or whatever.
"Martin Gregersen" <martin@.gregersen.dk> wrote in message
news:eWiKjFUlGHA.2420@.TK2MSFTNGP04.phx.gbl...
>I have an Access application which runs in a server enviroment where I have
>an SQL server that the Access connects to. The customer is so happy with my
>soultion and told another company about it, they would like something like
>that, so I need to make a copy of the setup to a cd to send to the other
>company - as a demo. They have no employees with enough IT knowledge to
>install a SQL Server/MSDE and the import the database and setting up Access
>to connect to the new server. Remote control is not an option, neither is
>"local control" since they will not pay for my trip (transatlantic) unless
>they want me to make a soultion for them...
> I need to take the solution and make it portable. But I am not sure how to
> do it, I need a "downsizing" wizard or something? A solution could be to
> make "some kind of installer" which installes a MSDE and loads the data
> into it and connects the Access database to the new db server. Probably
> the best solution, if there is no easy way to make it portable.
> I would asume there are some tools available for this or similar purposes,
> but I don't know any...
> My concern is also the fact that there are some views in the SQL database
> and also a lot of the VBA code in forms and reports has been modified to
> fit the SQL, during upsizing some years back... I wouldn't like to
> re-write the rewritten code, just for a demo.
> I'm pretty sure I'm not the only one who has ever wanted to do this, if
> you have done it, please let me know how. I welcome any suggestions. :o)
> Thanks in advance
> Martin Gregersen
> martin@.gregersen.dk
>
>|||Hi Martin,
Actually - you can make a setup, which will install MSDE, attach database
and then install all necessary components to run your application - but this
also time consuming task if you never did so.
I think that installing your application on windowsxp and then let them
connect to it with remote desktop it order to try - is most realistic option
for you
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com
"Martin Gregersen" <martin@.gregersen.dk> wrote in message
news:eWiKjFUlGHA.2420@.TK2MSFTNGP04.phx.gbl...
>I have an Access application which runs in a server enviroment where I have
>an SQL server that the Access connects to. The customer is so happy with my
>soultion and told another company about it, they would like something like
>that, so I need to make a copy of the setup to a cd to send to the other
>company - as a demo. They have no employees with enough IT knowledge to
>install a SQL Server/MSDE and the import the database and setting up Access
>to connect to the new server. Remote control is not an option, neither is
>"local control" since they will not pay for my trip (transatlantic) unless
>they want me to make a soultion for them...
> I need to take the solution and make it portable. But I am not sure how to
> do it, I need a "downsizing" wizard or something? A solution could be to
> make "some kind of installer" which installes a MSDE and loads the data
> into it and connects the Access database to the new db server. Probably
> the best solution, if there is no easy way to make it portable.
> I would asume there are some tools available for this or similar purposes,
> but I don't know any...
> My concern is also the fact that there are some views in the SQL database
> and also a lot of the VBA code in forms and reports has been modified to
> fit the SQL, during upsizing some years back... I wouldn't like to
> re-write the rewritten code, just for a demo.
> I'm pretty sure I'm not the only one who has ever wanted to do this, if
> you have done it, please let me know how. I welcome any suggestions. :o)
> Thanks in advance
> Martin Gregersen
> martin@.gregersen.dk
>
>|||Hi Alex
I would like if you could tell me how to make such an installer, then I will
know and can make the best decission. They really need a copy to play with,
not just a demonstration online, they need to take every process of their
production into consideration and then see would features they like/dislike
and so on.
Also I would like to know just to know ;o)
Thanks
Martin
"Alex Dybenko" <alexdyb@.PLEASE.cemi.NO.rssi.SPAM.ru> wrote in message
news:OzFt1nUlGHA.1208@.TK2MSFTNGP02.phx.gbl...
> Hi Martin,
> Actually - you can make a setup, which will install MSDE, attach database
> and then install all necessary components to run your application - but
> this also time consuming task if you never did so.
> I think that installing your application on windowsxp and then let them
> connect to it with remote desktop it order to try - is most realistic
> option for you
>
> --
> Best regards,
> ___________
> Alex Dybenko (MVP)
> http://alexdyb.blogspot.com
> http://www.PointLtd.com
>
> "Martin Gregersen" <martin@.gregersen.dk> wrote in message
> news:eWiKjFUlGHA.2420@.TK2MSFTNGP04.phx.gbl...
>|||Hi Martin,
personally - I use Wise installation system, but you can also try some free
installer, for example see
http://alexdyb.blogspot.com/2006/04...-installer.html
then you can download MSDE setup package from Microsoft site, and include in
your package
now you need to build a script to run MSDE setup, copy database files,
application files, attach database (I use attachDB to do so:
http://www.pointltd.com/Products/Details.asp?dlID=46)
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com
"Martin Gregersen" <martin@.gregersen.dk> wrote in message
news:uEFXGfclGHA.4708@.TK2MSFTNGP04.phx.gbl...
> Hi Alex
> I would like if you could tell me how to make such an installer, then I
> will know and can make the best decission. They really need a copy to play
> with, not just a demonstration online, they need to take every process of
> their production into consideration and then see would features they
> like/dislike and so on.
> Also I would like to know just to know ;o)
> Thanks
> Martin
>
> "Alex Dybenko" <alexdyb@.PLEASE.cemi.NO.rssi.SPAM.ru> wrote in message
> news:OzFt1nUlGHA.1208@.TK2MSFTNGP02.phx.gbl...
>

Make SQL Server Agent job stop after X minutes

I swear there is a way in SQL 2000 to have a SQL Server Agent job (that runs
a DTS) to stop running if it's been running for X minutes. I can't find it
though. I thought it was just a checkbox and a field for a number somewhere.
any ideas?Rich
sp_trace_setstatus @.traceid = @.TraceID, @.status = 0
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:C99F8FAF-A4AE-40B5-B12E-B380E258A127@.microsoft.com...
>I swear there is a way in SQL 2000 to have a SQL Server Agent job (that
>runs
> a DTS) to stop running if it's been running for X minutes. I can't find
> it
> though. I thought it was just a checkbox and a field for a number
> somewhere.
> any ideas?

major difference between sp and trigger

hi
stored procedure and trigger which runs on serverside and which runs on client side.

---

Dear Kanthk,

Have a look at this :

http://www.sqlservercentral.com/columnists/gvijayakumar/storedprocedurevstriggers.asp

HTH,

Suprotim Agarwal

Maintenance plans

I am not sure if this is the correct forum, but here goes.
can anyone tell my what account (SQL Agent or SQL Server) runs Maintenance
plans? I always thought it was the Agent that ran all jobs on the server. I
am using 2 different Accounts, one for server and the other for Agent. the
server keeps trying to log onto the server where my backups are going not
Agent. Is this the way it's supposed to be?
Thanks,
Joe
Agent executes an xp which in turn executes an exe file which logs on to SQL Server and execute the
BACKUP command and then SQL Server tries to access the drive where to put the backup. So, it is SQL
Server that need permission.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"jaylou" <jaylou@.discussions.microsoft.com> wrote in message
news:46733E11-AF11-4398-AC8F-4F6FE694A54D@.microsoft.com...
>I am not sure if this is the correct forum, but here goes.
> can anyone tell my what account (SQL Agent or SQL Server) runs Maintenance
> plans? I always thought it was the Agent that ran all jobs on the server. I
> am using 2 different Accounts, one for server and the other for Agent. the
> server keeps trying to log onto the server where my backups are going not
> Agent. Is this the way it's supposed to be?
> Thanks,
> Joe
|||Thank you!
"Tibor Karaszi" wrote:

> Agent executes an xp which in turn executes an exe file which logs on to SQL Server and execute the
> BACKUP command and then SQL Server tries to access the drive where to put the backup. So, it is SQL
> Server that need permission.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "jaylou" <jaylou@.discussions.microsoft.com> wrote in message
> news:46733E11-AF11-4398-AC8F-4F6FE694A54D@.microsoft.com...
>