Hi!
I want to execute dynamic generated dmx-ddl
from tsql. How to do that?
Openquery doesn't work, because "create mining structure..."
does not return result set.
Thanks for help
I have a job that emails out shipment notifications at the end of the day to our customers. The problem I have is I don't understand why the same email is sending out twice within a minute of each other when the job is only scheduled to run once. If I take the code out of the step and run it in management studio it only emails once. I attached the code for one customer for reference. We are running SQL 2008 on a VM sending to an exchange 2010 server.
DECLARE @tableHTML NVARCHAR(MAX) ;
SET @tableHTML =N'<H1>XYZ Company ASN For ' + CONVERT(VARCHAR(10), GETDATE(), 101) + ' </H1>' +
N'<table border="1">' +
N'<tr><th>Vendor</th><th>Delivery Date</th>' +
N'<th>Purchase Order Number</th><th>Item Number</th><th>Item Description</th>' +
N'<th>Quantity Shipped</th><th>UOM</th><th>BOL Number</th>'
[code]....
I have, a SSAS 2012 tabular instance with SP2, there is a database on the instance with a read role with everyone assigned permissions. When configuring the Power BI analysis services connector, at the point where you enter Friendly Name, Description and Friendly error message, when you click next I receive the error "The remote server returned an error (403)." I've tested connecting to the database from Excel on a desktop and connect fine.I don't use a "onmicrosoft" account so don't have that problem to deal with.
We use Power BI Pro with our Office 365. As far as I can tell that part is working ok as I pass that stage of the configuration with a message saying connected to Power BI.The connector is installed on the same server as tabular services, its a Win2012 Standard server. The tabular instance is running a domain account that is the admin account for the instance (this is a dev environment) that account is what I've used in the connector configuration. It's also a local admin account. There is no gateway installed on the server.
I'm trying to configure SQL server 2000 (standard edition) to send e-mail on a Small Business Server 2003. There's a great article on how to do this on a SBS 2000 server (KB304967), but it does not apply to SBS 2003. Can anyone point me to a article or white paper on how to configure SQL on a SBS 2003 server to send e-mail. Thanks.
David Neahusan
i want to check.. Report Server Windows service has Send As permissions on the SMTP server.
how can i do this..
Is it possible to have Analysis Services in both modes or are they mutually exclusive?I have a machine setup with Multidimensional AS and would like to know if it's possible to add a Service in Tabular mode.
View 2 Replies View RelatedHi.
I have installed an SQL 2005 Failover Cluster on a Two Node Active Passive Windows 2003 Cluster.If i am trying to failover from the Active node to the passive Node,The Sql Server,Sql Server Agent and SQL Analysis resources fail,However if i reset the passowrd in the services tab of the above three services on the pasive node,the resources come online.
Below is the brief of my setup
1.I have two Active directory domain controllers running Windows 2003 R2 Standard edition with SP2.
2.i have installed a Windows 2003 Two Node Active Passive Cluster as NODE1 and NODE2.
3.The Domain account used to install WIndows 2003 A/P Cluster is Clusteradmin.This account is the member of Administartors on the Domain as well as the Local Admin on NODE1 and NODE2.
4.SQL 2005 with SP2 is installed on both the Nodes as SQL 2005 Failover Cluster.The account used to install SQL 2005 is sqadmin.This account is the member of Administartors on the domain and the member of Local Admins on NODE1 and NODE2.
5.SLQ 2005 has four domain groups for 4 SQL Services.The Services are SQL Server,SQL Server Agent,SLQ Anaylisis Server and Full text Search.
6.Each of these servcie has a seperate service account created for them.All these service accounts areb the members of domain admin and the member of Local Admin on NODE1 and NODE2.
7.Each of these servcies is running under these servcie accounts in the Servcies tab in NODE1 and NODE2.
8.If i fail the resources from NODE1 to NODE2 ,The SQL Server,SQL Server Agent and SQL Anaylisis resources are failing.on going to the service tab of NODE 2 I reset the password for these services,the services come online.
10.The Cluster resources and MSDTC Resources are Failing over successfully.They are coming online successfully.
11,I have a problem with the SQL Server Resources,even if i failback to NODE1 from NODE2,the same resources are failing again.
Plz Advice.
Regards
Khalid
Hi, all here,
I am just wondering about the Discretization function available on analysis service server (which can not actually discretize data into user-defined expressions) . Isnt it redundant ? I mean since users can discretize their data more meaningfully based on their own expressions in database engine of SQL Server 2005.
Thanks a lot.
we are using ASMCD to sync our cubes from a Cubebuild Server to a Reporting Server. We migrated some days ago from 2012 to 2014. We are also using rel. Engine with StoredProcs for calling and executing xp_cmdshell for the Ascmd.Actually all works fine for our smaller cubes. For the bigger one we got the following issue. The cube is being synced but the proc delivers error.In the log we found this entry:
(7/7/2015 11:26:22 AM) Message: The directory '?D:SSAS_DATAGPMR Local CNTR.510.dbLocal Controlling Cube.0.cub' could not be deleted. Please check the directory for permissions.
(Source: ?D:SSAS_LOGmsmdsrv.log, Type: 3, Category: 289, Event ID: 0xC1210020)
(7/7/2015 11:26:34 AM) Message: The directory '?D:SSAS_DATAGPMR Local CNTR.510.db' could not be deleted. Please check the directory for permissions.
[code]...
Hi, all here,
Would please anyone here give me any idea about how can I connect to SQL Server 2005 analysis services server and send XML request to it programmatically (with Business intelligence development studio in SQL Server 2005)? Thanks a lot.
With best regards,
Yours sincerely,
I want to populate data in SQL server database (SQL server 2008 R2) from SSAS cube located on different server (SQL server 2012). My SQL database present on Server A and cube on Server B.
To implement I am trying to create linked server. But its giving errors related to provider and product.
Error 4 The project could not be deployed to the 'local' server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0 .This causing the deployment error msg when trying to create cube in SSAS and not letting to create the multidimensional table--
View 8 Replies View RelatedHi,
I have a fact table with 2 columns value A and value B
In Analysis server I add a calculated column C as A / B
Now my data looks like this
A B C
0 10 0
5 10 0.5
If you add totals in Analysis server you get
5 20 and 0.25 which is correct
If you add totals in Reporting server you get
5 20 and 0.5 which is not correct.
How can I fix this ?
Thanks in advance
Constantijn
How can I send an email from sql server.
I tried the following code which gives me no errors but doesn't send the email.
Code:
CREATE Procedure sp_SMTPMail@SenderName varchar(100),@SenderAddress varchar(100),@RecipientName varchar(100),@RecipientAddress varchar(100),@Subject varchar(200),@Body varchar(8000)ASSET nocount ondeclare @oMail int --Object referencedeclare @resultcode intEXEC @resultcode = sp_OACreate 'CDONTS.NewMail', @oMail OUTif @resultcode = 0BEGINEXEC @resultcode = sp_OASetProperty @oMail, 'From', @SenderAddressEXEC @resultcode = sp_OASetProperty @oMail, 'To', @RecipientAddressEXEC @resultcode = sp_OASetProperty @oMail, 'Subject', @SubjectEXEC @resultcode = sp_OASetProperty @oMail, 'Body', @BodyEXEC @resultcode = sp_OAMethod @oMail, 'Send', NULLEXEC sp_OADestroy @oMailENDSET nocount off GO
GO
Can anyone recommend a solution to send email from sql server?
Hi,
I have a requirement of sending mail through SQL Server through SMTP port... But, I dont want to configure my database server as e-mail client...
Is there any way to do it...
Thanks in advance...
I found following script but getting invalid command error.
/****** Object: StoredProcedure [dbo].[FtpPutFile] Script Date: 03/25/2014 10:07:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:<Author,,Name>
-- Create date: <Create Date,,>
[code]....
hi allmy query is how can i send mail by using sql server, i think by unsingxp_sendmail store procedure we can do this but my problem is whatparamater to be pass to this store procedure if i want to send mailfrom my local machine to another user, bcos i am geeting this errormsg in query analyzer...query:-EXEC master..xp_sendmail 'ss35934' (ss35934 is valid user namepresent into my local nerwork)getting error msg :- xp_sendmail: failed with mail error 0x80040111from:- sachin shah
View 3 Replies View RelatedI have a SQL Server 2000 application that send's e-mail to users usingthe xp_smtp_sendmail procedure. That works fine. What I would liketo do is RECIEVE e-mail with SQL Server.Example: I text message an alert to a user. They reply with somekeyword in the subject of their reply e-mail, such as 'ACKNOWLEDGED'or 'ACK' for short. SQL Server recieves this and then acts upon itwith a stored procedure, etc.Anyone know if this is possible and with what tool?TIA,Lindsey
View 3 Replies View RelatedHow can send mail using proxy server?
View 1 Replies View RelatedIs there anyway to pass a parameter to an Excel spreadsheet (loaded in a browser) to use as a parameter in SQL statement?
I know that the Microsoft Technologies can write Excel files and then load them, but I'm looking to take an existing workbook, parameterize the SQL statement and pass parameters via the Querystring/Form Post to it.
Why you may ask? For existing PivotTables/Charts that can be filtered BEFORE they are run.
Any/all thoughts appreciated.
Bob
I have a flat file which contains like:
MEPMD01,19970819,test/ts1,35100,EASTERN,35100,200202140818,50767210,OK,E ,KHREG,1,00010014,02,200202130801,,00002651.556,20 0202140815,,00002668.860,
I want to transfer this file to a sql server database table.
My problem is how to send the above string to a table by formating like removing commas.
Can I do that using DTS. I need the answer very quickly.
Any help would be appreciated.
Or there is any better way to transfer the content to the table.
I want to post all the data in my company branch office in Lahore to the Head office in Peshawar. This will be done at the end of the day and the two SQL SERVERs synchronize data between both points over internet. what procedure should i use? and how the two computers will know the ip addresses of each other while connecting?
View 3 Replies View Relatedhi
I have binary files inside my database. and user should have the opportunity to download them from database to his computer. I don't want to retrive and save the file into the server first and then let him to download. is it posible???
thank you in advance
regards
hello
can sql server 2005 send messages to asp.net2.0 and to inform that a user hasn't (for example) the right to read a query
how?
thanks
Hi all;I need to generate an automatic mail alert based on the SQL server 2005 database to list of user (email) four times year based In this table there are dates according to that date it need to send email automatically four time each email after three month. I would be great full if you can find me solution for this issue. Thanks reem
write a backup to local disk and then run a command to send the file to the TSM Server.This is the command I use at a Command Prompt to do an TSM incremental backup.
Command for an incremental backup of drive letter h:
C:Program FilesTivoliTSMaclientdsmc incremental h:
Command for an incremental backup of a mount point:
C:Program FilesTivoliTSMaclientdsmc incremental -domain="E:Backup"
I would like to be able to run this as the last step in my backup processes. This would allow me to send my local backup file to the TSM server to write to tape.
I am looking for either a CMDEXEC Expert that could show me the syntax to run these commands via a direct command or a batch job. The other option would be to run these commands via the Powershell type.
Hi All,I have to write a stored procedure which will send/Receive text filefrom/to a server by using FTP.Is anybody have done anything on it? or know about it.If yes, I would like to know about it. (also provide the storedprocedure code if possible)Thanks in Adv.T.S.Negi
View 3 Replies View RelatedI have developing sample application for automatically send failure mail to respective person. Also i have storing all the failure mail details to database for unavailability of mail server. Once if the mail server available that time we will send all the failure mail to respective person.
View 5 Replies View RelatedHi everyone
i get an error messgae running the following code
DECLARE @mailist VARCHAR(max)
SET @mailist=''
SELECT TOP 1 @mailist=@mailist + email +';'
FROM
email.dbo.mytable
SET @mailist=STUFF(@mailist,LEN(@mailist),1,'')
SET @mailist='''' + @mailist + ''''
EXEC msdb.dbo.sp_send_dbmail
@profile_name='my_mail_profile',
@recipients=@mailist,
@subject='mysubject',
@body_format='html',
@body=
'
<html>
<head>
<title>
problems with send_dbmail
</title>
</head>
<body>
this is not working
</body>
</html>
'
The error says:
quote:
Syntax error in parameters or arguments. The server response was: 5.5.4 Invalid Address)
At the other hand, if i assign a straightforward @recipints address such as
EXEC msdb.dbo.sp_send_dbmail
@profile_name='my_mail_profile',
@recipients=my@mail.com
It works
Anybody know why ?
Thanks
Hello,
I mistakenly deleted my source table data.
Now i want to again migrate the data from MS Aceess table to the SQL server table.
Please tell me
As far as i remember I used some export or import command.
Thank You
please dont send me link...i have to do it now so no time to read
Good evening,
I want to use ssis to export data from relational tables in sql server 2005 and import them into an xml column in sql server 2005.
Any suggestions for the best way to do this.
I created an datareader source using adventure works with the sql command "SELECT * FROM purchasing.vendor FOR XML RAW"
I then created a sql server destination with and mapped the output from above to an xml column.
I get the following error
Error: 0xC0202009 at Data Flow Task, SQL Server Destination [596]: An OLE DB error has occurred. Error code: 0x80040E14.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "XML parsing: line 1, character 2033, unexpected end of input".
Is there a better way to attack this? I'd prefer not to need to send to the file system, etc.
Thanks,
Alan
Hello
I want some ides rearding sending mail at specified time. I want to send mail at everyday 3:00AM from SQL Server. I have stored procedure to send mail.
Thanks in advance
Hem
Hi Guys,
I have already spent so many days in trying to find a solution to this problem but ..all in vain....
so please help me.
I have to send message to my running .Net [Asp.Net with C#] application from sql server. How can i do it?
We should not use notification services.
Please give me some examples / links.
Thanks in advance!