Viewing 15 posts - 646 through 660 (of 819 total)
This is an old problem with sql2000 too: restoring a database on a different instance, logins to database become invalid.
The solution is create login on the restoring instance with the...
February 7, 2011 at 1:16 am
Thank you Koen (da-zero).
Now, the qotd seems more clear!
😀
February 2, 2011 at 7:41 am
Koen (da-zero) (2/2/2011)
paul s-306273 (2/2/2011)
So, is the correct answer 'FALSE'?
No, it is TRUE.
You cannot use the /Set or the /Connection option to override single values that are also set by...
February 2, 2011 at 6:36 am
I think that the answer is FALSE, because the question asks
you CANNOT override a property from the command-line.
Then, the explanation says that
the command line always “wins”
, that means...
February 2, 2011 at 1:14 am
It's a good idea to repeat the QOTD until everybody answers correctly.:-D
January 31, 2011 at 1:08 am
Avoid beginners to update production table is the better way to avoid disaster!
In the author concept thers's a BIG BUG!
If before the trigger as described in the article another trigger...
January 27, 2011 at 1:28 am
luciano furlan (1/25/2011)
I miss a configuration on Sql server that states "Where Clause mandatory". For...
January 25, 2011 at 3:50 am
I get it right because of excluding the wrong choices.
January 21, 2011 at 1:13 am
Koen (da-zero)
And what if your company or your client uses an older version of SQL Server (there are still some SQL 2000 or older out there. SQL Server 2005 is...
January 11, 2011 at 1:46 am
Koen (da-zero) (1/10/2011)
Good, but difficult question. I had to read quite some BOL pages to get this one right.And only 1 point?
I get it wrong, because I don't want waste...
January 11, 2011 at 12:54 am
Thank you! I learned something new and I'll take care of this for database maintenance.
😉
January 7, 2011 at 1:41 am
Koen (da-zero) (1/6/2011)
toddasd (1/6/2011)
January 7, 2011 at 1:26 am
Viewing 15 posts - 646 through 660 (of 819 total)