Viewing 15 posts - 16 through 30 (of 47 total)
was a fix ever found? I am having the same problem with SQL 2008r2
April 30, 2015 at 7:08 am
Thanks for your reply.. We don't use FK... 🙁
Are there other indexes on the table? (besides the PK and CI) - Yes
How is the data inserted (in CI...
March 12, 2015 at 9:47 am
Thanks, i ask because this connection is defined within the package, and when it is selected as part of running the package via a sql agent job(so it is selected...
December 4, 2014 at 1:25 pm
Thank you kindly...down to 14 seconds....
i will be looping through 20 times based on locations in a table.
October 2, 2014 at 3:56 pm
Hi,
I am now experiencing an issue where 'SQL' users are not allowed to insert into the DDLEVENTS table?
Does granting 'public' only work with windows AD users and group?
The server principal...
July 28, 2014 at 6:56 am
Giving the Service account 'domain admin' privileges for a brief time allowed the SPN error to correct itself or register properly.
Thank you
July 10, 2014 at 12:26 pm
I have tried all these fixes an none worked....any other suggestions?
changed service account
drop server name/re-added.
Any other suggestions. In our environment this happened out of the blue....a user called and...
July 10, 2014 at 10:30 am
Thank you for your assistance! much appreciated!
April 4, 2014 at 9:46 am
CREATE TRIGGER DDLTrigger_OBJECT
--ALTER TRIGGER DDLTrigger_OBJECT
ON DATABASE
WITH ENCRYPTION
FOR CREATE_PROCEDURE, ALTER_PROCEDURE, DROP_PROCEDURE, CREATE_TABLE, ALTER_TABLE, DROP_TABLE
AS
BEGIN
SET NOCOUNT ON;
...
April 3, 2014 at 11:52 am
Yes i run the Proc and use dbmail(not select or print)
EXEC msdb.dbo.sp_send_dbmail
@profile_name='tets_profile',
@recipients=@Recipient_Email, ...
March 11, 2014 at 6:45 am
Hi,
I am running into this same problem, i changed the job step to point at :
C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\DTExec.exe
have the job running as Operating system(CmdExec)
"C:\Program Files (x86)\Microsoft SQL...
January 28, 2014 at 1:00 pm
Stepping through this is see that it is evaluating each IF statement during each iteration...not what i wanted..
November 1, 2013 at 11:02 am
as a first step i fixed the loop, used variable for count. I tried before(and failed) and will try again to use row_number, and will also try the load into...
July 22, 2013 at 2:05 pm
Viewing 15 posts - 16 through 30 (of 47 total)