Recently Indexed Messages:-



SQL Server 2014 :: Passing Malformed Email Address To Send Mail Task?

Feb 5, 2015

I am implementing a fax solution (Right Fax) and pulling email information from a table and passing into a variable. In order to send out a fax via email, the syntax is in the following example below:

Example:

To send a fax from Outlook to Jane Doe at 555-1212, enter:

[RFAX:Jane Doe@/FN=555-1212]

When the following syntax gets passed into the Send Mail Task, into the "To" line and the package is executed I'm receiving the following.

[Send Mail Task] Error: An error occurred with the following error message: "The specified string is not in the form required for an e-mail address.".

[Send Mail Task] Warning: The address in the "To" line is malformed. It is either missing the "@" symbol or is not valid.

I realize it’s a malformed email address. Is it possible to create a group and instead of the fax syntax pass the group name?

View 8 Replies

Integration Services :: How To Edit A Package

Apr 28, 2015

I found a problem in the SQL that's a part of a SSIS package written by a third party, which is in our SQL Server 2008 R2 database. I've discussed this with the third party person; she's given me the necessary changes to the SQL. But I don't know what to do next.We've got this package on a test database server. I've got SSIS open to Stored Packages and have drilled down to the necessary folders to find it. But beyond that I don't know what to do. I understand that BIDS is involved, but that's as far as my understand of it goes.

View 3 Replies

SQL 2012 :: Restore MDF Then Apply Logs / Point In Time

Jun 6, 2014

Our backup system has worked ok for us to date. We can restore back to either full saves or up to a certain log (we take log backups on the hour). We've never had to, but wanted to test restoring to a point-in-time with the backup data.

What the system does is generates .mdf and .ldf files, which is essentially a full backup say in the middle of the night. It then creates .bak files for the log backups based on the backup set you want to restore.

I can detach the database and apply the .mdf and .ldf and re-attach the database, but to apply the .bak files I need to get the database into a (recovering) state. I can't seem to do that. Otherwise when I try to apply the .bak files the system says: The log or differential backup cannot be restored because no files are ready to rollforward.

How to apply a .mdf and then apply the .bak files?

View 7 Replies

SQL 2012 :: MSDTC In Multi-node / Multi-instanced Cluster

Aug 17, 2015

More often than not, I typically don't touch DTC on clusters anymore; however on a project where the vendor states that it's required. So a couple things here.

1) Do you really need DTC per instance or one for all?
2) Should DTC be in its own resource group or within the instance's group?
2a) If in it's own resource group, how do you tie an instance to an outside resource group? tmMappingSet right?

View 9 Replies

SQL 2012 :: How To Reconcile Logins Between Two Server Instances

Oct 16, 2015

I am in the process of writing a generic PowerShell script (that executes T-SQL statements) to copy all or some databases from one SQL Server 2012 SP2 instance to a second instance that runs SQL Server 2012 SP2 or higher. The script is designed to be used on demand, and part of its execution will involve reconciling the logins between the source and destination instances.

I am looking for a reliable way to reconcile the logins between the instances in a somewhat repetitive (i.e., "on demand") fashion. There is no SSIS in the environment; so the SSIS transfer logins task to not available to me.

View 5 Replies

Integration Services :: Master Package Is Executing Upto Certain Point Only

Jul 31, 2015

I have a sql agent job which runs the Masterpackage, Master package has aroung 35 child packages calling in it. Issue with this Master package is it running upto 30 child packages and I get success message on  job. It is not executing packages beyond 30 what could be the problem. I disabled the all the 30 child packages and ran it again it ran those other 5 child packges without any problem.

View 2 Replies

SQL 2012 :: Run SSIS Package In 32 Bit Mode Using BAT File

Jan 9, 2015

I have a bat file that kicks off a master package, which kicks off about 300 child packages. My bat file is working correctly, however there seems to be issues executing packages in 64 bit mode.

So my question is...

Is there a way to specify in the bat file to execute packages in 32 bit mode and not 64 bit?

bat file:
"C:Program FilesMicrosoft SQL Server110DTSBinnDTExec.exe" /f "E:MasterPackage.dtsx"

View 1 Replies

SQL 2012 :: Grant Read-only Access To Windows Logins On Remote Standby Database

Mar 23, 2015

