xp_smtp_sendmail

SQL Server Tools General

Index ‹ SQL Server

- Previous
  - 1
    - Joining mdx results Hi You can do this in just one MDX expression. ie. Code Block WITH SET [Feb1-March1] AS 'Aggregate( <Insert February member> : <Insert March member> )' SET [June1-July31] AS 'Aggregate( <Insert June member> : <Insert August member> )' SELECT { [Feb1-March1], [June1-July31] } ON COLUMNS, { [Measures].[Cost], [Measures].[Quantity], [Measures].[Profit] } ON ROWS FROM <Your Cube Here> Edit: This post contains invalid MDX as a mistake HTH - Jens Tag: xp_smtp_sendmail
  - 2
    - import data from excel data sheets tap, tap is anybody here some kind of reply would be nice. Tag: xp_smtp_sendmail
  - 3
    - How to display column from Inserted table I never tried that on my own, but did you try using a ExecuteReader or a resultsbased command to retrieve the resultsset from the command Jens K. Suessmeyer --- http://www.sqlserver2005.de --- Tag: xp_smtp_sendmail
  - 4
    - Last working day from last year! In SQL, or an expression inside SSIS Tag: xp_smtp_sendmail
  - 5
    - Check data changes in table If you (or the application) know what the previous values were in order to compare them against the current values in the table, you can do it without using TRIGGERs. Since SSMS has retreived the data and placed it on the screen, SSMS compares the new value against the old value and alerts you to a data change. However, there is NOT a simple way to 'just check data changes' since some date/time without using a TRIGGER. In order to just query the table and retreive all data changes since a particular date, you WOULD indeed need a TRIGGER AND a column (perhaps named: [ChangeDate]) to contain the Date/Time of the last update. Then whenever there is a change to the data, the TRIGGER would update the [ChangeDate] column with the current DateTime. At that point, a query would retreive all rows where the [ChangeDate] column is newer than a specified DateTime. Tag: xp_smtp_sendmail
  - 6
    - Get certain raw row from table There is no such concept in SS, a table is an unordered set of rows and columns. If there is a group of columns that we can use to uniquely identify each row, then you can use new ranking functions. ;with cte as ( select *, row_number() over(order by pk_col) as rn from dbo.t1 ) select * from cte where rn = 3; AMB Tag: xp_smtp_sendmail
  - 7
    - SQL Server 2005 Service Pack 2 -- Now Available What is new in SP2 http://download.microsoft.com/download/2/b/5/2b5e5d37-9b17-423d-bc8f-b11ecd4195b4/WhatsNewSQL2005SP2.htm#BKMK_DatabaseEngine list of Bugs fixed http://support.microsoft.com/ kbid=921896 Tag: xp_smtp_sendmail
  - 8
    - SQL task works running the package but not when called via C# You might want to post your C# code here so that we can see where you are going wrong. If you have the SSIS package working fine on its own, calling it via a C# program should not be a problem at all. I actually just completed a project to do the same. Here is some code snippets to just execute the dtsx package..not exactly sure if thats what you are asking for but here goes, you need to add the Microsoft.SqlServer.Dts.Runtime assemblies and the System.Data.SqlClient assemblies to the package. Your code to just call the app and execute would look like so: Code Snippet Microsoft.SqlServer.Dts.Runtime. Application app = new Microsoft.SqlServer.Dts.Runtime. Application (); Package examplePackage = app.LoadPackage( @"c:\package location\package.dtsx" , null ); DTSExecResult result = examplePackage.Execute(); result would contain the success or failure result of the package, you can do a ToString to display it. Tag: xp_smtp_sendmail
  - 9
    - MDX throws error after server upgrade Hi all, I deployed the "Adventure Works DW Standard Edition" cubes on my machine and I wrote the following simple MDX : MDX 1 select { [Measures].[Reseller Tax Amount] } on columns , { ([Geography].[Country].&[Australia]:[Geography].[Country].&[Germany], [Product].[Category].&[1]) } on rows from [Adventure Works] The above MDX runs fine on my machine and gives me the output. The following version of SQL Server 2005 is installed on my machine : Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Standard Edition I tried running the same MDX on a server with the following configuration : Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Enterprise Edition . When I run this MDX I get the following error: "The Tuple function expects a tuple expression for the argument. A tuple set expression was used." I modified this MDX like this : MDX 2 select { [Measures].[Reseller Tax Amount] } on columns , { ([Geography].[Country].&[Australia]:[Geography].[Country].&[Germany] * [Product].[Category].&[1]) } on rows from [Adventure Works] The modified MDX runs fine on the server and gives the output. To summarize, MDX 1 and MDX 2 both run fine on my local machine and give me the same output whereas on the server with a higher build of SQL Server 2005, MDX 2 runs fine while MDX 1 fails with the error - "The Tuple function expects a tuple expression for the argument. A tuple set expression was used." I am unable to understand as to why this is happening Is this a compatibility issue which has been documented or is this a bug I request the community members to help me out. Thanks in advance, CodeKraker. Tag: xp_smtp_sendmail
  - 10
    - System.Data.SqlServerCe That depends if you want to connect to a SQL Server mobile / Compact Database (then you will need the SQLServerCe namespace) or to a *big* SQL Server (then you will need the SqlClient namespace) Jens K. Suessmeyer --- http://www.sqlserver2005.de --- Tag: xp_smtp_sendmail
  - 11
    - Cant get Access Database Synchronizer set up on client machine I have had the same problems when I first installed. THen for some reason things started working. Now a few weeks later, when I get back to trying it, no work anymore. I suggest you read the readme.doc that comes with it. THere are some things to check there. Make sure IIS is running. THen you add a 1024 port if you have the firewall enabled. I also had some success when I manually copied the .cab file to the device, then installed that way. I don't think I have ever got it to work just downloading the sample project. Another thing to verify is that your internet connection is going from device to desktop. Open IE and try to open http://<computer>:1024/ . Presently, I am unable to do this so I think something is wrong on my Desktop platform. I am going to try another platform that used to work. Tag: xp_smtp_sendmail
  - 12
    - SQL Server slower after 2005 upgrade Did you read SQL Server 2005 Upgrade Technical Reference Guide . Tag: xp_smtp_sendmail
  - 13
    - Filtering on a part of a field - 3 As for question #1... Whether or not the case of the string is restricting the results is determined by the collation on your ItemDescription field. In Management Studio, run 'sp_help' on the table with the ItemDescription column in it. Look at the collation on the ItemDescription column, it will need to be something that is case-insensitive. Can you post the collation on your field In my database, I have a field on one of my tables with a case-sensitive collation (SQL_Latin1_General_CP1_ CS _AS). The CS distinguishes that it is case-sensitive. So, in order for me to do a case-insensitive search, I have to explicitly change the collation on the column. For your query, it would look something like this: where ItemDescription COLLATE SQL_Latin1_General_CP1_ CI _AS like '%' + @ItemDescParam + '%' For question #2... What would the user type in the search box, "pine yellow" Also, what if the user typed in "yellow pine", should it also return the Pineapple yellow record I think you could do this if the user was required to type the search values in the order they show on the record , by doing this: where ItemDescription COLLATE SQL_Latin1_General_CP1_CI_AS like '%' + replace(@ItemDescParam, ' ', '%') + '%' In this situation, if the user typed in "pine yellow", it would return the Pineapple yellow record. However, if the user typed in "yellow pine", it wouldn't find any results. Hope this helps. Jarret Tag: xp_smtp_sendmail
  - 14
    - Multi-user access through a data-access layer/remoting server Hi CP, 256 simultaneous connections means that 256 applications on the same client can access the DB, not 256 users. SSCE is a single-user database. However, check out this blog post http://community.softteq.com/blogs/nick/archive/2006/11/28/sql-server-ce-as-asp-net-database.aspx . It implies that you can actually do what you suggest. I have never tried it, but have been advised that it works. Now, would you do this I don't see why considering that SQL Server Express would be a better option and it's still free. You have to remember that: SSCE supports Subset of T-SQL Subset of in-built SQL Server functions Subset of SQL Server datatypes Not Supported: decimal, smallmoney, smalldatetime, char, varchar, text, timestamp, sql_variant, xml SSCE does not support Stored Procedures‘ User-defined Functions (UDF’s) Any CLR UDT Datatypes XML schema collections Queries with multiple statements If you are going to the trouble of implementing what you suggest, then why not use SQL Server Express and have full upgradeability to SQL Server Cheers Jeff Tag: xp_smtp_sendmail
  - 15
    - How To Connect From SQL Server Database To Another SQL Server Database You might want to do a search on this forum, and look at BOL, for topics relating to LINKED SERVERS. Tag: xp_smtp_sendmail
  - 16
    - How to create Vertical Partioning You can take a look at How to: Define and Modify a Column Filter (Replication Transact-SQL Programming) http://msdn2.microsoft.com/en-us/library/ms146925.aspx Gary Tag: xp_smtp_sendmail
