Viewing 15 posts - 1 through 15 (of 63 total)
I realized that we can use a like filter based on domain account pattern: 'domain\[a-z][a-z][0-9][0-9][0-9][0-9]%', this seems to work, thanks for the replies..:-)
December 19, 2013 at 6:53 am
Hi let me explain by the error log records, (all instances are SQL 2008 R2):
For all my log shipping secondary databases error log looks like: (1 row per restore)
Log was...
July 17, 2012 at 12:59 am
You're correct but this is not the default behavior for log shipping in no recovery mode.
May 18, 2012 at 9:26 am
Hi I do think It can be related to driver, It is OLEDB provider for SQL Server, (the default when SQL Server is chosen).
There is no trigger on table....
February 14, 2012 at 4:53 am
I added a link to this post, can you remove dublicate post post?
February 14, 2012 at 3:37 am
Replies here please:
http://qa.sqlservercentral.com/Forums/Topic1251727-391-1.aspx
February 14, 2012 at 3:36 am
Is there a way to delete old post?
February 14, 2012 at 3:24 am
By the way, I tried computed index, it also resolved the cross join..
February 2, 2012 at 6:14 am
Thanks Howard,
I now realized that 24 million is populated by the cartesian product of
[TuzakTelefonlar] X [VpIVRCallValidationLog] with(nolock)
where TransactionTime > DATEADD(hour,-5,GETDATE())
This is due to nested loop choice then.
February 2, 2012 at 5:48 am
Perry Whittle (1/6/2012)
granting permissions on the xp worked for me, i suspect the account trying to grant has insufficient permissions
In my case when I make the executing user sysadmin, xp...
January 9, 2012 at 12:23 am
I also tried signing xp_instance_regread with a certificate but it gives alter procedure error. ( I guess because it is a system procedure)
January 6, 2012 at 8:27 am
This was the best option but application is a sealed application, and what is said to us is, the master.sys.xp_instance_regread procedure will be used..
January 6, 2012 at 8:22 am
yes, the error is :
Msg 22001, Level 16, State 1, Line 0
xp_instance_regread() returned error 5, 'Access is denied.'
January 6, 2012 at 8:12 am
For me too.. thanks
November 15, 2011 at 1:52 am
Viewing 15 posts - 1 through 15 (of 63 total)