Viewing 15 posts - 1,621 through 1,635 (of 7,168 total)
It is just the two Fuzzy transforms that require Enterprise Edition to execute on the server side. But BIDS will run those for you no matter what Edition you have...
March 14, 2013 at 1:49 am
BinaryDigit (3/12/2013)
A random question, if you write queries and put the schema before objects will it affect performance in any way and if so what type of metrics are we...
March 14, 2013 at 1:08 am
brettstahlman (3/13/2013)
If I understand correctly, the recursion is indirect, and hence, should not be prevented by RECURSIVE_TRIGGERS disabled (the setting in my database).
I do not think it is considered indirect....
March 14, 2013 at 12:38 am
Barkingdog (3/13/2013)
March 14, 2013 at 12:18 am
sankar276 (3/13/2013)
Assign db_executor, db_datareader, db_datawriter roles to user.
db_executor?
March 13, 2013 at 10:43 pm
I agree, this task is better left to a client application but you are not the first person to ever want this to be delivered through the database engine. SQL...
March 13, 2013 at 10:35 pm
What is the reason you want to replicate to MySQL?
March 13, 2013 at 10:28 pm
+1 for exploring Replication
This might be the most common use-case for implementing Transaction Replication with a real-time Push Subscription. A nice benefit is that you can have a separate index...
March 13, 2013 at 10:25 pm
Can you post a screenshot?
Just a shot in the dark, but if the server name referenced by the task is . (dot, meaning local server) or localhost then when opening...
March 13, 2013 at 10:15 pm
SQL Server does have the notion of a Dedicated Admin Connection (DAC), but I do not think that's quite what you're asking about. I am not sure you can draw...
March 13, 2013 at 10:12 pm
cathy.baker (3/13/2013)
My guess was also the SPN being registered. I do have our System Admin looking into that option.
Look in the SQL Error Log for an entry that says...
March 13, 2013 at 9:44 pm
+1 to least privilege. Adding members to db_owner is great for allowing developers access to a development database but beyond that I think it should rarely be handed out, if...
March 13, 2013 at 9:40 pm
No, not really. You'll have to configure something, whether it be a Connection Manager in SSIS, a format file or command line for bcp, or some other bulk loading program,...
March 13, 2013 at 9:36 pm
You can expand the Flat File Connection Manager column property to accept more than 30 characters and then run the data through a Derived Column Transformation to apply a TRIM()...
March 13, 2013 at 4:52 pm
Erin Ramsay (3/13/2013)
March 13, 2013 at 9:56 am
Viewing 15 posts - 1,621 through 1,635 (of 7,168 total)