Viewing 15 posts - 166 through 180 (of 521 total)
According to http://technet.microsoft.com/en-us/library/ms186388.aspx it can NOT be set as read_only:
The following operations cannot be performed on the model database:
Setting the database or primary filegroup to READ_ONLY.
Oh wait... according to the...
April 15, 2010 at 6:12 am
Am I missing something? I can actually set the database to read-only:
ALTER DATABASE MODEL SET READ_ONLY WITH NO_WAIT
Command(s) completed successfully.
Microsoft SQL Server 2005 - 9.00.4053.00 (Intel X86) ...
April 15, 2010 at 12:48 am
da-zero (4/12/2010)
isn't the variable @InputStr stored somewhere? As the loop goes on forever, at some point in time that variable will become too large to reside in memory/physical...
April 12, 2010 at 6:42 am
werner.broser (4/12/2010)
This is partly true, because as usual conversion will take place, and if possible to convert the string to an integer it would be returned, otherwise an error occurskr/Werner
We...
April 12, 2010 at 5:34 am
Thank you, Paul. This is great work. Not only the code & explanation, but equally important: the design of the article. Very easy to read with good illustrations & examples....
April 12, 2010 at 1:38 am
Paul White NZ (4/11/2010)
First one to whinge about the explanation being 'incomplete' gets a banana :w00t: 😛
Me want the banana *whingingabouttheexplanation*! 😀
No results returned, as an infinite loop is invoked....
April 12, 2010 at 1:18 am
Paul White NZ (3/30/2010)
vk-kirov (2/10/2010)
In the example above, we will see request_mode = Sch-M (schema modification). This is specific to DDL events.
Not true. From Books Online - Lock Modes:
Some...
April 6, 2010 at 1:55 am
We already had a similar question before.
If a number string can be converted to any numeric type, ISNUMERIC returns 1.
Among the known "issues" with this are:
money: 1,,,,,,1 is a valid...
February 22, 2010 at 1:19 am
yordan.georgiev (2/19/2010)
2005 does not have table variables ...
It does suport table variables, and so does SQL Server 2000.
You probably are talking about table variables as parameters.
February 19, 2010 at 12:56 am
I knew I was gonna miss this QOTD as soon as I read the name "Paul Randal" 😀
February 17, 2010 at 3:41 am
brad.green (2/16/2010)
February 17, 2010 at 3:31 am
Great Article!
Regarding the "just say no" - I think this is a good general baseline.
But I also think this problem mostly arises when the service level and / or job...
February 12, 2010 at 5:21 am
I wonder why there is no DDL trigger available to capture this of event...
February 5, 2010 at 1:23 am
Viewing 15 posts - 166 through 180 (of 521 total)