DATASOUCE problem with SQL CLIENT from POCKET PC

I've been struggling to put together an install setup for an app on a pocket
pc. This app accesses a network SQL 2005 server.
I finally got things working - found some .CAB's that needed to be installed
on the PPC for SQL CE and SQL CLIENT.
But now I'm getting an odd error. In my SQL connection string I'm
specifying DATASOURCE=SPSERVER (which is the network server for SQL 2005 on
our domain). But instead it's connecting to a laptop SQL 2000 instance -
laptop name is FPS-LAP-SZ. I've googled for a bug like this and found no
info.
How do I guarantee the latest .CAB's for SQL CE and SQL CLIENT for my PPC
install?Hello Steve!
Correction: It's "Data Source=" or "Server=" not "DATASOURCE="
You may find the latest version of SQL Server CE from the following link:
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=85e0c3ce-3fa1-453a-8ce9-af6ca20946c3
Ekrem Ã?nsoy
"Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
news:7508FAC3-F20E-4AB9-85AF-8E02782751D2@.microsoft.com...
> I've been struggling to put together an install setup for an app on a
> pocket
> pc. This app accesses a network SQL 2005 server.
> I finally got things working - found some .CAB's that needed to be
> installed
> on the PPC for SQL CE and SQL CLIENT.
> But now I'm getting an odd error. In my SQL connection string I'm
> specifying DATASOURCE=SPSERVER (which is the network server for SQL 2005
> on
> our domain). But instead it's connecting to a laptop SQL 2000 instance -
> laptop name is FPS-LAP-SZ. I've googled for a bug like this and found no
> info.
> How do I guarantee the latest .CAB's for SQL CE and SQL CLIENT for my PPC
> install?|||I have "DATA SOURCE=SPSERVER" - I typed it wrong in my post.
How about the latest download for SQL CLIENT for PPC?
"Ekrem Ã?nsoy" wrote:
> Hello Steve!
>
> Correction: It's "Data Source=" or "Server=" not "DATASOURCE="
> You may find the latest version of SQL Server CE from the following link:
> http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=85e0c3ce-3fa1-453a-8ce9-af6ca20946c3
>
> --
> Ekrem Ã?nsoy
>
> "Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
> news:7508FAC3-F20E-4AB9-85AF-8E02782751D2@.microsoft.com...
> > I've been struggling to put together an install setup for an app on a
> > pocket
> > pc. This app accesses a network SQL 2005 server.
> >
> > I finally got things working - found some .CAB's that needed to be
> > installed
> > on the PPC for SQL CE and SQL CLIENT.
> >
> > But now I'm getting an odd error. In my SQL connection string I'm
> > specifying DATASOURCE=SPSERVER (which is the network server for SQL 2005
> > on
> > our domain). But instead it's connecting to a laptop SQL 2000 instance -
> > laptop name is FPS-LAP-SZ. I've googled for a bug like this and found no
> > info.
> >
> > How do I guarantee the latest .CAB's for SQL CE and SQL CLIENT for my PPC
> > install?
>

Dataflow with 2 lookup using the same Table

Hi there

I'm getting into trouble everytime I want to setup a dataflow containing 2 or more flows, where I want to make a lookup into 1 other table.

This fails, of some reason I do not know of.

ex.

Table 1 -> Lookup Currency Table -> Table2 with currency
Table 3 -> Lookup Currency Table -> Table 4 with currency

One of the lookup will fail.

How do you avoid this?

/Bjarne

You meant, you have more than 1 source component in your data flow that goes independently of each other toward different lookup transformations?

How are you setting the lookup transformations? You shoud use a query to get only the columns you need and since the lookup table is used concurrently; you may want to use nolock hint to avoid deadlocks.

Are you actually receiving any error message?

Rafael Salas

Datafile limitations per database

How many mdf files can you use in comprising one database. I know one can
setup primary & secondary but how far down the list can it go? Can you have
30 files (each limited to 50GB)?You are well within the limits of SQL Server. One database can have over 32,
000 files 4 TB each.
You can look-up 'maximum capacity specifications' in BOL.
DeeJay
"kisstene" wrote:
> How many mdf files can you use in comprising one database. I know one can
> setup primary & secondary but how far down the list can it go? Can you have
> 30 files (each limited to 50GB)?

