Viewing 15 posts - 1,621 through 1,635 (of 7,164 total)
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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....
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 14, 2013 at 12:38 am
Barkingdog (3/13/2013)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 14, 2013 at 12:18 am
sankar276 (3/13/2013)
Assign db_executor, db_datareader, db_datawriter roles to user.
db_executor?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 13, 2013 at 10:35 pm
What is the reason you want to replicate to MySQL?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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,...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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()...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 13, 2013 at 4:52 pm
Erin Ramsay (3/13/2013)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 13, 2013 at 9:56 am
j.bluestein (3/13/2013)
glad to hear you've loaded the file and your table has that...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 13, 2013 at 9:54 am
Viewing 15 posts - 1,621 through 1,635 (of 7,164 total)