How Is Cross Platform Recognition Triggered In The Process
Nov 16, 2007How is cross platform recognition triggered in the process?
View 2 Replies
ADVERTISEMENT
Alerts Not Being Triggered
Dec 14, 1998I've setup alerts and an operator to email on a particular event code.
I can successfully test the operator. (It e-mails fine)
The problem I am having is that despite having a particular event
log to the NT application log, no SQL Alert is triggered.
I've tried logging to the NT Application log, as well as the SQL errorlog.
The SQLExecutive is running.
Thanks in advance.
John
Alert Not Being Triggered
Aug 11, 2006Hi guys,
Hope you are all well.
I am trying to set up a 'SQL Server event alert' that will 'net send' a warning message to one of the Operators that have been set-up on our SQL Server.
The alert has been configured to act on severity level '009 - User Defined', for all databases.
I have created a user defined system message with a severity level '9' on the sysmessages table.
EXEC sp_addmessage 80000, 9, 'My User Defined Message'
...and I have raised this error on our SQL Server.
RAISERROR(80000, 9, 1) WITH LOG
The error message is being generated in the SQL Server Log file, but for some reason my Alert does not appear to fire off the 'net send' event.
The operator is 'available to receive notifications', and I have tested the 'net send' command successfully.
Does anyone know why this Alert might not be sending a message with the 'net send' command?
Thanks in advance,
Kevin
How Do I Know What Action Triggered A Trigger...
Aug 2, 2004Hello
If I have a trigger for INSERT and DELETE, how do I know what action was executed ??
I prefer not to split the trigger to one for each action, because the the procedure for both is almost the same.
Another question, How can I know what records were updated? I need to concatenate the ID/ID's to the SQL in the procedure.
Thanks,
Inon.
Manually Triggered Replication?
Aug 8, 2007I've been studying/experimenting with the replication features and though the Updating Susbcribers Replication Model was the answer to my data environment.
What we want: We have a live server (Publisher) that'll serve content to our users, but we want an "offline/data entry" server (Subscriber) that'll pretty much have the exact same data as the live server for data entry and validation purposes. Changes and inserts would be done on the Subscriber locally, vetted through, and once done, it'd be updated to the Publisher.
I've managed to get some semblance of the above working, but the updates are nearly instantaneous. Which means that changes/inserts that may be erroneous on the subscriber machine would almost always be seen on the publisher machine before our operations can do anything about it.
Is there a way to configure the replication process to hold off until the admin triggers it? Or am I using the wrong feature?
Notify Whether A Trigger Is Triggered...?
Aug 27, 2007Hi,
I am developing desktop application with SQL Server 2005 in C#. I need your help. My Question is "How to notify a Database trigger is executed thru C# application?".
Now I am going to explain clearly. I have a table "Employee" and I created one trigger (it may be INSERT/UPDATE/DELETE) for that table. Then I created a C# application to show a msg box when that table is modified. Now my question is If that table is modified a message box will be shown. I know about trigger (If trigger assigned table is modified that trigger will automatically executed.) But how do i know that trigger is executed thru a C# application. Please send your suggestion or links.
Thanx,
GANESAN MURUGESAN.
OnPipelineRowSent - Can It Be Triggered For Every N Rows?
Oct 24, 2007How do I make an event to fire for every 100 rows? I have set default buffermaxrows as 100, so I expect SSIS to write to the destination after every 100 rows and during that time I believe OnPipelineRowsSent would be fired.
But in my case, it write around 350+ rows and OnPipelineRowSent is fired only 3 times (350+350+350). Is there anything else I can do to fire this event for every 100 rows or its not possible?
Thanks
Stored Procedures Triggered By State
Feb 16, 2005I am interested in creating a stored procedure that will trigger a script if an insertion to a particular table is done. I have never done this before, so I was wondering if someone could share any advice.
Thanks.
Fetch Query That Triggered The TRIGGER
Dec 26, 2006HelloThe problem is need to find out the querry that has updated or insertedinto the table and in turn 'Triggered the Trigger'. I have the username, the machine name, Application name, but not the query. The updateis not desired and the application is doing it but the applicationbeing so large we are unable to pin-point the code which is doing thedammage.Pls help!RegardsAnubhav
View 1 Replies View RelatedSQL Alert Triggered By Text File Creation
Oct 22, 2001I would like to know how to config SQL Server 2000 Alert to be triggered by new file creation (i.e. txt file).
Maybe by monitoring windows 2000 log file (not sure)??
Any help or suggestion will be highly appreciated.
Breakpoint In Child-package Triggered On First Execution Only.
Sep 23, 2007I have a child package which is executed several times within the same SSIS ETL. I have placed a break point on one of the child package's tasks, set to trigger on a PreExecute() event. The first time the child package is invoked, the breakpoint is triggered. However, on each successive invocation the breakpoint is ignored. Does anybody know if this behaviour is normal? Thanks in advance!
View 1 Replies View RelatedIs There An Eventhandler That Can Be Triggered When Package Execution Is Terminated?
Apr 16, 2008i have a package which logs to a table the status of its execution. i wonder if there is a way to trigger an event when package execution is terminated.
SQL Server Agent - Can A Job Be Triggered To Start By Another Job Ending?
Jul 3, 2007Hi,
I have a job in SQL Server agent with 199 SSIS steps and growing. In the job log only 99 steps are shown, which is a problem if a step higher than 99 fails to run. I need the steps to run in sequence and preferable would like to split the job into several jobs each containing no more than 99 steps. The only thing I don't know is if it is possible to have the next job in sequence start only when the previous job has finished.
Does anyone know if this is possible, and if so how it is done?
Many thanks,
Paul
Integration Services :: Send Mail Task - Not Being Triggered
Oct 5, 2015I have a Send Mail task as part of a validation process in a OnPostExecute event handler. All tasks preceding the Send Mail task get triggered and show green check mark next to them, but, for some reason, Send Mail task never gets one.
I checked the Execution Results tab and it doesn't show any indication of Send Mail task executing as a final step.
I checked the SMTP server configuration and did some test using localhost. I'm able to send as configured while using anonymous credentials.
Sending A Report Via Email Triggered From A Trigger On A Sql Table
Oct 24, 2006
My question is it possible to send a report developed in reporting services via email as either a attachment or imbedded in the email, from an insert trigger placed on a table in sql.
If so could you please help with the string that would be need to achieve this.
The report will need to have one or two parameters passed to it from the table.
The report is built and working through reporting services already. I was impressed with the subscription services that reporting services has in place and would like to utilise the reports further by auto emailing out when a new record is placed in the table. To be sent out either as an attachment or imbedded in the email it self.
Thanks for any assistance in advance
David
Which Platform To Use
Aug 25, 2007Hi,
I'm developing an application that will access a database, and then send the data to a server either in batch or as each item is updated over GPRS. The database will have a large table, with 20,000 records. Each record is about 150 characters. The data access needs to be as fast as possible. I'm not sure which platform/hardware to use to achieve maximum speed. I have experience with c#, sql server ce. Worked mostly on Windows Mobile 2003, but thinking of moving to WM 5 or 6. My question is what is the best combination of hardware, OS, development environment, and software to use?
thanks
awni
SQL Server 2008 :: Send Mail Task On Failure Not Triggered
Mar 26, 2015I have multiple task flows with precedence constraints and i have changed the constraint as completion to execute the package even though there is failure in one of the tasks in the package but every time the send mail success is executed instead of Send mail Failure task.
View 0 Replies View RelatedSQL Platform Upgrade
Mar 12, 2004I need some feedback to bolster my position with a client who is planning a platform migration. They are currently running SQL 7.0 SP3 on Windows NT4 and want to upgrade to Windows 2003. First off, SQL 7.0 isn't going to run on Windows 2003, so their first response is "let's buy the licenses and run Win2000 and SQL7 until we're ready to migrate to SQL2000". Ok... licensing cost controls aside, they're investing significant $$ in acquiring the hardware. What's my most compelling argument for moving them to a Win2003/SQL2000 platform now. (Other than the wait for Yukon is likely to be significant ;-) )
Any feedback would be appreciated.
Win2000 Platform??
Jul 20, 2005Hi,I'm planning to purchase Sql Server2000 St. Edt. and install it onwindows 2000 server machine. I would like to know please if it isadvisable to work on the same machine that host both servers or shouldI work on a separate one???MTIA,Grawsha
View 1 Replies View RelatedSQL CE 3.5 And Platform Builder 5
Apr 3, 2008I'd like to integrate SQL CE 3.5 into a platform builder image(using PB 5 targeting CE 5), but I don't see it in the catalog. Is it currently possible to Sysgen an image with 3.5? Can I somehow deploy the files from the .cab files? Sorry if this has been answered before, I searched around a bit but didn't find anything.
View 6 Replies View RelatedChange In Windows Platform From XP To NT
May 3, 2007hello... my SQL database is being not able to be accessed by application when i run through VS2005 . I created the database in XP sys now brought to a NT systeem..what shd i do ..??? pls help
View 1 Replies View RelatedSql Server 7.0 On Windows 98 Platform
Mar 11, 2000I am using windows 98 and I want te use SQL server 7.0. I have installed the non-enterprise edition....But it won't work....
The service manager in istalled succesfully and all the other utilities to.
But it still wont work. Is somebody out there who can help me on this.
Tnx
SQL Server Property's Platform
Apr 12, 2007I've got XEON x64 server and after SQL Server 2005 installation found that the platform in property says AMD64 and not INTEL64 as expected.
I was assured by our service provider that AMD64 platform is the correct one as it was compiled for INTEL x64.
Does anybody have an answer to it?
SP1 Failure - Incorrect Platform
May 8, 2006When I try to run the x86 version of SP1 on my development desktop (for tools only), I get an 'Incorrect Platform' error:
Setup cannot update x86 products on this computer
To proceed, run the Service Pack Setup program for the x86 platform.
The filename I downloaded is SQLServer2005SP1-KB913090-x86-ENU.exe
and it successfully installed on my Wk2003 server (dual PIII). My desktop is a single P4 2.8Ghz running WinXP Pro.
brian smith
Windows CE Platform To SQL Server
Jun 14, 2007I am writing applications for barcode readers that send and receive information via wi-fi to a 2003 Server running the full MS SQL Server 2005. The readers are both XP and CE .NET 5.00 based.
The information is time critical so I need to scan a barcode then send that information to the SQL Server and then in turn run a query based upon it which then displays on the reader. I have no problem with the XP devices as I can link via ODBC to the SQL Server. These work perfectly.
I can also run a program on a XP desktop using Remote Desktop on the CE device which again works fine.
The CE .NET 5.00 readers are a problem as I cannot use OBDC or OLE DB owing to the platform.
Is there any method available where I can query the SQL Server directly without using some kind of third party product like ViaDB from Odyssey Software? I cannot use replication owing to the time constaints.
Any suggestions or gentle prods would be appreciated.
Norman
Migrate Alpha Sql 6.5 To Intel Platform
Jan 7, 2002Hello:
Our company needs to (restore/migrate) our Alpha Nt4sp4 sql 6.5sp5a databases to an Intel hardware platform. For the time being the new intel server will be runing Nt4sp4 sql 6.5 sp5a. I understand that if we were to upgrade to sql 7 we would be able to restore the databases without any problems. However upgrading to sql 7 is not an option right now. I have tried to restore a backup from the alpha to an intel based machine, and it fails because the processor types are different.
I have already search technet, but found nothing, except upgrade to sql 7.
I am hoping someone out there could point me in the right direction.
Thank inadvance for your help, I appreciate it very much.
Cindy
MS SQL Client Software For UNIX Platform
Jul 5, 2001How can i connect to the MS SQL server ruuning on Windows NT from a SOLARIS machine.?
Is there any client software available for this?
SQL Transfer From Alpha To Intel Platform
Oct 19, 2000please please help?
For the last couple of days i've been trying to transfer a SQL6.5 database from an Alpha platform to an Intel one.
At one point i loaded SQL7 on the Intel platform and tried to perform an upgrade (using the wizard), across the network - but it just did not want to play.
Using Veritas Backup Exec, with SQL6.5 on both machines, i've tried doing a backup of the database on the Alpha platform and then restore to the Intel Platform, but this fails stating that the processors are incompatible
Am i trying something that is impossible?
If anyone could point me in the right direction i'd be truely grateful.
Sharpy
Extended Stored Procedure API Not In New Platform SDK
May 3, 2004Does anyone know why the Extended Stored Procedure API (formerly Open Data Services) headers and libraries (e.g. srv.h, srvdbtyp.h, opends60.lib) are not in the new Platform SDK?
Older versions of the Platform SDK had these tools included, but I installed the new Platform SDK and they're not included. Is there another SDK that I need to download and install now?
How To Move Transactional Distributor To New Platform?
Jan 31, 2007I have to move our dedicated Sql 2000 transactional distributor to a new and faster machine. Great! Can someone give me or point me to a cookbook of the best way to do this? This has to be done quickly so I would like to script it and have it ready ahead of time. I am not a replication guru so I am a bit nervous . . . I have looked at the scripts output by EM, but I am sure there are some assumptions . .
Thanks
Executing Package From C# On 64bit Platform
Aug 1, 2007Hi
I have been successfully executing a series of IS packages from C# using the following syntax
Microsoft.SqlServer.Dts.Runtime.Package package;
package = app.LoadPackage(ISPackagePath + @"myPackage.dtsx", null);
package.ImportConfigurationFile(ISPackagePath + @"MyConfiguration.dtsConfig");
result = package.Execute();
package.Dispose();
My client has just moved their SQL boxes to a 64bit platform and this process no longer runs.
Now im also running some packages in a SQL Agent job on the SQL box and im aware of the issue of an SSIS job step defaulting to using the 64bit version of DTExec.exe. Ive updated those job steps to be operating system (cmdExec) type steps calling the 32bit version of DTExec.exe, and everything is fine there.
Is there anyway to force the Microsoft.SqlServer.Dts.Runtime.Package object in my C# code to use the 32bit version of DTEexec.exe? This code is running on the same 64bit SQL server box as the SQL agent job. Or will Microsoft.SqlServer.Dts.Runtime.Package object always default to using the 64 bit version if it is executed on a 64bit box ?
I would just call sp_start_job from C# and implement the IS packages in another job but unfortunatly my code cannot be given correct permissions to see the SQL agent jobs.
Any ideas?
Thanks
Connect Using Perl (solaris Platform)
Apr 23, 2007
I need to connect to Express edition of sql server installed on my machine, from perl (solaris platform). How should the connection string containing server, port, database etc look like ??
Calling Applications In Unix Platform
Sep 14, 2007
Dear all,
How do i call an application, which is reside in another unix platform in my flow of execution.
I'll need to call this application after my data extraction is successfully run.
Thanks for the helps in advance.
Thanks & Best Regards,
PassionOrienter