data-driven subscription not available

I would like to setup a data-driven subscription for a report, but the New
Data-driven Subscription button is not available on the subscription page -
only the New Subscription button appears. I have checked that the report
uses a custom data source and stores the user name and password credentials
in the report server. The account that I am using to access Report Manager
is in the System Administrators role and the Content Manager role for the
report. What am I missing?
Thanks,
RobertDo you have Enterprise Edition? This feature is not available in Standard
Edition.
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"RMac" <@.news.postalias> wrote in message
news:EC568923-1967-44FE-8A17-4E2E67AC53D2@.microsoft.com...
>I would like to setup a data-driven subscription for a report, but the New
> Data-driven Subscription button is not available on the subscription
> page -
> only the New Subscription button appears. I have checked that the report
> uses a custom data source and stores the user name and password
> credentials
> in the report server. The account that I am using to access Report
> Manager
> is in the System Administrators role and the Content Manager role for the
> report. What am I missing?
> Thanks,
> Robert|||That is the problem then. I was not aware that Data-driven subscriptions
are not available in Standard Edition. Thanks Jasper.
"Jasper Smith" wrote:
> Do you have Enterprise Edition? This feature is not available in Standard
> Edition.
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "RMac" <@.news.postalias> wrote in message
> news:EC568923-1967-44FE-8A17-4E2E67AC53D2@.microsoft.com...
> >I would like to setup a data-driven subscription for a report, but the New
> > Data-driven Subscription button is not available on the subscription
> > page -
> > only the New Subscription button appears. I have checked that the report
> > uses a custom data source and stores the user name and password
> > credentials
> > in the report server. The account that I am using to access Report
> > Manager
> > is in the System Administrators role and the Content Manager role for the
> > report. What am I missing?
> > Thanks,
> > Robert
>
>

Databases mirrong configuration question!

Hi all,
i could not find the answer to this on the net so i asked it here.
If i setup mirroring with standard config:
1 server with sql5000 server with 1 named instance (principal)
1 server with sql5000 server with 1 named instance (mirror)
1 server with sql5000 server with 1 named instance( witness)
Then i add a second named instance on the principal with some databases.
Must i setup an new config with witness and mirror to setp mirroring for
these databases?Or is it just simply selecting the databases in the new
instance and mirror them to the existing Mirror server and witness?
Many thx
--
I drank alot of beer and ended up in the police department database.
Drank more beer and learned SQL in the dark hours.
DELETE FROM offenders WHERE Title=''MrAA'' AND Year=2006;
I love SQL Oeps....correction in my hurry i typed sql5000.... that will take while.
..
Offcourse i mean SQL 2005 and a normal server ...not clustered.
--
"Hate_orphaned_users" wrote:

> Hi all,
> i could not find the answer to this on the net so i asked it here.
> If i setup mirroring with standard config:
> 1 server with sql5000 server with 1 named instance (principal)
> 1 server with sql5000 server with 1 named instance (mirror)
> 1 server with sql5000 server with 1 named instance( witness)
> Then i add a second named instance on the principal with some databases.
> Must i setup an new config with witness and mirror to setp mirroring for
> these databases?Or is it just simply selecting the databases in the new
> instance and mirror them to the existing Mirror server and witness?
> Many thx
> --
> I drank alot of beer and ended up in the police department database.
> Drank more beer and learned SQL in the dark hours.
> DELETE FROM offenders WHERE Title=''MrAA'' AND Year=2006;
> I love SQL
>|||You use the same endpoints on the mirror and the witness. On the new instanc
e, you need to add the
endpoint. Then you need to do the BACKUP and ALTER DATABASE commands to enab
le mirroring.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Hate_orphaned_users" <Hateorphanedusers@.discussions.microsoft.com> wrote in
message
news:F4701A29-BF15-477C-A036-8E4FA2189F8D@.microsoft.com...[vbcol=seagreen]
> Oeps....correction in my hurry i typed sql5000.... that will take whil
e...
> Offcourse i mean SQL 2005 and a normal server ...not clustered.
> --
>
>
> "Hate_orphaned_users" wrote:
>|||thx !
--
"Tibor Karaszi" wrote:

