Viewing 15 posts - 136 through 150 (of 163 total)
jack.kennedy (2/24/2010)
The SQL as written will generate an error:
Msg 111, Level 15, State 1, Line 2
'CREATE TRIGGER' must be the first statement in...
February 24, 2010 at 1:36 am
stewartc-708166 (2/23/2010)
Schema definitions are case sensitive.
therefore the schema of the table given as dbo, while the schema of the trigger is Dbo.
removing the trigger schema or making it...
February 24, 2010 at 1:28 am
Hi,
I don't agree with the statement in the explanation that this is an "undocumented ability".
Both "global temporary procedures" and "global temporary tables" can be found in the index of BOL,...
December 31, 2009 at 1:59 am
Hugo Kornelis (10/1/2009)
Mighty (10/1/2009)
I'm of the opinion that the answer(s) are incorrect.CUBE and ROLLUP where already available in SQL Server 2005, so they were not introduced with SQL Server 2008.
SQL...
October 1, 2009 at 3:59 am
I'm of the opinion that the answer(s) are incorrect.
CUBE and ROLLUP where already available in SQL Server 2005, so they were not introduced with SQL Server 2008.
October 1, 2009 at 1:14 am
ChiragNS (9/23/2009)
oops!! thought the checkboxes where radio buttons.
Same for me. Would have been better to add "select all that apply" to the question, like it is normally done.
September 23, 2009 at 1:30 am
Andrew Watson (6/25/2009)
June 25, 2009 at 7:37 am
Irish Flyer (6/25/2009)
Who cares?? What does Access have to do with REAL databases?
Not too much, so in that respect the question of matching a MS Access data type to...
June 25, 2009 at 7:23 am
Maybe it's just me, but I read the question differently, looking for the SQL Server data type to match the MS Access data type. Might be that my English is...
June 25, 2009 at 6:00 am
Maybe the author of the question used information related to how Oracle stores char(1) and varchar2(1) data. There the space used on disk will be the same.
From a design perspective,...
June 5, 2009 at 8:22 am
Steve Jones - Editor (1/7/2009)
securing a cluster can have multiple meanings, and encryption would be a valid one. So I think the question was misleading and have corrected that.
For me...
January 7, 2009 at 9:20 am
Irish Flyer (1/7/2009)
From SQL Server 2005 Books Online (search under clusters [SQL Server]\encryption):
Encryption on a Cluster
If you want to use encryption with a failover...
January 7, 2009 at 8:10 am
I see no way how the question can imply a full backup being taken on any other time.
Hi Hugo,
the reason why I think there was a full backup is...
December 11, 2008 at 3:01 am
Hugo Kornelis (12/11/2008)
you cannot use the log backup to recover the database
since it implies that you can MAKE a log backup after creating a...
December 11, 2008 at 2:31 am
Viewing 15 posts - 136 through 150 (of 163 total)