- Next
  - 1
    - Error Message Text in Multi Languages I may be slightly simplifying things here, but can you not just avoid raising errors of this nature in the first place e.g. use: SELECT PhoneNumber FROM @PhoneNumber WHERE PhoneNumber NOT LIKE '%[A-Z]%' ...when you declare the cursor (this might even remove the need for you to use a cursor). Chris Tag: xp_smtp_sendmail
  - 2
    - Copy Folders and Files to different location One way would be a For Each Loop container with Traverse subfolders enabled, with a File System task inside it to move the files once they've been processed. Tag: xp_smtp_sendmail
  - 3
    - Permissions to view Stored Procedure Property To grant permissions on a stored procedure In Object Explorer, connect to an instance of SQL Server 2005 Database Engine and then expand that instance. Expand Databases , expand the database in which the stored procedure belongs, and then expand Programmability . Expand Stored Procedures , right-click the procedure to grant permissions on, and then click Properties . From Stored Procedure Properties , select the Permissions page. To grant permissions to a user, database role, or application role, click Add . In Select Users or Roles , click Object Types to add or clear the users and roles you want. In the Explicit Permissions grid, select the permissions to grant to the specified user or role. For a description of the permissions, see Permissions . Selecting Grant indicates the grantee will be given the specified permission. Selecting Grant With indicates that the grantee will also be able to grant the specified permission to other principals. Tag: xp_smtp_sendmail
  - 4
    - data file blanks to nulls You can use a Derived Column as well (NULL(DT_*)). If you aren't dealing with many columns, the Derived Column approach is fine. However, if you have a lot of columns to check, the script approach can be easier, as you can set it up to process all the columns generically, checking for and replacing blanks. Tag: xp_smtp_sendmail
  - 5
    - Send an email on non-fatal errors from Data Flow Hi Sandy, you should try to use Event Handlers. Event Handlers will allow you to build additional control flows that get activated by events (OnError, OnWarning, etc) posted from executables (a data flow in your case) you are monitoring. HTH. Tag: xp_smtp_sendmail
  - 6
    - Service Broker "TO service could not be found" Message origin: "Transport" Just a guess, but probably your service is named 'tcp://mydomain.com/TARGET/MyService', not '[tcp://mydomain.com/TARGET/MyService]' Tag: xp_smtp_sendmail
  - 7
    - Distinct Count with Junk Dimension Attribute Are you excluding the ALL member Take a look at the code sample below It calculates a count 3 ways. In the first, I count the members of the dimension's attribute hierarchy. It includes the members from all levels including the ALL member because I didn't specify a level. In the next one, I specify the leaf level of the hierarchy which does not include the ALL member. The third example uses DISTINCTCOUNT. Code Snippet with member measures.a as COUNT ([Geography].[Country]. Members ) member measures.b as COUNT ([Geography].[Country].[Country]. Members ) member measures.c as DISTINCTCOUNT ([Geography].[Country].Country. Members ) select {[a],[b],[c]} on 0 from [Adventure Works] ; Good luck, Bryan Tag: xp_smtp_sendmail
  - 8
    - Trying to set output variable to row count result of SQL Execute Task Try naming your output (Select count(*) as recordCount...) BobP Tag: xp_smtp_sendmail
  - 9
    - How can I set SO_TIMEOUT on the sockets used by the JDBC 2005 driver? Hi Steve, From the problem description above it sounds like you are looking for a way to set the timeout on a query execution. This can be done using the "setQueryTimeout" API on the SQLServerStatement object. For additional information please refer to the following MSDN topic: http://msdn2.microsoft.com/en-us/library/ms378081.aspx If you are requiring a connection timeout setting, you can specify "loginTimeout" on the connection URL or on the SQLServerDataSource object. For additional information on the connection URL properties please refer to http://msdn2.microsoft.com/en-us/library/ms378988.aspx . If you are using the SQLServerDataSource object, please refer to http://msdn2.microsoft.com/en-us/library/ms379035.aspx for additional info. The Microsoft SQL Server 2005 JDBC driver has built-in tracing using the java.util.logging API. For additional information about the different levels and categories, please refer to the following topic: http://msdn2.microsoft.com/en-us/library/ms378517.aspx HTH, Jimmy Tag: xp_smtp_sendmail
  - 10
    - xquery - order by problem Try Code Snippet select @x . query ( 'for $x in /LogicalFolder/Items/FileNode order by $x/FullPath[1] return $x ' ) Tag: xp_smtp_sendmail
  - 11
    - Very hard question on how to query data and return by months - Which version of SQL Server are you using - Can you post the query Search for PIVOT in this group. AMB Tag: xp_smtp_sendmail
  - 12
    - Database attach at setup You can always use CREATE DATABASE mydb ON ( FILENAME = 'mydb.mdf') to attach a database after installing sql server. refer to http://msdn2.microsoft.com/en-us/library/aa258257(SQL.80).aspx for more details. or you can do attach database via management studio Look into this link: http://msdn2.microsoft.com/en-us/library/ms190209.aspx Tag: xp_smtp_sendmail
  - 13
    - File System Watcher can not read excel from SharePoint Plase Tag: xp_smtp_sendmail
  - 14
    - how to set date field in sql server 2005 table Sekar: Look up DATE AND TIME and related articles in books online to begin to get an understanding of the DATETIME datatype. Understand that there is no such datatype in SQL Server for DATE -- the datatype is DATETIME. As such, you cannot store date only in this datatype. The next thing that you need to give a look to is SET DATEFORMAT in books online. This will show you how to set your format to the DMY format you indicated. Code Block SET DATEFORMAT DMY Normal practice is to store a time of 12AM or 00:00:00 when the intention is to store date only in a datetime column. This is in fact what the database does by default. If you store a datetime of 18/2/7 in the database it will store this date and assume a time of 12AM. The way that this gets handled is by properly formatting the datetime columns into varchar strings when displaying the datetime. This is accomplished by using the CONVERT function. To select only the date portion from a column named "yourDate" in a table named "yourTable" the select might look something like: Code Block select convert(varchar(10), yourDate, 103) from yourTable Take note of the "103" in the convert function. That is the format specification to format datetime columns into a date format of DD/MM/YY. Give a look at the following articles in books online: DATE AND TIME SET DATEFORMAT CONVERT Tag: xp_smtp_sendmail
  - 15
    - SQLSTATE 42000- Error 15404 with ADS Which service account is the SQL Server running with Jens K. Suessmeyer --- http://www.sqlserver2005.de --- Tag: xp_smtp_sendmail
  - 16
    - HOW TO: Print a report directly to a printer After posting this yesterday. I found some problems with the code. This works great if your report is 8.5x11, but it still lacks features for printing landscape. I am working on a better solution. This all started from the need to send a reportname, a parameter, a printer name and number of copies to a program that would render and print a SSRS report. (Trying to replace a cludgy Crystal solution). Part of this goal is to avoid any UI and run this as a service on a report server, not to be confused with a sql reports server. So if anyone has better ideas , please let me know. Daryl Tag: xp_smtp_sendmail

Subeesh

My DTS program requires an email functionality. But I cant use xp_SendMail , its already configured to use for some other purposes.

Then I came to knew about master.dbo.xp_smtp_sendmail, but my problem is its not executing (giving a procedure not found message).

What may be the possible causes

How can we able to rectify it

Thanks in advance

Top

Re: xp_smtp_sendmail

Arnie Rowland

Have you carefully followed the installation instructions

Top

Re: xp_smtp_sendmail

Jens K. Suessmeyer

Please do not multipost:

Answered in http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1412270&SiteID=1

Top

Re: xp_smtp_sendmail

Satya SKJ

Locked the thread and follow Jens' reference.

Top