> You use the same endpoints on the mirror and the witness. On the new insta
nce, you need to add the
> endpoint. Then you need to do the BACKUP and ALTER DATABASE commands to en
able mirroring.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Hate_orphaned_users" <Hateorphanedusers@.discussions.microsoft.com> wrote
in message
> news:F4701A29-BF15-477C-A036-8E4FA2189F8D@.microsoft.com...
>

Databases mirrong configuration question!

Hi all,
i could not find the answer to this on the net so i asked it here.
If i setup mirroring with standard config:
1 server with sql5000 server with 1 named instance (principal)
1 server with sql5000 server with 1 named instance (mirror)
1 server with sql5000 server with 1 named instance( witness)
Then i add a second named instance on the principal with some databases.
Must i setup an new config with witness and mirror to setp mirroring for
these databases?Or is it just simply selecting the databases in the new
instance and mirror them to the existing Mirror server and witness?
Many thx
I drank alot of beer and ended up in the police department database.
Drank more beer and learned SQL in the dark hours.
DELETE FROM offenders WHERE Title=''MrAA'' AND Year=2006;
I love SQL
Oeps....correction in my hurry i typed sql5000.... that will take while...
Offcourse i mean SQL 2005 and a normal server ...not clustered.
"Hate_orphaned_users" wrote:

> Hi all,
> i could not find the answer to this on the net so i asked it here.
> If i setup mirroring with standard config:
> 1 server with sql5000 server with 1 named instance (principal)
> 1 server with sql5000 server with 1 named instance (mirror)
> 1 server with sql5000 server with 1 named instance( witness)
> Then i add a second named instance on the principal with some databases.
> Must i setup an new config with witness and mirror to setp mirroring for
> these databases?Or is it just simply selecting the databases in the new
> instance and mirror them to the existing Mirror server and witness?
> Many thx
> --
> I drank alot of beer and ended up in the police department database.
> Drank more beer and learned SQL in the dark hours.
> DELETE FROM offenders WHERE Title=''MrAA'' AND Year=2006;
> I love SQL
>
|||You use the same endpoints on the mirror and the witness. On the new instance, you need to add the
endpoint. Then you need to do the BACKUP and ALTER DATABASE commands to enable mirroring.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Hate_orphaned_users" <Hateorphanedusers@.discussions.microsoft.com> wrote in message
news:F4701A29-BF15-477C-A036-8E4FA2189F8D@.microsoft.com...[vbcol=seagreen]
> Oeps....correction in my hurry i typed sql5000.... that will take while...
> Offcourse i mean SQL 2005 and a normal server ...not clustered.
> --
>
>
> "Hate_orphaned_users" wrote:
|||thx !
"Tibor Karaszi" wrote:

> You use the same endpoints on the mirror and the witness. On the new instance, you need to add the
> endpoint. Then you need to do the BACKUP and ALTER DATABASE commands to enable mirroring.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Hate_orphaned_users" <Hateorphanedusers@.discussions.microsoft.com> wrote in message
> news:F4701A29-BF15-477C-A036-8E4FA2189F8D@.microsoft.com...
>

Databases mirrong configuration question!

