Viewing 15 posts - 4,321 through 4,335 (of 8,416 total)
paul.knibbs (3/31/2010)
April 3, 2010 at 3:31 am
The alarm relates to the overall processor queue length, and is user-configurable. Whether you should be concerned or not depends on whether this is a frequent condition or just...
April 3, 2010 at 3:19 am
Jeffrey Williams-493691 (4/2/2010)
SQL Server will take all of the memory up to the max memory setting. It does not guarantee that it will take all of it.
I would just...
April 3, 2010 at 3:12 am
parthenitin (4/3/2010)
When we creates the primary key it alwas enforce to create as Clustured.how it will enforce to create as NonClustered.
Please Can u tell me.
Use the NONCLUSTERED keyword.
April 3, 2010 at 2:53 am
vaibhav.tiwari (4/3/2010)
...only valid dates which can be format in default.
The point is that what is 'default' for you is not 'default' for me.
It depends on the settings I described earlier.
April 3, 2010 at 2:48 am
isakhnov (4/3/2010)
SUSER_SID returns the SID of test\userA and I'm looking at ways to retrieve the SIF matching the specified on a server login (test\groupB)
From Books Online: "'login' is the login...
April 3, 2010 at 2:45 am
DBA_Dom (4/2/2010)[hrI am saying that we were somehow somewhere given the impression that the system default that a server starts with out of the box was a fill factor of...
April 3, 2010 at 2:37 am
Check the status using the Log Shipping Report and take corrective action.
April 3, 2010 at 2:32 am
isakhnov (4/3/2010)
How can I retrieve the SID of the login?...
SUSER_SID retrieves my windows account SID
...
I do not see a way to retrieve a SID for the login itself.
SUSER_SID ('login') retrieves...
April 3, 2010 at 2:28 am
This only works if the database is offline because it failed to start, or is damaged in some way.
Setting an otherwise good database to OFFLINE explicitly does not work.
April 3, 2010 at 1:56 am
Not sure if this has already been mentioned, but another alternative (using a similar approach to snapshot replication) would be to set up an SSIS package. This could be...
April 3, 2010 at 1:42 am
Daniel C (4/2/2010)
Forgot to say thanks for the solution, I'm itching to see it implemented.
No worries, though I think the implementation more complex than it needs to be:
Setup:
IF ...
April 3, 2010 at 1:26 am
Mr Guy-323725 (4/2/2010)
Thanks for your reply. Your way works, but is there a way to have a "OR" in the RegEx?
It is not a regular expression, and no there...
April 3, 2010 at 12:54 am
The Dixie Flatline (4/2/2010)
All things in moderation.
Except moderation?
April 3, 2010 at 12:51 am
Jeff Moden (4/2/2010)
April 3, 2010 at 12:49 am
Viewing 15 posts - 4,321 through 4,335 (of 8,416 total)