Viewing 15 posts - 1,081 through 1,095 (of 1,518 total)
Mani Singh (7/3/2008)
did you Login using Administrator Authentication, before running the Memory Counters.
Thanks for the response.
Yes, I'm connecting as an admin.
July 4, 2008 at 2:13 pm
Thank you, I will try that.
July 2, 2008 at 8:44 pm
Mani Singh (6/29/2008)
If you have Many Dimensions and Fact Tables and Millions of Rows and it is a performance...
June 30, 2008 at 10:26 am
Jonathan Kehayias (6/28/2008)
June 28, 2008 at 11:55 am
For the purposes of this debate, what is the point of invoking SQLCLR code outside a SQL context?
I'm wondering if this is even necessary.
What are the possible scenarios for this?...
June 28, 2008 at 7:10 am
Jonathan Kehayias (6/27/2008)
(1) Create a new schema that will hold the SQLCLR objects
(2) Create an asymmetric key from the assembly dll
(3) Create a login from the asymmetric key
(4) Grant EXTERNAL-ACCESS-ASSEMBLY...
June 28, 2008 at 7:05 am
Dan English (6/27/2008)
June 27, 2008 at 4:00 pm
The purpose of a SQLCLR assembly is for it to be invoked from within SQL code.
You don't need to call it from .NET code.
What is your assembly doing?
June 26, 2008 at 10:26 am
Federico del Blanco (6/25/2008)
LinkedServer properties:ServerOption -> RCP = True?
Yes, that was already in place.
June 25, 2008 at 2:03 pm
We figured it out.
The server name of the server on which the query was running was added to the hosts file of the target server (the server pointed to...
June 25, 2008 at 10:39 am
Thank you for the response.
The queries we are using for inserting/updating data (thousands of rows) through a linked server are very slow at the moment, that's why I thought to...
June 24, 2008 at 9:35 am
dan griffin (6/23/2008)
June 23, 2008 at 9:35 am
A good starting point is reading through this link:
Microsoft SQL Server Management Pack:
http://technet.microsoft.com/en-us/library/cc511079(TechNet.10).aspx
Out of the box SCOM monitors a limited subset of things, such as service and database availability and...
June 19, 2008 at 7:57 am
The sticky point with all this is that because of all the potential issues surrounding a move to 64-bit, many companies will hesitate to go ahead with it.
Sure, one...
June 18, 2008 at 11:01 am
Grant Fritchey (6/18/2008)
I can recommend three sources that can help, in addition to posting here (althouth...
June 18, 2008 at 8:21 am
Viewing 15 posts - 1,081 through 1,095 (of 1,518 total)