Viewing 15 posts - 226 through 240 (of 260 total)
Did you tried tracking it down to what that spid was actually doing using DMV's or any other traces? Did you already tried that and found nothing useful?
Go through this...
December 16, 2013 at 1:50 pm
sreekanth bandarla (12/16/2013)
Virtual or Physical Server? Hope this post will be of help.
To be more specific...
December 16, 2013 at 12:45 pm
Virtual or Physical Server? Hope this post will be of help.
December 16, 2013 at 12:44 pm
wessambaroudi (12/16/2013)
Thanks for your replyDid I forget to mention I only have standard edition.
Cheers
Wessam
Log Shipping is totally supported in Standard Edition. Should be able to query against your Standby...
December 16, 2013 at 11:19 am
tejaswi161 (12/10/2013)
December 10, 2013 at 12:10 pm
What version of SQL Server you are running on? If 2008 or above, you can simply turn on TDE at the database level if that's Okay with your Organization.(Yes, It...
December 10, 2013 at 12:00 pm
Did you tried querying sys.database_permissions?
select * from sys.database_permissions where grantor_principal_id = user_id ('USERNAME')
December 9, 2013 at 2:51 pm
Please double check the path where SSISDB backup is going to...
By default, SSMS will choose "C:\Program Files\Microsoft SQL Server\110\DTS\Binn" for creating the SSISDB backup, not your default Backup directory, hence...
December 5, 2013 at 9:55 am
Am curious to know what's the OS? Is it Windows Server 2012 or Windows Server 2008R2?
December 4, 2013 at 3:46 pm
Looks like this will help you...
The latest changelog says "Added support for Registered Servers functionality of SSMS "
December 4, 2013 at 3:35 pm
I don't think 'sa' is mandatory for Foglight account. You may want to check with DELL or Foglight Documentation to make sure.
December 4, 2013 at 3:13 pm
Oops! I overlooked the Edit portion...Thanks for correcting me!
November 25, 2013 at 9:35 am
OFFLINE INDEX REBUILD should work fine....Online index rebuild reads the old index to build the new one so the new index has the same missing rows as the old one....
November 25, 2013 at 9:18 am
Viewing 15 posts - 226 through 240 (of 260 total)