Hi all,
i could not find the answer to this on the net so i asked it here.
If i setup mirroring with standard config:
1 server with sql5000 server with 1 named instance (principal)
1 server with sql5000 server with 1 named instance (mirror)
1 server with sql5000 server with 1 named instance( witness)
Then i add a second named instance on the principal with some databases.
Must i setup an new config with witness and mirror to setp mirroring for
these databases?Or is it just simply selecting the databases in the new
instance and mirror them to the existing Mirror server and witness?
Many thx
--
I drank alot of beer and ended up in the police department database.
Drank more beer and learned SQL in the dark hours.
DELETE FROM offenders WHERE Title=''MrAA'' AND Year=2006;
I love SQL :)Oeps....correction in my hurry i typed sql5000....:) that will take while...
Offcourse i mean SQL 2005 and a normal server ...not clustered.
--
"Hate_orphaned_users" wrote:
> Hi all,
> i could not find the answer to this on the net so i asked it here.
> If i setup mirroring with standard config:
> 1 server with sql5000 server with 1 named instance (principal)
> 1 server with sql5000 server with 1 named instance (mirror)
> 1 server with sql5000 server with 1 named instance( witness)
> Then i add a second named instance on the principal with some databases.
> Must i setup an new config with witness and mirror to setp mirroring for
> these databases?Or is it just simply selecting the databases in the new
> instance and mirror them to the existing Mirror server and witness?
> Many thx
> --
> I drank alot of beer and ended up in the police department database.
> Drank more beer and learned SQL in the dark hours.
> DELETE FROM offenders WHERE Title=''MrAA'' AND Year=2006;
> I love SQL :)
>|||You use the same endpoints on the mirror and the witness. On the new instance, you need to add the
endpoint. Then you need to do the BACKUP and ALTER DATABASE commands to enable mirroring.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Hate_orphaned_users" <Hateorphanedusers@.discussions.microsoft.com> wrote in message
news:F4701A29-BF15-477C-A036-8E4FA2189F8D@.microsoft.com...
> Oeps....correction in my hurry i typed sql5000....:) that will take while...
> Offcourse i mean SQL 2005 and a normal server ...not clustered.
> --
>
>
> "Hate_orphaned_users" wrote:
>> Hi all,
>> i could not find the answer to this on the net so i asked it here.
>> If i setup mirroring with standard config:
>> 1 server with sql5000 server with 1 named instance (principal)
>> 1 server with sql5000 server with 1 named instance (mirror)
>> 1 server with sql5000 server with 1 named instance( witness)
>> Then i add a second named instance on the principal with some databases.
>> Must i setup an new config with witness and mirror to setp mirroring for
>> these databases?Or is it just simply selecting the databases in the new
>> instance and mirror them to the existing Mirror server and witness?
>> Many thx
>> --
>> I drank alot of beer and ended up in the police department database.
>> Drank more beer and learned SQL in the dark hours.
>> DELETE FROM offenders WHERE Title=''MrAA'' AND Year=2006;
>> I love SQL :)
>>|||thx !
--
"Tibor Karaszi" wrote:
> You use the same endpoints on the mirror and the witness. On the new instance, you need to add the
> endpoint. Then you need to do the BACKUP and ALTER DATABASE commands to enable mirroring.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Hate_orphaned_users" <Hateorphanedusers@.discussions.microsoft.com> wrote in message
> news:F4701A29-BF15-477C-A036-8E4FA2189F8D@.microsoft.com...
> > Oeps....correction in my hurry i typed sql5000....:) that will take while...
> > Offcourse i mean SQL 2005 and a normal server ...not clustered.
> > --
> >
> >
> >
> >
> >
> > "Hate_orphaned_users" wrote:
> >
> >> Hi all,
> >>
> >> i could not find the answer to this on the net so i asked it here.
> >> If i setup mirroring with standard config:
> >> 1 server with sql5000 server with 1 named instance (principal)
> >> 1 server with sql5000 server with 1 named instance (mirror)
> >> 1 server with sql5000 server with 1 named instance( witness)
> >> Then i add a second named instance on the principal with some databases.
> >> Must i setup an new config with witness and mirror to setp mirroring for
> >> these databases?Or is it just simply selecting the databases in the new
> >> instance and mirror them to the existing Mirror server and witness?
> >>
> >> Many thx
> >> --
> >> I drank alot of beer and ended up in the police department database.
> >> Drank more beer and learned SQL in the dark hours.
> >> DELETE FROM offenders WHERE Title=''MrAA'' AND Year=2006;
> >> I love SQL :)
> >>
> >>
>

Databases Location

Hi all,

Need Some Advice…

Current Setup of the Databases:

All “system databases” + “reportserver & reportservertempdb”are on “ D drive” Raid 1 ( Mirrored)and their location is : D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data

Free Space left on "D" Drive is # 18 Gb.

“User Databases” are on - “E Drive” Raid 5 and their location is E:\Data\db\

Now , we got new storage device with much larger capacity. So, we are planning to transfer our databases on this new drive which is “RAID 5”.

My question is:

(1) Should I transfer all the databases ( (i.e.) “system databases”+ “reportserver & ReportServerTempdb” + “User databases”) on that new drive ( RAID 5).

(OR)

(2) Keep the “system databases” + “ReportServer& ReportServerTempdb” on the old