We log ship our production database tansaction logs to a secondary database on a separate remote domain.

Incidentally, this was not set up via the "Ship Transaction Logs" wizard, but instead we had to use the various system stored procedures after restoring a copy of the database on the remote domain in standby mode.

We now have an issue where users are unable to access the remote secondary database without having sysadmin privileges. Clearly we want to avoid this!

We want to be able to use Windows Authentication mode on the server of the secondary database. But since the two domains differ, is it possible to even achieve this?

How can we set up read-only access for users on the secondary database without giving them sysadmin privileges?

View 3 Replies

Transact SQL :: Replacing Invalid Characters In A Field

Oct 6, 2015

When we are getting data in a table and we want to replace characters with other characters. For example, We have a table with a street address, and there are numerous ascii character values we want to review and replace if they exist. We were looking at using a table with 2 columns, 1 containing each ascii character value the other it's preferred replacement value. Then updating the street address searching through each ascii character and replacing it if needed. Currently, we are running it through a looping process searching each individual address for each ascii character, and updating it.

View 4 Replies

SQL 2012 :: Finding Lock Escalation Cause

Jun 17, 2015

While running SQL Server Profiler I reached some Lock:Escalations. When I searched for Statements having same SPID as Lock:Escalation event I realized that one of delete statements causes this. Is there any way to find out why lock escalation in such place occurres?

Statement is like:

delete from BOOK_IN_LIBRARY where libraryId in (,,,,); <-20 elements ids

CREATE TABLE BOOK_IN_LIBRARY(
[libraryId] [bigint] NOT NULL,
[bookId] [bigint] NULL,
[otherData] [bigint]NULL,
[otherData2] [int] NULL,

[Code] ....

View 0 Replies

SQL Server 2012 :: How To Rearrange The Execution Plan Manually

Nov 27, 2014

I have 2 tables,

1. Need
2. NeedCategory

Need table has clusted index on needid column and NeedCategory have composite clustered index on needid and categoryid.

Now take a look on following query and execution plan for the query.

SELECT N.NeedId,N.NeedName,N.ProviderName
FROM dbo.Need N
JOIN dbo.NeedCategory NC
ON nc.NeedId = n.NeedId
WHERE IsActive=1
AND CategoryId= 2
ORDER BY NeedName

* Clustered index scan on need table is happens for Isactive= 1.

* Clustered index scan on needcategory table is happens for CategoryId=2

My question is,

1. Why scan happens before the join occurs? if it happens after join then the filter would be lighter. Even if optimizer chooses the scan to execute first.

2. Is there any chance to rearrange the execution plan manually?

View 6 Replies

Update Table With Tinyint In Stored Procedure

Oct 17, 2014

I've got a sp that goes well. Except for the tinyint value, that doesn't update in the table.

ALTER PROCEDURE[dbo].[spTelling]
(
@ScanNummer NVARCHAR(13),
@Basis tinyint,
@CurrentTal INT OUT
)

[Code] ...

The insert statement works. But I want also to update Basis (tinyint) in the table Telling.

WHENMATCHED
THENUPDATE
SETtgt.Tal += src.Tal

Where must I write

set basis = @Basis

if you do not try, it will not work....

View 5 Replies

SQL Server 2012 :: How To Write Stored Procedures To Load Data Model From OLTP To DWH

Nov 24, 2014

How to write Stored Procedures to load the Data Model from OLTP to DWH ?

View 9 Replies

DB Design :: Partition With Single File Group Or Multiple File Group?

May 19, 2015

partition with single file group or multiple file group which one best.

we have some report running from partition table, few reports don't have any partition Key and after creating 400  partition  with 400 file group it is slow.what is best practices to crate  400 file group or single file group.

View 9 Replies

SQL 2012 :: Combining Multiple Servers Into Instances

Oct 14, 2015

Curious what the industry standard is combining multiple instances on single server ?

Right now i have separate servers for OLTP, SSAS, and SSIS, and for OTP have Development, Test, and production environments. Im considering combining the SSIS and SSAS services into additional instances on each environment servers.

Now (Production)
OLTP
SSAS
SSIS

After

1 Server with 3 separate instances for SSAS, SSIS, OLTP. Then replicate this model through the environments to utilize development and testing.

View 2 Replies



Copyrights 2005-15 www.BigResource.com, All rights reserved