drive (i.e.) RAID 1andTransfer only the “USER Databases” on that new drive (i.e.) RAID 5.

(OR)

(3) Transter only Tempdb to the new drive (i.e.) on Raid 5, so as to avoid any I/O congestion. and keep all other system & ReportServer & ReportServerTempdb on the old "D"drive.

(OR)

(4) Is there anything I should be careful when doing this& Is there any better way of doing this….

Thanks for all your help….

Hi, this is a big topic area, so I can only give generic advice based on what you have said in your posting.

The things you want to split up (get onto seperate drives) are:

1) TempDb

2) Your user mdb files

3) your user ldf files

Usually the best performance drives are raid 1+0 for these, but in practice for your setup:

Put your ldf (log files) on your RAID 1 (mirrored) drives and your mdf (database) files on the RAID 5 drive. Depending on how you are using your tempdb and the size of it, it could be worth placing this on the system (i'm assuming C drive.

Hope this helps.

|||Here's what I'd do although there are a lot of variables.

I'd leave the system databases and the ReportServer db's on the RAID 1. I'd move the user database log files only and TempDB to the new RAID array. (I assume you have one TempDB file per cpu.)

This way, you're separating your log I/O from your data I/O. Ideally, you'd have your TempDB on it's own RAID-5 (although RAID 10 is better since you get striping and mirroring) array if you had another device. The only qualifier might be if your databases are using the FULL recovery model and they are update intensive. If that were the case I would probably recommend putting the log file of the database that is most heavily updated on it's own device. Log files are written sequentially so the READ/WRITE heads would not move between updates and you'd get a little performance gain that way.

Just fyi, the more spindles the better. Because you really only have three logical devices available to you your optimization options are fairly limited. The fact that you're using RAID-5 indicates that there are multiple devices striped together but the parity overhead is a killer for write performance. I always recommend RAID-10 to my clients. You'll get far better overall performance but the tradeoff is that it's more expensive. Sometimes I lose that battle but they do it with their eyes open.
|||

Yes, i agree that temdb and log files should be there on RAID 1, but here its already Raid 5, we cant help , and both log files and data files are stored together on the same Raid 5.

Its not OLTP, its batch processing .

So, with the given requirement, what will be the best place for "system+ user + Reportserver & Reportservertempdb", Databases, in the new environment (i.e.) on the new drive.

So, what the suggestion now

Thanks again for all your help...

|||Define "batch" processing. Are the batches update intensive? Do they do a lot of sorting? Are there a lot of temp tables or table variables involved? Are the transactions short and sweet or do they involve thousands of rows before a commit occurs?

I would NOT put the tempdb or the log files on RAID 1 because you would lose the benefit of striping which distributes the I/O across multiple spindles.

You can re-distribute data or log files at any time using the ALTER DATABASE statement. At least you can in SQL 2005. I'm not sure what the procedure is in SQL 2000 but I'm sure it's possible.

DatabaseMail setup problems

I'm bust to setup a mail nothification system by using DatabaseMail.
The setup of the database mail was ok. I'm able to send a test mail.
After that I modified the SQLAgent's Alert system. I enabled the mail profile and as Mailsystem i choosed Database Mail with the mail profile the one I created in during the database mail setup.

No I like to use this when a job fails or an alert is fired. So I created an operator.
Give it the name SQLMAil and e-mailname
- first try a normal e-mail address vname.name@.provider.be
- second try the database mail profilename (SQLMAIL)

I created also an alert theat make use of this operator.

When the alert fires, it doesn't send a mail because of a failure.
We have always the following message in SQL Agent log:

Log SQL Agent (Current - 30/11/2005 09:35:00)

Message
[264] An attempt was made to send an email when no email session has been established
What did I do wrong. Can someone help me?

I am having the exact same problem. Exact.|||Are you seeing this on 64 bit platform. If so we have a tracking bug that will be addressed in the next public release.

If you see this on 32 bit platform then this is different. I can follow up to figure what could be the reason.

Thanks,
Gops Dwarak|||It is an HP 585 system with 2 dual core AMD opteron CPU's running with W2003 X64 version. SQL2005 for X64 bit system has been installed.

Greetings
Ludo Bernaerts|||You see this on 64 bit platform. We have tracking bug for this and is expected to be addressed in next service pack.

For now the workaround is to use Agent Mail.

Gops Dwarak|||When will this bug-fix be available?

Agentmail is possible but can we install a small Exchange client on X64 bit servers like we did on 32 bit servers with Exchange client 5.0.|||

There is a workaround to use DBMail for notifications, till the next Service pack that address this bug. On Alert, trigger a job and the job step calling sp_notify_operator should help.

Gops Dwarak

|||I'm having the exact same problem on 32bit system the sql instance is running on a Virtual Server with sql agent on a a svc account and smtphost configured with Outlook Express on same svc account session and test works and test mail from OE works with apllication warned unflagged.

DatabaseMail setup problems

I'm bust to setup a mail nothification system by using DatabaseMail.
The setup of the database mail was ok. I'm able to send a test mail.
After that I modified the SQLAgent's Alert system. I enabled the mail profile and as Mailsystem i choosed Database Mail with the mail profile the one I created in during the database mail setup.

No I like to use this when a job fails or an alert is fired. So I created an operator.
Give it the name SQLMAil and e-mailname
- first try a normal e-mail address vname.name@.provider.be
- second try the database mail profilename (SQLMAIL)

I created also an alert theat make use of this operator.

When the alert fires, it doesn't send a mail because of a failure.
We have always the following message in SQL Agent log:

Log SQL Agent (Current - 30/11/2005 09:35:00)

Message
[264] An attempt was made to send an email when no email session has been established
What did I do wrong. Can someone help me?

I am having the exact same problem. Exact.|||Are you seeing this on 64 bit platform. If so we have a tracking bug that will be addressed in the next public release.

If you see this on 32 bit platform then this is different. I can follow up to figure what could be the reason.

Thanks,
Gops Dwarak|||It is an HP 585 system with 2 dual core AMD opteron CPU's running with W2003 X64 version. SQL2005 for X64 bit system has been installed.

Greetings
Ludo Bernaerts|||You see this on 64 bit platform. We have tracking bug for this and is expected to be addressed in next service pack.

For now the workaround is to use Agent Mail.

Gops Dwarak|||When will this bug-fix be available?

Agentmail is possible but can we install a small Exchange client on X64 bit servers like we did on 32 bit servers with Exchange client 5.0.|||

There is a workaround to use DBMail for notifications, till the next Service pack that address this bug. On Alert, trigger a job and the job step calling sp_notify_operator should help.

Gops Dwarak

|||I'm having the exact same problem on 32bit system the sql instance is running on a Virtual Server with sql agent on a a svc account and smtphost configured with Outlook Express on same svc account session and test works and test mail from OE works with apllication warned unflagged.

databasemail setup for SQL 2005 Express

I have installed SQL 2005 Express with all options and turned on the database mail SP's in the surface area configuration, When I try to use database mail the entry in allitems is created but it is never sent. I followed the troubleshooting guides and find that databasemail90.exe was never installed in the binn folder. How can I get this file and whatever else might be missing to make this functionality work?Database Mail is not supported on SQL 2005 Express Edition.

database trigger question

Hi

I am trying to setup a trigger on a database where the trigger fires off a store proc when there is an insert. For some reason, its working on a database in Dev and not on a database in QA.

the trigger is on an insert to a table, the trigger looks something like this

create trigger XXX

after Insert

SET XACT_ABORT OFF -- this so that when the proc attached to the trigger fails, insert it anyway

exec updatesomething

if @.@.error <> 0

exec createAudit

In dev, the row is inserted, but in QA the row is not. I did a trace, both have the SQL:BatchCompleted event of the insert sql statement, but in QA environment, the trace does not have the sql statement after exec updatesomething. it just stops at exec updatesomething.

I check the database settings to make sure there were the same, looks like they are, I do not know how to find out what is causing it to work in 1 database and not the other

thanks

Pauli

A few things to check for -

Make sure that the trigger exists and is enabled -- select objectproperty(object_id('dbo.XXX'), 'ExecIsTriggerDisabled') -- should return 0.

Your description above seems to imply that the trigger actually fired in the QA environment. If so, then it could be that there was an error causing the 'exec createAudit' to be skipped. You can check for this by looking for error events in the trace output.

Hope that helps you track it down.